Is your DB on the same server as the App and/or Midtier? Is the DB server a cluster or otherwise shared? I've seen some DB CPU problems when there isn't enough memory allocated to the DB itself and/or is shared. Increasing the memory allocated to the DB resolves the problem. Other things I've seen is with the SQL settings - such as whether or not Transaction logging is turned on, hot backups, etc. Another thing to ask for might be a 15 minute SQL trace - if there's some workflow/job that's out of control, that would help to illuminate that for resolution on the ARS side.
HTH Janie On Tue, Jan 7, 2014 at 4:10 PM, Pargeter, Christie :CO IS <cparg...@lhs.org>wrote: > ** > > This is my QA environment…it is already slow so might not be that > different. How would I limit my thread? > > > > *Christie Pargeter | Sr Technical Analyst | tel 503-415-5149 > <503-415-5149>* > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *LJ LongWing > *Sent:* Tuesday, January 07, 2014 4:05 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: SQL Stealing all of CPU > > > > ** > > You could limit your thread, or your dba could set your user account as > limited, but anything you do well impact the performance of your remedy > instance. > > On Jan 7, 2014 4:44 PM, "Pargeter, Christie :CO IS" <cparg...@lhs.org> > wrote: > > ** > > Hi All – my DBA is complaining that my QA/Test/UAT server is trying to > steal all the CPU of the database server. Any ideas how I can limit how > much my system tries to do in parallel? > > > > ARS 7.6.4 SP 4 > > ITSM 7.6.4 SP 4 > > RKM 7.6.4 SP 4 > > SLM 7.6.4 SP 1 > > Window 2008 – 64 Bit > > MS SQ 2005 SP 3 > > IIS/Tomcat > > MidTier 7.6.4 SP 5 HotFix 11/13/13 > > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"