December 18, 2010 at 7:17 pm
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
December 19, 2010 at 1:36 am
That command clears the sys.dm_os_wait_stats DMV. It does not clear the current waits in sys.dm_exec_requests.
You haven't said, but I'm willing to guess those are system processes, hence ones you shouldn't be worrying about during a load test. Many of the system processes are supposed to be waiting most of the time.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 19, 2010 at 4:16 am
Paul Randals article has more (and more,.. ) info on waits :http://www.sqlskills.com/BLOGS/PAUL/post/Wait-statistics-or-please-tell-me-where-it-hurts.aspx
It also refers to other great resources.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply