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.

All Forums  SQL Server 2008 Forums  SQL Server Administration (2008)  Waittime

Author  Topic  TMDOSS Starting Member 33 Posts Posted - 2010-12-17 : 12:13:50 When I run the sysprocesses I get the Following 2777132058 BROKER_EVENTHANDLER 5411117743 KSOURCE_WAKEUP 5411139971 BROKER_TRANSMITTER 5411139971 BROKER_TRANSMITTER 5411141588 ONDEMAND_TASK_QUEUE We are running the load test now. How can I clear this I tried to use DBCC SQLPERF ('sys.dm_os_wait_stats', CLEAR) It doesn't clear the wait time or reset Thanks