Microsoft SQL Server is a proprietary relational database management system developed by Microsoft.

InfraSonar Collector

The Microsoft SQL probe uses SQL statements to monitor and analyze the health of a Microsoft SQL Server database.

The MSSQL probe offers a unified view that provides common ground for infrastructure engineers, DBA, and application managers to analyze and troubleshoot Microsoft SQL server performance issues.

Features

The MSSQL probe allows for in-depth analyses of a SQL server.

Some of the included measurements:

• Memory Page life Expectancy.

• Parallelism configuration.

• CPU, memory and disk IO per database.

• Microsoft SQL server CPU usage

• SQL Table information.

• Wait statistics.

• Top 25 query information (all queries would put too much strain on the SQL server).

• Top worker time; which queries consume a lot of time and thus cpu usage.

• Top logical reads; which queries cost the most IO.

• Top execution count; shows the most active queries.

• Index information.Frequently used indexes (top used).

• Missing indexes, where would an index make sense.

• Unused indexes, only written but never queried.

• Microsoft SQL server missing indexes

• Fragmentation.

• IO, per file and per volume.

• Backup status.

• Agent jobs.

• SQL Config.

• Session and application information.

• Plan cache.

• Blocked count.