BlueCollarCritic
My feedback
1 result found
-
176 votes
currently under investigation
An error occurred while saving the comment An error occurred while saving the comment BlueCollarCritic
commented
I just got a look at some more alerts and found outthat some do have more choices then I realized. When I saw that the Backup Alert had no way to specify what DB's to include/exclude it seemed as if the alerts in General were lacking configuration choices. That said hey still need expansion or enhancing. For example the Long Running Query. While the current config options let you exclude items using name matching (regular Expressions) that is fine if all the items to exclude have a name pattern. But what if you want to select specific Objects??? There may be a way to do it with RegExp but I would think that would be a very long expression to list multiple items.
An error occurred while saving the comment BlueCollarCritic
commented
In the area of expanding Alert Configuration options I'd like to suggest the ability to add exclusions. This would depending on the alert provide the user the ability to exclude specific objects, events, time periods or other as appropriate.
For example in the backup alert configuration it would be most beneficial if one could specify what DB's to trigger the alert for. This would allow the exlcuding of one or more DB's which may not need to be backed up.
An error occurred while saving the comment BlueCollarCritic
commented
The Alerts are great but very limited in their configuration, Several other ideas here that are alert specific fall under this broader idea of improved Alert Configuration options. I was shocked when I went to configure an alert for the first time and found the choices were to change the level and ion some cases to change the duration (i.e. backups) required to trigger the alert. Beyond changing the alert level and enabling it or disabling it there's not much one can do to change how the alerts work and this is one area that this otherwise great product is very short on.
I have several specific Alert Configuration ideas but I wanted to press the point abiut alert conbfigurations over all needing to be greatly expanded in how they are configured.
BlueCollarCritic
supported this idea
·
@Priya Sorry for not rpelying sooner but we just now got our license for SQL Monitor and so its been off line for several weeks (It was the trial copy I was using when I posted the eblow).
I did find the path (after reading your post) on how to configure the BACKUP DB Alert for a specific database.
That said there are still way too many constraints on the Alerts. Another good example is TIME Exceptions where you don't want an alert triggered if it occurs at or within a specific time. THere are shceduled time when our server is unavaiable (Maintenance) and all the triggers that woudl be raised when a DB is not respsonsive are then triggered because of this and that result in a lot of false positives if we choose to leave those alerts enabled.
Make sense?