MOM Alert when SQL tempdb grows > 40GB

[alastairn]

I am trying to setup a MOM Alert when a SQL tempdb grows in size above 40GB.

How can this be done within MOM, I have searched the SQL Management Pack but
found nothing that supports this alert. Can anyone provide any help?

Many thanks

[Anders Bengtsson]

Hi alastairn,

You could look at the database file, take a look at this script http://contoso.se/blog/?p=127


-----
Regards
Anders Bengtsson
Microsoft MVP - MOM
http://www.contoso.se


a> How can this be done within MOM, I have searched the SQL Management
a> Pack but found nothing that supports this alert. Can anyone provide
a> any help?
a>

[alastairn]

Thanks Anders, will have a look now :)

Post by Anders Bengtsson
Hi alastairn,
You could look at the database file, take a look at this script http://contoso.se/blog/?p=127
-----
Regards
Anders Bengtsson
Microsoft MVP - MOM
http://www.contoso.se
a> How can this be done within MOM, I have searched the SQL Management
a> Pack but found nothing that supports this alert. Can anyone provide
a> any help?
a>