SQL Server 2000 Monitoring

The DBTuna performance management solution has coverage for SQL Server 2000, 2005 and 2008 therefore has great coverage of the most popular and widely used enterprise database platform of today.

DBTuna for SQL Server uses exactly the same resource consumption and wait state approach to monitoring for all versions of SQL Server. It uses it's own unique approach to monitoring, where tiny snapshots are taken sub-second which builds up a complete picture of what is happening on your SQL Server instance. Within minutes DBTuna can capture and display which users, programs, machines and sessions are active within the instance, also which database they are active in, and most importantly what SQL or Stored Procedure they are executing.

DBTuna is designed to monitor busy production databases 24x7 without impacting on the performance of the instance. It uses agentless technology which allows it to monitor remotely, meaning that there is no agent consuming resource on the database machine. Being agentless, it also means that the installation is rapid; all you need to do is provide a user (either SQL or Windows Authenticated) and network connectivity to the instance, nothing else.

The depth of data collected from DBTuna is comprehensive, and allows detailed drilldown. The Database Administrator can view the resource consumption profile of his SQL instance, drill into a performance spike and then find the underlying root cause in seconds.

DBTuna maintains a repository of historical performance data. This gives the DBA the ability not only to see what is happening now, but what has happened over the last day, the last week or the last month. Having historical performance data greatly facilitates problem resolution and allows the DBA to answer important questions such as: i) What happened to the online application yesterday to make it slow down ii) Why is the overnight batch job still running this morning at 8:55 etc.

A single installation of DBTuna can support virtually any version of Oracle, as well as MySQL, SQL Server and Sybase ASE database platforms.