I want to correct myself better to use base counter for Average Wait time:

select AverageWaitTime for _Total instance and divide to Average Wait time Base for _Total instance.

there are some...

Try to use Delta to calculate Average Wait Time per second:

something like this :

select * into #temp1 from sys.dm_os_performance_counters

where counter_name like 'Average Wait Time (ms)%'

waitfor delay '00:00:30'

select * into #temp2...

If You are using SQL 2005 there is an Event Notification that can be used -DEADLOCK_GRAPH

you can use Service Broker to log every deadlock info into table ,information is complete...

I want WMI alert not an activation procedure , becasue if Queue is disabled Activation procedure is not started, and i want to catch cases when Queue is disabled.

I think...

Yes there is no problem to setup Event Notification for BROKER_QUEUE_DISABLED

but i want to set up Alert and Response Job , instead of EventNotification and Activation Procedure

use Set nocount on

before Insert statement

and set nocount off

after Insert Statement