How to enable and configure the SQL Server monitoring

 

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

 

 

 

 

Graphical user interface, application

Description automatically generated

 

How to enable notifications for the Microsoft SQL server Monitoring

 

 

 

 

SQL Server module can notify on:

  • Long query execution times

  • Deadlocks

  • Almost filled databases with auto-growth disabled

  • Custom query filters

 

Graphical user interface, application, Word

Description automatically generated

 

A custom query filter represents a monitored query that has one or more conditions and 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

 

Verify your users’ identities

 

Enforce identity verification to prevent third parties from impersonating logged-in users.

 

Set up identity verification

 

Remind me later

 

Have more questions?

Contact us

Was this article helpful?
0 out of 0 found this helpful

Provide feedback for the Documentation team!

Browse this section