Applications Manager's SQL Server monitoring feature helps database administrators monitor the performance and availability of production databases. It is an agentless monitoring solution that provides out-of-the-box performance metrics making sure that the SQL server runs efficiently.
Applications Manager provides a web client that helps you visualize and manage MSSQL server database farms and provides in-depth SQL monitoring data that helps you monitor usage patterns, plan capacity and notifies you of impending problems. The root cause analysis window helps the SQL Server DBA to troubleshoot performance problems quickly.
Additionally, the grouping capability helps you group your databases based on the business process supported and assists the operations team to prioritize alarms.
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 email or SMS if the database system properties cross a given threshold.
Some of the components that are monitored in MS SQL databases are:
Additionally, Applications Manager also provides the ability to monitor any SQL Query of a MS SQL Database by using the Database Query Monitoring capability. With this, a DBA can monitor additional performance metrics, monitor custom database tables and even monitor and display business metrics to business managers. Applications Manager provides you with wholesome Windows monitoring - Windows server monitoring, Microsoft .NET monitoring along with SQL Server monitoring.
Applications Manager's SQL Server monitoring allows you to monitor the overall health of a replication topology. Get summary information for all publications of a Distributor, subscriptions for the a selected Distributor and the performance of subscriptions.
Monitor information about SQL Server activity like - Current user connections and locks, process number, status, locks, and commands that active users are running and objects that are locked, and the kinds of locks that are present. You can perform ad hoc monitoring of an instance of SQL Server. This enables you to determine, at a glance, metrics like: