I am looking for some advice on possibly creating custom counters to supplement/replace the alerts for the “Database Full (Percent)” and “Log Full (Percent)” metrics.
There are 2 things that I would like to accomplish:
1. I would like to be able to have alerts set up for different percentages depending on the size of the database. If I have a 1gb database and a 100gb database, I have different levels of concern with what percentage they are at. On a 100gb, slow growing db, I may not want alerted until it’s 95% full or even more, as it’s not likely to add 5gb of space in a matter of minutes. However, on a 1gb db, 95% only leaves me 50mb, which could potentially be added very quickly. Ideally, I would like to be able to create custom size categories and then set the alert depending on the size category. Has anyone done anything like this?
2. The provided alerts allow me to either calculate using the autogrowth maximum size or disregard autogrowth and calculate on current size. I would love to be able to set up a separate alert for each of these. Has anyone gone about setting this up through a custom counter or anything?
Thanks for any help or advice anyone can provide!