SQL Server Monitoring Software

SQL Session Performance Monitoring

SQLDBManager Plus provides in-depth details on Connection Statistics, SQL Statistics, Active Connections, Logins/Min, Logouts/Minute, SQL Compliations/Min, SQL Recompliations/Min, etc. For example, by monitoring Logins/Min and Logouts/Min, the DBA can identify the distribution load on your critical database.

Connection Statistics Connection Time Active Connections Logins/Min Logouts/Min Session Details Session Lock Details Session Blocked Details

SQL Statistics Batch Requests/Min SQL Compliations/Min SQL Recompliations/Min AutoParams/Min Failed AutoParams/Min Safe Auto-Params/Min Unsafe Auto-Params/Min

These in-depth performance metrics allows the DBA to get a holistic view into the working of each database and its session. These information will also help pin-point resource intensive session(s) and help troubleshoot any performance issue it may cause. The DBA can also configure alarms and actions for each of these performance metric and be notified during breakdown in performance.

Host Details Hosts connected to SQL Number of Connections Memory Usage (MB) CPU Time (ms) I/O

Session Details PID Status User name Host Memory Usage (MB) CPU Time (ms) I/O Blocked DB Name Command Name Query

SQLDBManager Plus also allows the DBA to view the list of sessions running in the SQL server, its status and even terminate the session if required.