Monitoring database space usage on a database with multiple data files

rkohman

Hi all, I have many databases that we are monitoring for space which have multiple datafiles. Usually most the datafiles are full but at least 1 of the files is able to autogrow. Sometimes autogrow has reached its max limitation and sometimes we have turned it off once the file reached the largest size we will allow it.  Our goal is to monitor so the database does not run out of space. We currently get alerts for the files that are full, we know some are full, we aren't worried about them, we still have 1 or 2 files we allow to grow and those are what we are worried about. Is there a way to turn off alerts just for the files we know are full and we don't want to monitor? Or is there a way to monitor database available space instead of on a file by file basis. I have attached a screenshot of what our database files layout typically is. So the first three files I don't want to get alerts on because I know I have 4 other files that can grow.

Mac_F

Hello,

Thank you for your question. We are currently checking on this to see if it is possible, however so far we do not believe it is.
We will let you know as soon as we can find an answer.

Kind regards,

Russell D

This isn't possible I'm afraid - at this stage we're not currently planning any updates to this, but please post it on the uservoice https://sqlmonitor.uservoice.com/forums/91743-suggestions, as we do use this to gauge interest.