MS SQL Server Monitoring Tool – Features
ManageEngine SQL Health Monitoring tool helps monitor MS SQL servers for CPU Utilization, Memory, Disk, Bandwidth and Database performance metrics.
This tool monitors the following parameters
Monitor CPU usage at regular interval. You can also set critical and warning threshold limits and get alerts when threshold limits are exceeded.
Check memory utilized at periodic intervals and get alerts when the memory usage is high.
View available disk space and get notified when the disk space falls below the margin. Disk with partition views and read/write details is also available.
Logins/Logouts per second
Total number of logins/logout per second. If it is greater than 2, it indicates that the application is not currently using the connection pooling.
Batch Requests per second
This shows the number of Transact-SQL command batches received per second.
SQL Compilations per second
This indicates the number of times the compile code path is entered. It should be less than 10% of Batch Requests per second.
SQL Recompilations per second
Number of statement recompiled per second. This value should be less than 10% of SQL compilations per second.
Buffer Cache Hit Ratio
Percentage of pages found in the buffer cache without having to read from disk. It is preferred to be above 90%.
Checkpoint pages per second
Number of pages updated to disk per second by a checkpoint or other operation that require all the dirty pages to be flushed.
Lazy writes per second
Number of buffers written per second by the buffer manager's Lazy writer. Lazy writer is a system process that flushes out batches of dirty, aged buffers and makes them available to user process.
Page reads/writes per second
Number of physical database page reads issued. 80 to 90 per second is normal.
Page writes per second
Number of physical database page reads/writes issued per second. 80 to 90 per second is normal.
Shows total number of pages on all free lists. Below 640 indicates that the SQL Server is running low on physical memory.