MS SQL Server - Defining WMI alert in SQL server 2005

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Defining WMI alert in SQL server 2005

imarchenko

2006-03-08, 8:23 pm

Hello!

I am trying to define WMI alert monitoring certain OS counters.
Specifically, I would like to get notified if total CPU consumption will go
above given threshold.
Alert definition requires me to enter namespace and query. I was
wondering if anybody has done something similar in SQL Server 2005. I am not
what namespace I should be using (is there is a lit of namespaces for every
OS counter: CPU, Page file etc.). Also, I do not know how to express
condition I need using WQL - 'total CPU consumption>=<defined threshold>.

Thanks,
Igor

Sponsored Links