Alert for full filegroup
if a database is a fixed size (max size set), or if the db is initially set to be the full size of a disk, there is no alert to let us know that the database is full.
for instance - if T: drive contains tempdb (and only tempdb) and we've sized it to take the whole drive. we've done funky sizing and growth settings so we can get an alert when the db grows, but once its grown and the temp objects are cleared, we're unlikely to get another disk warning, because the DB will already be taking 100% of the disk.
If we could get an alert on the error below - it would allow a greater degree of flexibility when databases fill up (due to fixed size or expired disk space alerts)
Could not allocate space for object 'dbo.#wak' in database 'tempdb' because the 'PRIMARY' filegroup is full
-
PL commented