Non-Intrusive Database Monitoring, SQL performance monitoring, slow SQL monitoring

Non-intrusive Database Monitoring

No database permissions required, no performance interference, ultra lightweight SQL performance monitoring

1. Background of Requirements

Monitoring the content and performance of each SQL is a key requirement for database monitoring; The existing SQL performance monitoring methods for cloud databases either have a significant impact on database performance or require specific permissions for the database, and it is difficult to achieve monitoring of multiple types of databases in one interface;

In most cases, due to the high sensitivity and security requirements of the database itself, users need to record a full amount of SQL statements without affecting database performance and security, which can timely alert database anomalies and locate slow SQL;

More fine-grained monitoring content, on the other hand, requires in-depth analysis after first meeting these two commonly used functions.

2. Functional characteristics

TiFlow Microprobe and TiCenter can perfectly solve this problem; Its functional characteristics are as follows:

> Feature 1: does not affect performance and security

Non-serial deployment, non-implanted deployment, will not increase the latency of SQL queries, can be deployed on the calling side, not only suitable for managed databases, but also does not occupy database running resources, no database permissions, fully ensure the performance and security of the database;

> Feature 2: Fully record every SQL transaction

Fully record every SQL transaction Without affecting database performance, fully record the content and performance of each SQL query, and achieve real-time database SQL performance exception alerts, dashboard monitoring, and the ability to drill down to every abnormal SQL.

> Feature 3: Wider compatibility

Support multiple types of mainstream databases, and support various architectures, even public cloud hosted databases.