3 Ways to Configure MAXDOP – SQL in Sixty Seconds #166

3 Ways to Configure MAXDOP - SQL in Sixty Seconds #166 166-3ways-MAXDOP-yt-800x450 After watching the previous two videos here and here lots of people asked me how to change MAXDOP for their server. In this blog post, we will see a quick SQL in Sixty Seconds video and scripts used in the video to change MAXDOP. Let us watch 3 Ways to Configure MAXDOP.

However, before you continue this blog post, you must remember that if you should not change the MAXDOP without properly testing your system with various scenarios. I have used MAXDOP 2 in my example. However, the best value for your system needs more investigation. Use the right value for MAXDOP for your system after consulting your local expert. Setting up the wrong value for MAXDOP can damage your system’s performance.

Here is a quick video:

Method 1: At Server Level

3 Ways to Configure MAXDOP - SQL in Sixty Seconds #166 maxdopimage1

Use this option when you want the impact of MAXDOP for your entire server.

Method 2: At Database Level

3 Ways to Configure MAXDOP - SQL in Sixty Seconds #166 maxdopimage2

Use this option when you want the impact of the MAXDOP to be limited to your selected database.

Method 3: At Query Level

3 Ways to Configure MAXDOP - SQL in Sixty Seconds #166 maxdopimage3

If you want your selected queries to have the impact of MAXDOP, you should use this option.

Well, there you go, in this quick blog post, we discussed 3 Ways to Configure MAXDOP. I will be building a detailed blog post in the future where I will explain what is the most appropriate value of MAXDOP for your system.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

, ,
Previous Post
Get Memory Details – SQL in Sixty Seconds #165
Next Post
Excel – Sum vs SubTotal – SQL in Sixty Seconds #167

Related Posts

Leave a Reply

Menu