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.
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
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