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

• Real-time MS SQL performance monitoring tool.
• Ensures MS SQL servers are up and running in the network.
• Provides a glimpse of server view and shows resource utilized is in optimal limit or it has exceeded the limit.
• Rich dashboard view shows sql server resources.
• Alert the administrator when resources like CPU, Memory, Disk , SQL cache exceeding the threshold value.

Important Parameter Monitored are

• General Windows Server details
• SQL Server General Statistics
• SQL Server Buffer Details
• SQL Server Memory Details
• Locks and Latches details
• SQL Server Database Details

General Windows Server details

CPU Utilization

Monitors CPU usage at regular interval - It helps administrator to know that if CPUs are running at full capacity or are they are underutilized.

Memory Utilization

Checks the Memory utilized at periodic intervals of your windows system. Get alerted when the memory usage is high .

Disk Utilization

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.

SQL Server Session Statistics

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.

SQL Server Buffer Details

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.

Total Pages

The Number of Pages in the buffer pool.

Free pages

Total number of pages on all free lists. Below 640 indicates that the SQL Server is running low on physical memory.