AppManager for Microsoft SQL Server provides a comprehensive solution for monitoring the performance and availability of your SQL Server environment.
With AppManager for Microsoft SQL Server, you can:
Quickly identify fault lines or factors that might adversely impact performance and take preventive action
Plan and schedule timely upgrades
Isolate the causes of server performance problems and address them on time, ensuring better performance for your enterprise
Run Knowledge Script jobs on SQL Server components
Run Knowledge Script jobs directly on SQL Server virtual servers in a clustered environment
AppManager for Microsoft SQL Server provides Knowledge Scripts designed to give you a comprehensive view of how SQL Server performs on your servers. The Knowledge Scripts in the SQL Server category monitor the following:
SQL Server accessibility and connectivity
Blocked SQL Server processes
Frequency at which pages are retrieved from SQL Server cache
SQL Server data space and log space
Locked databases
SQL Server Error logs
SQL Server and reports on jobs that have not completed successfully
SQL Server services
SQL Server user connections
Total CPU time used by SQL Server users and their connections
Number of read and write operations
Total number of locks held by SQL Server users and their connections
Number of memory pages allocated to by SQL Server users and their connections
Mirrored database status
CPU percentage used by SQL Server processes
Memory used by SQL Server processes
Log shipping status
Node ownership of a SQL Server failover cluster instance or Always On Availability Group
You can set thresholds that specify the boundaries of optimal performance. You can also configure AppManager to raise events when those thresholds are crossed.
In addition to monitoring, you can use SQL Server Knowledge Scripts to collect performance data for use in reports. AppManager lets you generate reports that range in scope from minute-by-minute values to monthly values over a period of years. These reports range in purpose from evaluating a narrow window of performance data to illustrating trends that aid in effective planning.