Free SQL Health Monitor MS SQL Monitoring made easy
Download

Free SQL Health Monitor Ranking & Summary

Free SQL Health Monitor Tags

server monitor MS SQL database monitor

Free SQL Health Monitor Description

Free SQL Health Monitor is a handy utility designed to monitor important parameters of MS SQL databases. Free SQL Health Monitor fetches comprehensive data about the MS SQL database servers and presents them as visually elegant graphs and reports. The relevant data, graphs and reports are displayed in a desktop tool dashboard providing wealth of information about the real-time functioning of the Database. Free SQL Health Monitor can monitor two MS SQL servers simultaneously. This tool serves as a smart desktop tool that continuously monitors MS SQL database and host server, giving real-time monitoring capability. The tool will enable your organization to scale database operations with confidence and improved IT efficiency. For any MS SQL database monitoring need, this tool comes handy for DB Administrator (DBA). Main features: 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. 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.

Free SQL Health Monitor Related Software