Monitoring and collecting data from MSSQL - Microsoft SQL Server
Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network (including the Internet). Microsoft markets at least a dozen different editions of Microsoft SQL Server, aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users.
More information on: https://www.microsoft.com/en-us/sql-server/
How it works
The plugin gathers global stats using the performance counter client. The MSSQL performance schema is used to retrieved query stats such as queries per second, latencies and errors.
The minimal supported version of MSSQL is 2008 R2.
The plugin needs to be installed together with a CoScale agent, instructions on how to install the CoScale agent can be found here. If you want to monitor MSSQL inside Docker containers using CoScale, check out the instructions here.
The authentication to the database can be done using integrated security (SSPI) or username/password.
When using integrated security (SSPI), the plugin connects to MSSQL using the credentials from the Windows/Domain user configured to run the Windows Service. In MSSQL Server, ensure a login is configured for this Windows/Domain user.
If you want to use a Login authentification type, deselect integrated security and then set a username (with the right credentials) and a password.
This plugin can be configured to perform a SQL query on your MSSQL. This active monitoring allows us to calculate the uptime of the service and the response time of the query.
A valid SQL query (eg.
select count(*) from my_table;) should be provided.
|Mssql - Lock Timeouts/sec||req/s|
|Mssql - Lock Waits/Sec||req/s|
|Mssql - Page Splits/sec||splits/s|
|Mssql - SQL Compilations/sec||#/s|
|Mssql - SQL Re-Compilations/sec||#/s|
|Mssql Average Latch Wait Time||s|
|Mssql Batch Requests/sec||req/s|
|Mssql Buffer Cache Hit Ratio||%|
|Mssql Checkpoint Pages/Sec||pages/s|
|Mssql Forwarded Records/sec||rec/s|
|Mssql free list stalls/sec||req/s|
|Mssql Full Scans/sec||#/s|
|Mssql Index Searches/sec||#/s|
|Mssql lazy writes/sec||writes/s|
|Mssql Memory Grants Pending||b|
|Mssql Number of Deadlocks/sec||req/s|
|Mssql page life expectancy||s|
|Mssql page lookups/sec||pages/s|
|Mssql page reads/sec||pages/s|
|Mssql page writes/sec||pages/s|
|Mssql processes blocked||procs|
|Mssql SQL Cache Memory||b|
|Mssql Target Server Memory||b|
|Mssql Total Server Memory||b|
|Mssql User Connections||conn|
|MSSQL Service state watcher||State watcher||status|