Free SQL Health Monitor Tool
MS SQL Monitoring – Features
ManageEngine SQL Health Monitor helps the DB administrators to monitors MS SQL servers. Tool's ability includes server performance monitoring to ensure the CPU Utilization, Memory, Disk, Bandwidth are with in permissible limits and monitoring SQL Database server performance metrics
Important Parameter Monitored are
Monitors CPU usage at regular interval - It helps administrator to know that if CPUs are running at full capacity or are they are underutilized.
Checks the Memory utilized at periodic intervals of your windows system. Get alerted when the memory usage is high .
Maintain a margin of available disk space. Get notified when the disk space falls below the margin. Disk with partition views is also available. Disk read /write details also available.
Active Database connections
This shows the number of active database connections.
Logins per second
Total number of logins started per second. If it is greater than 2, it indicates that the application is not currently using the connection pooling.
Logouts per second.
Total number of logout operations started per second.
Batch Requests per second
Number of Transact-SQL command batches received per second.
SQL Compilations per second
Number of compilations per second. 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 recompiles 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 flushed 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 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 writes issued per second. 80 to 90 per second is normal.
The Number of Pages in the buffer pool.
Total number of pages on all free lists. Below 640 indicates that the SQL Server is running low on physical memory.