SQL Monitor

Monitor the SQL, and the rest will become apparent!

In database performance management, the monitoring of SQL statements is of primary importance. If you pay attention to what SQL is consuming resource, waiting for I/O, or waiting in internal database states, then you can completely understand how your database is performing, and if, and when, problems occur.

It is the SQL that is a direct indicator of the response time of the end-user, program, or batch process. If you know the response time for the SQL is bad, then it is obvious that you have a problem further upstream, which the user will no doubt notice. Similarly, if SQL response times are fast, then do not waste time trying to tune! Many DBA's make the mistake that they use "traditional" indicators of performance such as cache hit ratio's to determine when to tune, but it's often the case that you can have a poor hit ratio (or similar metric) but the application can be running fine.

Only tune when the needs of the application dictate that you have to tune!

The DBTuna database performance management solution monitors SQL resource consumption 24x7 for Oracle, SQL Server and MySQL.

Why not download a copy today?

Copyright ©2010 DBTuna. All rights reserved.