AppDynamics for Databases
2.9.x Documentation
Use sp_who or sp_who2 (sp_who2 is not documented in the SQL Server Books Online, but offers more details than sp_who) to provide locking and performance-related information about current connections to SQL Server. Sometimes, when SQL Server is very busy, you can't use Enterprise Manager or Management Studio to view current connection activity via the GUI, but you can always use these two commands from Query Analyzer or Management Studio, even when SQL Server is very busy.
AppDynamics for Databases offers a detailed current activity screen which uses information from the sp_who2 command. It also displays a graphical view of SQL Server CPU consumption and Wait Events for the last 5 minutes and a snapshot of current memory usage broken down by category.
Overview
Content Tools
Apps
