Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Hariarul
Posting Yak Master
160 Posts |
 Posted - 2007-12-18 : 05:58:02
|
| Hi all , When I correlate my profiler trace with the performance counters collected on a production server , I see many spikes for the counter % CPU usage & Avg Disk queue length. Whenever I click on the spikes to see which event made this happen , I get the below event.EvenClass: SQL : Batch CompletedText Data: WAITFOR (RECEIVE message_body FROM WMIEventProviderNotificationQueue), TIMEOUT 5000 Application Name: MS Windows OSIs this event causing the performance issues ? Any idea on why this event arises? How do I resolve if this is the issue ?Thanks in advance,Hariarul |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-12-18 : 06:17:06
|
| This may be useful:http://msdn2.microsoft.com/en-us/library/ms186371.aspx |
 |
|
|
|
|
|
Regarding WMIEventProviderNotificationQueue.