Enabling Microsoft SQL Server monitoring

NAVIGATION  VSA 10 Agent > Server Modules > SQL Server > Monitor and Manage SQL Server

Microsoft SQL Server is one of the most popular database servers available on the market. With VSA 10, you can view the table data, execute queries, view logs and much more.

Enabling notifications for SQL Server monitoring

NAVIGATION  VSA 10 Agent > Notifications > Server Modules > SQL Server

The SQL Server module can notify on the following:

  • Long query execution times
  • Deadlocks
  • Almost filled databases with auto-growth disabled
  • Custom query filters

A custom query filter represents a monitored query that has one or more conditions. When they match, a notification is delivered. 

Custom query filters have the following parameters:

  • Display Name: A unique display name that is used to identify the purpose of the filter
  • Database Name: The name of the database that the query will be executed upon
  • Query: A SQL statement that returns one row of results with at least one column
  • Execution Interval: Interval in minutes of the query execution
  • Conditions: One or more conditions that will be evaluated after the query executes
  • Notify When: Controls whether all conditions must match in order to deliver the notification
  • Notify When Priority: Priority of the notification that will be delivered when the conditions match
  • On Query Error: Controls if a notification will be delivered when the query fails to execute
  • On Query Error Priority: Priority of the notification that will be delivered when the query fails to execute

Configuring SQL Server via the System Details profile type

NAVIGATION  VSA 10 > Profiles > System Details (Device Configuration) profile type > Server Modules section > SQL Server

VSA 10 web application policy settings (if applied to the same device) will take precedence over the individual agent settings. Policies allow you to apply monitoring rules to multiple devices simultaneously. You can opt for policy settings to adopt the settings configured in the VSA 10 Agent by selecting the Use agent settings option for any setting in a profile.