MSSQL Database Monitor Threshholds
Hi Folks,
I have a MSSQL server with several databases, which range in size. I need to know for example if my TempDB grows to beyond 1GB from it's usual level of below 10mb, whereas my main DB is 25GB and obviously a 1GB threshold would produce a constant alarm. Is there anyway to set individual thresholds against each DB?
Below are my monitor details for illustration.
Thanks,
Paul.
Monitor Name MSSQLDataFilesSizeKB
OID MSSQL.MSSQLDatabase.MSSQLDataFilesSizeKB
Monitor value Instance Value
db1 25752256
model 768
tempdb 8192
master 17344
Units KB
I have a MSSQL server with several databases, which range in size. I need to know for example if my TempDB grows to beyond 1GB from it's usual level of below 10mb, whereas my main DB is 25GB and obviously a 1GB threshold would produce a constant alarm. Is there anyway to set individual thresholds against each DB?
Below are my monitor details for illustration.
Thanks,
Paul.
Monitor Name MSSQLDataFilesSizeKB
OID MSSQL.MSSQLDatabase.MSSQLDataFilesSizeKB
Monitor value Instance Value
db1 25752256
model 768
tempdb 8192
master 17344
Units KB