Help required- MAXDOP - SQL Server Forums

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

All Forums

General SQL Server Forums

New to SQL Server Administration

Help required- MAXDOP

Author

Topic

Diya1225
Starting Member

1 Post

Posted - 2011-04-15 : 14:33:08

Hi,
Please could someone help me in understanding the concept of MAXDOP
in Sql Server 2008.

Thanks
Diya

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-04-15 : 14:34:20

Sure, but let's start with Books Online: http://msdn.microsoft.com/en-us/library/ms181007.aspx

Here's some general guidelines: http://support.microsoft.com/kb/329204

Now what specifically do you have a question with after reading those links?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Jahanzaib
Posting Yak Master

115 Posts

Posted - 2011-04-15 : 15:35:51

MAXDOP is Maximum Degree of Parallelism when you use in the end of query a query hint

OPTION(MAXDOP 2)

then this mean optimizer process this query on 2 Processors forcefully

You can define this option at the Server level also then every query will use the defined processors

http://aureus-salah.com/2011/02/25/sql-server-query-hints/

http://aureus-salah.com/2010/08/09/sql-server-cpu-hyperthreading-max-workers/

Regards,
Syed Jahanzaib Bin Hassan
MCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBA

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources