SQL Server

Presentation

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

Service Models

BOX mode

MS-SQL-Processes

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

Available from version 3.13

MS-MSSQL-TransactionsPerSec

Measures the number of transactions per second on each database of a SQL Server instance or a particular 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-PageLifeExpectancy

Collects the lifetime in seconds of pages in the Microsoft SQL Server instance cache. Supported versions: all editions of Microsoft SQL Server. Configuration: account and password of a user with remote access rights to WMI performance counters, user's 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 on record writes/reads 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's domain, alert and critical thresholds, MS SQL Server instance.

Available from version 3.13

MS-MSSQL-Instance-ProcessesBlocked

Collects the number of blocked processes 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's 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 at the Microsoft SQL Server instance level. Supported versions: all editions of Microsoft SQL Server. Configuration: account and password of a user with read access rights to the instance's master database, 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's 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's domain, alert and critical thresholds, MS SQL Server instance.

Available from version 3.13

MS-MSSQL-request-integer

Executes a SQL query on a database that returns an integer value. 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 rights to execute the query, SQL query, alert threshold, critical threshold.

Available from version 3.13

MS-MSSQL-Request-String

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

Changes the state if the first 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 having the rights of execution of the query, name of the database, SQL query, searched string (possible regex), presence status, absence status.

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

Available from version 3.18

MS-MSSQL-single-database-backup-age

The number of hours since the last backup of a database of the MS SQL Server database instance. Configuration: the instance of the database, the account and password of the user having 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 serveradmin role on the instance.

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). Warns if thresholds are exceeded.

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-Database-PendingDiskIO

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

Available from version 3.13

MS-MSSQL-Database-RecompilationRate

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

Available from version 3.13

MS-MSSQL-Database-SignalWaits

Measures the rate at which SQL sessions wait for processor resources. This rate should not exceed 20-25%. Supported versions: all editions of Microsoft SQL Server. Configuration: the identifier between [] specified in /etc/freetds.conf on the monitoring server, an account and password for a user with read access rights to 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 the status when at least one database is not in ONLINE status. Supported versions: all editions of Microsoft SQL Server. Configuration: the identifier between [] specified in /etc/freetds.conf on the monitoring server, an account and password of a user with read access rights to sys.databases, user's domain, database whitelist, database blacklist.

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. The alert thresholds are indicated in microseconds. Configuration: the identifier between [] specified in /etc/freetds.conf on the monitoring server, the database, a regular expression identifying the stored procedures, an account and password of a user with query execution rights, 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's domain, alert and critical thresholds, MS SQL Server instance.

Available from version 3.13

MS-MSSQL-Instance-BufferCacheHitRatio

Collects the page access ratio in the Microsoft SQL Server instance cache. Supported versions: all editions of Microsoft SQL Server. Configuration: account and password of a user with remote access rights to WMI performance counters, user's 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 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's 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's domain, alert and critical thresholds, MS SQL Server instance.

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's domain, alert and critical thresholds, MS SQL Server instance.

Available from version 3.13

MS-MSSQL-ConnectionTime

The time in seconds needed 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 serveradmin role on the instance.

Available from version 3.13

MS-MSSQL-Database-AverageTasksCounts

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

Available from version 3.13

MS-MSSQL-database-backup-age

The number of hours since the last database 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. The instance must be defined on the supervision server. 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 [] specified in /etc/freetds.conf on the monitoring server, an account and password for a user with read access rights to sys.dm_os_performance_counters, user domain, alert threshold, critical threshold.

Available from version 3.13

MS-MSSQL-Database-CompilationRate

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

Available from version 3.13

MS-MSSQL-database-free

Indicates 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 with 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 serveradmin role on the instance.

Available from version 3.13

MS-MSSQL-database-job-status

Checks that the SQL jobs have been completed correctly for the period entered. 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 grant requests. This counter must be equal to 0. Supported versions: all editions of Microsoft SQL Server. Configuration: the identifier between [] specified in /etc/freetds.conf on the monitoring server, an account and password of a user with read access rights to sys.dm_os_performance_counters, user domain, alert threshold, critical threshold.

Available from version 3.13

MS-MSSQL-Database-PageLookupsRate

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

Available from version 3.13

MS-MSSQL-Database-PageSplitsRate

Measures the number of fragmented pages relative to the overall number of batch requests. Supported versions: all editions of Microsoft SQL Server. Configuration: the identifier between [] specified in /etc/freetds.conf on the monitoring server, an account and password of a user with read access rights to 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 returns additional information about the database usage. Notifies if the test fails. Configuration: user account (role: sysadmin) on MSSQL server, the database instance also declared in the supervisor. INFO the queried database is: "master".

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 serveradmin role on the instance.

Available from version 3.13

AGENT mode

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

Connects to a Microsoft SQL Server database, reports the success or failure of the connection, performs an SQL query, and notifies if the query execution time exceeds an alert and critical 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 query execution time.

Available from version 3.13

A-MS-SQL-nb-Connections

Connects to a Microsoft SQL Server database, indicates the success or failure of the connection, 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 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 a 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 user and password (domain user with read rights to 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 since the last backup of a database 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, the database name.

Available from version 3.13

Documentations

en_GB

Welcome to ServiceNav!

Do you need some help? More information about our products? Write to us!
You have taken note of our privacy policy.
We use cookies to ensure the best experience on our site. 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.