I'm looking at trying to find a way to do the following.
For arguements sake, lets say that I have a single table in every database on my server. This table updates every 5 minutes with a datetime stamp via an SQL Agent task.
If, for any reason, a database becomes more than 15 minutes behind, I would like SQLDM to change the status of the server to "Warning" or "Severe" and, when i hover over it, I'd like it to say "Database X is Y minutes behind". (Much as we have the alert for Table Fragmentation > 75% on database XYZ")
I know exactly the SQL query I need to do this, however, what I dont know, is how to actually create such an alert?
Is it possible to create a custom alert on a database level? (I've seen custom counters, but that only seems to be a single, numerical value at a server level)
If the number of databases you need to monitor this way is relatively small, you could create a custom counter for every database and link them all to your instance.
This would work as well. You could even potentially create one custom counter first, export it, copy and modify the XML to have it applicable to different databases, then import the new XML that would be for the other databases. I'd probably make sure that the name of the custom counter reflected the specific instance and database that it was targeted for so that when SQLDM raises the alert, there's no question as to which instance and database it applies to.
Powered by IDERA