Microsoft SQL Server is one of the most popular database servers available on the market. With Pulseway 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