The SQL Server monitor type is capable of monitoring several key aspects of a Microsoft SQL Server database. The monitor uses the native SQL Server interface and does not require an ODBC driver installed on the Network Monitor host machine.
These fields are required to connect to the database to perform configured tests.
Logon account - The logon account contains the credentials to use when authenticating with the SQL Server database.
Instance name - The SQL server instance name to use.
Database name - Name of database to connect to.
Port - The port number the database server listens to. Defaults to port 1433.
Protocol type - Default protocol, TCP/IP, Named Pipes, Shared Memory
Data type - SQL query value. This is the only option currently supported.
Performance monitoring
Note: Leave these fields blank to not perform these tests.
Max users - Maximum number of allowed users logged on at the same time.
Buffer cache hit ratio - The buffer cache hit ratio indicates the percent of the total number of requests that have been served without accessing the disk. A higher value translates into better database performance. Set this value to the lowest acceptable value. If the ratio falls below this value the monitor fails the test.
Max replication latency - A value in seconds that is the maximum difference in time between master and slave. If this time is exceeded the monitor fails the test.
SQL compilations - A numeric value that is the maximum number of SQL compilations that can occur per second. If this value is exceeded the monitor fails the test. A high value of SQL compilations per second can result in high CPU usage.
Tablespace monitoring options
Note: Leave these fields blank to not perform these tests.
Table space is associated with physical files stored on disk. Each database can be associated with one or more table spaces, for the storage of tables and indexes. Monitoring tablespace usage enables you to be warned before the remaining free space in a table space passes below a threshold.
Database disk usage - A threshold value that sets the maximum allowed usage of a table space in percent. This field applies to all table spaces in the database, subsequent fields can be used to configure exceptions from this rule for up to five other table spaces.
Tablespace usage / % max usage (1-5) - A threshold value for the maximum allowed usage for a specific table space. These fields override the global table space threshold.
Threshold settings
An optional SQL statement can be executed and its output compared to a predefined value using a compare operation.
SQL query - Optional SQL query to perform.
Fail if no rows - Check this option to make the monitor fail the test if the query returns no rows.
Value type - Type of value that is compared with the retrieved value from the database.
Compare operation - Operation to evaluate the returned query result and the compare value, to determine if the test succeeded or failed.
Compare value - Value to compare query result with.
SQL server account
Inherit credentials - If checked, inherits credentials from the asset. If blank, enter monitor-specific credentials.
Username/password - Credential used to authenticate access for this monitor.
