SQL Server Monitoring Doesn't Have To Be Expensive!
While SQL CoPilot sits there waiting for you to investigate an issue or generate a multi-instance best practices report it is busy keeping an eye on your SQL Servers.
A time-out has occurred while attempting to connect to a SQL Server instance.
One or more processes has been blocked for a set amount of time. The threshold is fully configurable.
Error in the Log
One or more errors have been recorded in the error log. You can define the minimum error severity that triggers this. Other common errors, such as stack dumps and non-yielding schedulers, are also detected.
Failed or Canceled Job
Checks for any enabled SQL Agent job that has failed or been canceled within a set amount of time (configurable).
Long Running Process
Sometimes a query running for too long is an indication of other underlying problems. The threshold for this is configurable.
Low Disk Space
How low is low? You can define multiple levels for this. For example, a warning at 20% free and critical at 5% free.
Any database that is not online, restoring or the secondary in a mirroring/AlwaysOn configuration.
Checks for overdue full, differential and log backups. Different thresholds can be set for each of these.
If a SQL service restarts or a failover in a cluster occurs it may happen too quickly for the "instance unavailable" check to detect it. This is an additional check to ensure it isn't missed.
Tag instances for easy management.
Quickly define which tags to monitor via the Quick Setup function.
Change alerting thresholds if you don't like the defaults.
See each monitored instance color-coded according to maximum severity.
Number of alerts of each type summarised in toolbar.
A popup appears in the top right for a few seconds as each alert is raised.
Click on an instance in the dashboard to see a list of alerts for that instance only, or on one of the toolbar badges for the full alert list.
All current alerts or filtered by instance.
Ordered and color-coded with critical at the top. The list can be sorted by any column.
Click on any row and a new tab opens for the affected instance with the relevant dashboard displayed, depending on the alert.
Start for FREE today
- Increase DBA Productivity
- Quickly Find and Fix Issues
- Installs in Seconds