How to monitor SQL Server Performance?

SQL Server has much improved over the years in allowing the Database Administrator (DBA) access to detailed performance information. In Service Pack 3 of SQL Server 2000 a new function was introduced called fn_get_sql which exposed information about which SQL text is executing at any one time on the database. This information, along with information gathered from sysprocesses and other internal SQL Performance tables allows the DBA to gather detailed information about database performance bottlenecks. Further information is exposed in 2005 and later in 2008 which allows even more detailed performance data to be monitored.

DBTuna for SQL Server is a tool which takes advantage of these database features in order to monitor SQL server 24x7 and give the DBA visibility into which are his slowest or biggest resource consuming queries and fundementally what is the root cause of any database slow downs.

Information on DBTuna Features are available here

Copyright ©2010 DBTuna. All rights reserved.