Find all the service models dedicated to the supervision of your SQL Server Application.

BOX mode

MS-SQL-Process

Tests the presence and functioning of the sqlservr process (MS SQL service). 

Available from version
3.13

MS-MSSQL-single-database-free

Checks the remaining space (in percentage) on the database instance (.mdf database file and .ldf transactions log file). Alert in case of threshold overrun.

Configuration: login and password (optional domain) to access the database, alert and critical thresholds (percentage), database name, instance name.

Available from version
3.13

MS-MSSQL-TransactionsPerSec

Measures the number of transactions per second on each database of a particular SQL Server instance or database. Alerts when a threshold is exceeded.

Configuration: SQL Server monitoring account, alert threshold and critical alert threshold, name of the monitored database.

Available from version
3.13

MS-MSSQL-Instance-LockWaitsPerSec

Collects the number of pending resource unlocks per second at the Microsoft SQL Server instance level. Supported Versions: All editions of Microsoft SQL Server. Configuration: account and password of a user with remote access rights to WMI performance counters, user domain, alert and critical thresholds, MS SQL Server instance.

Available from version
3.13

MS-MSSQL-Instance-PageLifeExpectancy

Collects the lifetime in seconds of the pages in the cache of the Microsoft SQL Server instance. Supported versions: all editions of Microsoft SQL Server. Configuration: account and password of a user with remote access rights to WMI performance counters, user domain, alert and critical thresholds, MS SQL Server instance.

Available from version
3.13

MS-MSSQL-Instance-PageSplitsPerSec

Collects the number of memory page fragmentations when writing/reading records per second at the Microsoft SQL Server instance level. Supported versions: all editions of Microsoft SQL Server. Configuration: account and password of a user with remote access rights to WMI performance counters, user domain, alert and critical thresholds, MS SQL Server instance.

Available from version
3.13

MS-MSSQL-Instance-ProcessesBlocked

Collects the number of blocked processes on the Microsoft SQL Server instance. Supported versions: all editions of Microsoft SQL Server. Configuration: account and password of a user with remote access rights to WMI performance counters, user domain, alert and critical thresholds, MS SQL Server instance.

Available from version
3.13

MS-MSSQL-Instance-ProcessesBlocked_notdsfile

Collects the number of blocked processes on the Microsoft SQL Server instance. Supported versions: all editions of Microsoft SQL Server. Configuration: account and password of a user with read access rights to the master database of the instance, user's domain, alert and critical thresholds.

Available from version
4.8

MS-MSSQL-Instance-RecompilationsPerSec

Collects the number of SQL recompilations per second at the Microsoft SQL Server instance level. Supported versions: all editions of Microsoft SQL Server. Configuration: account and password of a user with remote access rights to WMI performance counters, user domain, alert and critical thresholds, MS SQL Server instance.

Available from version
3.13

MS-MSSQL-Instance-UserConnections

Collects the number of user connections at the Microsoft SQL Server instance level. Supported versions: all editions of Microsoft SQL Server. Configuration: account and password of a user with remote access rights to WMI performance counters, user domain, alert and critical thresholds, MS SQL Server instance.

Available from version
3.13

MS-MSSQL-request-integer

Executes an SQL query on a database that returns a value of type Integer. Changes state when thresholds are crossed on the value returned by the query. Supported versions: all editions of Microsoft SQL Server. Configuration: the identifier between [] indicated in /etc/freetds.conf on the supervision server, an account and a password of a user having the execution rights of the query, SQL query, alert threshold, critical threshold.

Available from version
3.13

MS-MSSQL-Request-String

Executes a SQL query on a database and returns a String value.

Changes state if the 1st column of the query matches or does not match the searched string. If a second column is part of the query result then its content is displayed in the plugin output.

Supported Versions: All editions of Microsoft SQL Server and Sybase.

Configuration: the identifier between [] indicated in /etc/freetds.conf on the supervision server, an account and a password of a user with the rights to execute the query, name of the database, SQL query, searched string (regex possible), presence status, absence status.

Prerequisite: The query must return only one line. The first column is compared with the string. The second column is used to display an additional text in the plugin output.

Available from version
3.18

MS-MSSQL-single-database-backup-age

The number of hours that have elapsed since the last backup of an MS SQL Server database instance. Configuration: the database instance, the account and password of the user with access to the database, the number of hours above which the status changes to ALERT, the number of hours above which the status changes to CRITICAL, the name of the database. The instance must be defined on the supervision server. The user must have the role serveradmin on the instance.

Available from version
3.13

MS-MSSQL-Database-PageSplitsRate

Measures the number of fragmented pages in relation to the overall number of batch requests. Supported versions: all editions of Microsoft SQL Server. Configuration: the identifier between [] indicated in /etc/freetds.conf on the supervision server, an account and a password of a user with read access rights on sys.dm_os_performance_counters, user's domain, alert threshold, critical threshold.

Available from version
3.13

MS-MSSQL-Database-PendingDiskIO

Calculates the number of pending disk IOs. Supported versions: all editions of Microsoft SQL Server. Configuration : the identifier between [] indicated in /etc/freetds.conf on the supervision server, an account and a password of a user with read access rights on sys.dm_os_schedulers, user's domain, alert threshold, critical threshold.

Available from version
3.13

MS-MSSQL-Database-RecompilationRate

Measures the rate of recompilations in relation to the total number of batch requests. This rate must not exceed 1%. Supported versions: all editions of Microsoft SQL Server. Configuration : the identifier between [] indicated in /etc/freetds.conf on the supervision server, an account and a password of a user with read access rights on sys.dm_os_performance_counters, user domain, alert threshold, critical threshold.

Available from version
3.13

MS-MSSQL-Database-SignalWaits

Measures the latency of SQL sessions due to processor resources. This rate should not exceed 20-25%. Supported Versions: All editions of Microsoft SQL Server. Configuration: The login between [] specified in /etc/freetds.conf on the monitoring server, an account and password of a user with read access rights on sys.dm_os_wait_stats, user domain, alert threshold, critical threshold.

Available from version
3.13

MS-MSSQL-Database-State

Monitors the status of a database list and changes status when at least one database is not in ONLINE status. Supported versions: all editions of Microsoft SQL Server. Configuration : the identifier between [] indicated in /etc/freetds.conf on the monitoring server, an account and a password of a user with read access rights on sys.databases, user's domain, database white list, database black list.

Available from version
3.13

MS-MSSQL-Database-StoredProcedure-Runtime

Collects the execution time of stored procedures associated with a database. The status changes when the execution time of at least one stored procedure exceeds the alert thresholds over the specified analysis period. Alert thresholds are indicated in microseconds. Configuration: the identifier between [] indicated in /etc/freetds.conf on the supervision server, the database, a regular expression identifying the stored procedures, an account and a password of a user having the rights to execute the request, alert threshold, critical threshold, analysis period in hours-days minutes.

Available from version
3.13

MS-MSSQL-Instance-BatchRequestsPerSec

Collects the number of batch requests received by the Microsoft SQL Server instance per second. Supported versions: all editions of Microsoft SQL Server. Configuration: account and password of a user with remote access rights to WMI performance counters, user domain, alert and critical thresholds, MS SQL Server instance.

Available from version
3.13

MS-MSSQL-Instance-BufferCacheHitRatio

Collects the page access ratio from the cache of the Microsoft SQL Server instance. Supported versions: all editions of Microsoft SQL Server. Configuration: account and password of a user with remote access rights to WMI performance counters, user domain, alert and critical thresholds, MS SQL Server instance.

Available from version
3.13

MS-MSSQL-Instance-CheckpointPagesPerSecond

Collects the number of pages written to disk during a synchronization operation on the Microsoft SQL Server instance. Supported versions: all editions of Microsoft SQL Server. Configuration: account and password of a user with remote access rights to WMI performance counters, user domain, alert and critical thresholds, MS SQL Server instance.

Available from version
3.13

MS-MSSQL-Instance-CompilationsPerSec

Collects the number of SQL compilations per second at the Microsoft SQL Server instance level. Supported versions: all editions of Microsoft SQL Server. Configuration: account and password of a user with remote access rights to WMI performance counters, user domain, alert and critical thresholds, MS SQL Server instance.

Available from version
3.13

MS-MSSQL-Connected-Users

The total number of users connected to the MS SQL Server database instance. Configuration: the database instance, the account and password of the user with access to the database, the number of users above which the status changes to ALERT, the number of users above which the status changes to CRITICAL. The instance must be defined on the supervision server. The user must have the role serveradmin on the instance.

Available from version
3.13

MS-MSSQL-ConnectionTime

The time in seconds it takes to establish a connection to the MS SQL Server database instance. Configuration: the database instance, the account and password of the user with access to the database, the number of seconds above which the status changes to ALERT, the number of seconds above which the status changes to CRITICAL. The instance must be defined on the supervision server. The user must have the role serveradmin on the instance.

Available from version
3.13

MS-MSSQL-Database-AverageTasksCounts

Calculates the number of tasks in progress and the number of CPU pending tasks. Supported versions: all editions of Microsoft SQL Server. Configuration : the identifier between [] indicated in /etc/freetds.conf on the supervision server, an account and a password of a user with read access rights on sys.dm_os_schedulers, user's domain, alert threshold, critical threshold.

Available from version
3.13

MS-MSSQL-database-backup-age

Configuration: the database instance, the account and password of the user with access to the database, the number of hours above which the status changes to WARNING, the number of hours above which the status changes to CRITICAL. The instance must be defined on the SNB. The user must have the serveradmin role on the instance.

Available from version
3.13

MS-MSSQL-Database-BufferPoolIoRate

Calculates the rate, in MB/s, at which memory pages are recycled into the buffer space. Supported versions: all editions of Microsoft SQL Server. Configuration: the identifier between [] indicated in /etc/freetds.conf on the supervision server, an account and a password of a user with read access rights on sys.dm_os_performance_counters, user domain, alert threshold, critical threshold.

Available from version
3.13

MS-MSSQL-Database-CompilationRate

Measures the compilation rate in relation to the total number of batch requests. This rate must not exceed 10%. Supported versions: all editions of Microsoft SQL Server. Configuration: the identifier between [] indicated in /etc/freetds.conf on the monitoring server, an account and a password of a user with read access rights on sys.dm_os_performance_counters, user domain, alert threshold, critical threshold.

Available from version
3.13

MS-MSSQL-database-free

Specifies the percentage of disk space remaining for the database instance and changes state when this percentage falls below a configured threshold. Configuration: the database instance, the account and password of the user having access to the database, the percentage below which the status changes to ALERT, the percentage below which the status changes to CRITICAL. The instance must be defined on the supervision server. The user must have the role serveradmin on the instance.

Available from version
3.13

MS-MSSQL-database-job-status

Controls the correct execution of SQL jobs over the entered period. If at least one job is incomplete, the status changes to "Alert". If at least one job is in error

Available from version
3.13

MS-MSSQL-Database-MemoryGrant

Calculates the number of pending memory requests. This counter must be equal to 0. Supported versions: all editions of Microsoft SQL Server. Configuration : the identifier between [] indicated in /etc/freetds.conf on the supervision server, an account and a password of a user with read access rights on sys.dm_os_performance_counters, user's domain, alert threshold, critical threshold.

Available from version
3.13

MS-MSSQL-Database-PageLookupsRate

Measures the page access rate in relation to the overall number of batch queries. Supported versions: all editions of Microsoft SQL Server. Configuration: the identifier between [] indicated in /etc/freetds.conf on the supervision server, an account and a password of a user with read access rights on sys.dm_os_performance_counters, user domain, alert threshold, critical threshold.

Available from version
3.13

MS-MSSQL

Tests if the instance is started and reports additional information about the use of the database. Notifies if the test fails. Configuration: user account (role: sysadmin) on MSSQL server, the instance of the database also declared in the supervisor. INFO the queried database is: "master".

Available from version
3.13

AGENT mode

A-MS-SQL-Time-to-get-request

Connects to a Microsoft SQL Server database, indicates connection success or failure, performs an SQL query, and notifies if the query execution time exceeds a critical and alert threshold level. Configuration: database instance and name, database access user and password (domain user with read rights to the database), SQL query, alert threshold and critical threshold for the query execution time.

Available from version
3.13

A-MS-SQL-nb-Connections

Connects to a Microsoft SQL Server database, indicates connection success or failure, the number of current connections on the selected instance, and notifies if the number of current connections exceeds an alert and critical threshold level. Configuration: database instance, database access user and password (domain user with read rights to the database), alert threshold and critical threshold for the number of current connections.

Available from version
3.13

A-MS-SQL-Print-request

Connects to a Microsoft SQL Server database, performs an SQL query passed as an argument. Indicates the success or failure of the connection and the content of the query (with a limit of 512 characters). Configuration: database instance, database access user and password (domain user with read rights on the database), SQL query.

Available from version
3.13

A-MS-MSSQL-database-backup-age

Retrieves the number of hours since the last backup of the MS SQL Server database instance. Configuration: the database instance, the account and password of the user with access to the database, the number of hours above which the status changes to ALERT, the number of hours above which the status changes to CRITICAL.

Available from version
3.13

A-MS-MSSQL-database-backup-age-dbname

The number of hours that have elapsed since the last backup of an MS SQL Server database instance. Configuration: the database instance, the account and password of the user with access to the database, the number of hours above which the status changes to ALERT, the number of hours above which the status changes to CRITICAL, the name of the database.

Available from version
3.13

Documentation

Configuring MS SQL Server database monitoring

Monitoring configuration requirements for Windows devices

en_US
fr_FR en_US

Welcome to ServiceNav!

Need help? More information about our products? Write to us!
You have taken note of our privacy policy.

[COVID - 19 ] - TELEWORKING, TARGET AVAILABILITY 100% !

While the epidemic lasts, ensure the availability and performance of your IT services for teleworking, with ServiceNav!

Following the government's call to mobilize to help businesses overcome the current health and economic context, we help you, free of charge, to ensure the complete monitoring of your teleworking environments: VPN, VDI, Teams, Skype Enterprise, Citrix... Objectives: collection, availability and usage indicators, dashboards to support your communication.
We use cookies to ensure that you have the best possible experience on our site, and if you continue to use this site, we will assume that you are satisfied with it.

Reserve your place

You have taken note of our privacy policy.