What should be the “max degree of parallelism”?

If you want the server to decide then make this value = 0.

INTERVIEW PREPARATION IN 30 MINs – Read Following wires for a quick interview preparation.

  1. SQL Server DBA “Interview Questions And Answers”
  2. SQL Azure Interview Questions and Answers Part – 1
  3. SQL Azure Interview Questions and Answers Part – 2
  4. Powershell Interview Questions and Answers

sp_configure ‘show advanced options’, 1;
GO
RECONFIGURE WITH OVERRIDE;
GO
sp_configure ‘max degree of parallelism’, 0;
GO
RECONFIGURE WITH OVERRIDE;
GO

In case you want to optimize this value then consider following.

A physical CPU can have more than one logical CPU. If the competition begins between these logical CPUs to process the requests then this is not a good thing. Change the value of ‘max degree of parallelism’ to number of physical CPUs in the system.

Worrying how to find the number of physical and logical CPUS?

refer: https://tuitionaffordable.wordpress.com/2010/10/12/how-to-find-the-number-of-physical-and-logical-cpus

Regards,
Online MSSQL Classes @ http://tuitionaffordable.webstarts.com

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s