• Active Directory
  • Application
  • Desktop & Mobile
  • Help Desk
  • Network
  • IT Security
  • MSP
  • On-Demand
 
 
Device Management, made easy
Manage control and secure your workstations, mobile
devices and tablets
 
 
Help Desk for Everyone
IT Help Desk Software and Customer Support Software
 
 
Protect Your IT. Save Your Business
Build a secure fortress with our security management solutions
 
 
MSP
Manage services faster, with multi-tenanted, ITIL-ready, and unified RMM solutions
 
 
On-Demand Solutions
IT Help Desk, Active Directory, and Operations Management from the Cloud
 

SQL Health Monitor – Features

ManageEngine SQL Health Monitoring helps monitor MS SQL servers for CPU Utilization, Memory, Disk, Bandwidth and Database performance metrics.

This tool monitors the following parameters

General Windows Server details

CPU Utilization

Monitor CPU usage at regular interval. You can also set critical and warning threshold limits and get alerts when threshold limits are exceeded.

Memory Utilization

Check memory utilized at periodic intervals and get alerts when the memory usage is high.

Disk Utilization

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.

SQL Server Session Statistics

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.

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 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.

Free pages

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