MS SQL Azure Performance Monitoring by DataSunrise
The tools monitor database performance thus simplifying Azure SQL operation assessment, contributing to an immediate identification of bottlenecks during database operation as well as operating delay causes.
With Database Performance Monitoring Tools you will be able to examine initiated scripts and detect the one that causes problems. You may also evaluate queries executed in transactions and eliminate vulnerabilities that endanger Azure SQL running.
Analyze the query log, for instance, to identify redundant or unexpected by a developer queries. Examine the query result log and bring to the surface vulnerabilities that may occur during application functioning. This may be handy, when logging in an application itself is not enough or when there is no application logging altogether. Inspect query change dynamics, consider execution frequency of INSERT/UPDATE/DELETE/SELECT types, study diagrams clarifying how they change in time, etc.
To sum up, for Azure SQL operation assessment DataSunrise provides with the following Database Performance Monitoring Tools:
- query log;
- query result log;
- query execution time;
- query types;
- row number in INSERT/UPDATE/DELETE/SELECT operations;
- operation number per second;
- data volume transmitted/received by a server;
- other Azure SQL behavior information required for troubleshooting.