Take Control of SQL Server Monitoring

Applications Manager SQL Server Monitoring software capability helps DBAs monitor the performance and availability of production databases. It is an agentless monitoring solution that provides out-of-the-box performance metrics for ensuring the SQL Server runs efficiently.

Applications Manager provides a web client that helps you visualize a SQL Server Database farm and provides in-depth monitoring data that helps you make educated decisions about usage patterns, plan capacity and alert you of impending problems. The Root Cause analysis window helps the operations team to troubleshoot performance problems quickly. Additionally the grouping capability helps you to group your databases based on the business process supported and helps the operations team to prioritize alerts as they are received.

SQL server monitoring has the ability to connect to the database source & monitor various system table column values, collect data, etc. and also notify through alerts, if the database system properties are beyond a given threshold.

Some of the components that are monitored in MS SQL database are:

• Memory Usage
• Buffer Manager Statistics
• Connection Statistics
• Cache Details
• Lock Details
• SQL Statistics
• Latch Details
• Access Method Details