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
 General SQL Server Forums
 New to SQL Server Administration
 SQL Service Times out
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

albertkohl
Aged Yak Warrior

USA
740 Posts

Posted - 07/23/2013 :  10:48:19  Show Profile  Visit albertkohl's Homepage  Reply with Quote
i know this is kinda vague, but hopefully someone can help me. i have a SQL Server that has 32 cores (64 logical). and for some reason, when we have a job that kicks off that uses 39 of those 64 CPU's and basically tacks them out. when that happens the SQL Service chokes for about 5 minutes until it's done doing what it needs to do.

any ideas?

James K
Flowing Fount of Yak Knowledge

3704 Posts

Posted - 07/23/2013 :  11:03:13  Show Profile  Reply with Quote
That when you have a job that takes up a large number of CPU's, things slow down seems to be a natural cause/effect. One thing you might consider is reducing the parallelism by setting MAXDOP to a lower number. Sometimes when you have too high a degree of parallelism, it can work to your disadvantage. http://msdn.microsoft.com/en-us/library/ms181007(v=sql.105).aspx
Go to Top of Page

albertkohl
Aged Yak Warrior

USA
740 Posts

Posted - 07/23/2013 :  11:13:54  Show Profile  Visit albertkohl's Homepage  Reply with Quote
thanks. i'll take a stab @ that.
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