This section provides information about using SQL Server with AppDynamics for Databases.
SQL Server provides 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.
AppDynamics for Databases 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 fundamentally what is the root cause of any database slow downs.