Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Session CPU wait times
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

JaybeeSQL
Posting Yak Master

112 Posts

Posted - 11/07/2012 :  08:32:58  Show Profile  Reply with Quote
Hi all,

We have a lightly-used OLTP system, split across 3 clusters, that is showing 6 sessions with wait times often in hundreds, or thousands of seconds.

They are not causing performance complaints but ARE causing alerts to fire in our monitoring system (Idera). I would be grateful for any ideas to begin addressing the underlying issue, as well as rationalising the alerts (ie possibly by increasing the 'critical' point where an email is sent to 10,000secs).

Many thanks,


JB

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2179 Posts

Posted - 11/07/2012 :  09:46:33  Show Profile  Visit jackv's Homepage  Reply with Quote
1)Try extracting the queries which are running at the time. This could give you some clues. Analyse the queries execution plans and see if there is an heavy CPU based activity.
2) Using a query over sys.dm_os_wait_stats check for : SOS_SCHEDULER_YIELD, THREADPOOL, CX_PACKET , usually related the CPU


Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000