Database - Microsoft SQL Opspack

Microsoft SQL Server is a relational database management system. 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. Microsoft markets numerous editions of Microsoft SQL Server aimed at varying audiences/workloads (ranging from small single-machine applications to large Internet-facing applications) and our Opspack allows you to monitor your Microsoft SQL server to ensure it is operating correctly every step of the way.

What You Can Monitor Copied

Opsview Monitor contains all the important service checks to make sure your Microsoft SQL Server is up and running. Service Checks for Microsoft SQL Server include:

• Database size, memory, and agents checks
• Database Log Information
• SQL Stats including Server cache statistics and wait statistics
• SQL transactions per second, time to connect and more

Service Checks Copied

Expand table

Setup and Configuration Copied

Network Dependencies Copied

TCP port 1433 needs to be open to allow the Opsview Monitor server to connect to the monitored host. For more details, see the Microsoft document Configure the Windows Firewall to Allow SQL Server Access

Creating a monitoring user Copied

• Create a new user, either use “Windows Authentication” or “SQL Server Authentication”.

• If using “SQL Server Authentication” remove “Enforce password expiration” and “user must change password at new login”.

• Populate the sections as below:

  • SERVER ROLES: Select “public” and “sysadmin”.
  • USER MAPPING: Leave as default.
  • SECURABLES: Click “Search..”, select “All objects of the types..”, and then “Servers” and click OK. Then scroll down the lists to find the permission titled “View server state”, and check “Grant”.
  • STATUS: Ensure “Grant” and “Enabled” are checked respectively.

Add the Host Template Copied

Add the Database - Microsoft SQL Host Template to your Opsview Monitor host.

Note

For more information, refer to the documentation on Adding Host Templates to Hosts.

Add and configure variables required for this host Copied

Expand table

Note

For more information, refer to the documentation on Adding Variables to Hosts.

Apply Changes Copied

Apply Changes and the system will then be monitored:

Plugin help Copied

Secure Args

The check_mssql_database.py plugin uses the Secure Args feature for argument passing.