SQL Server Forums
Profile | Register | 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
 New Topic  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
2075 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  
 New 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.05 seconds. Powered By: Snitz Forums 2000