SqlServerKudos

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

faq »

1
kudos

Kudos

Leverage Query and Index performance with MAXDOP/Max Degree of Parallelism option in SQL Server

published 690 days, 8 hours, 12 minutes ago posted by

sa 699 days, 7 hours, 37 minutes ago

Leverage Query and Index performance with MAXDOP/Max Degree of Parallelism option in SQL Server

No matter how best you adopt the indexing practices, few times you have to tweak the resources to obtain optimized performance. This is where a degree of parallelism needs to be applied for your complex/large resulted queries on your SQL Server, having a multiple CPU based server is a quite common criteria. By design SQL database engine with more than CPU detects the best degree of parallelism, that is number of processors employed to run a single statement, for each parallel plan execution. Unless...(read more)

category: News | clicked: 0 | | source: sqlserver-qa.net | show counter code

tags: benchmarking, best practice, DBA, latches, max worker threads, maxdop, numa, parallel execution, Performance, performance monitoring, Query, SQL Server, threads

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

update reset

SqlServerKudos

Welcome!

Leverage Query and Index performance with MAXDOP/Max Degree of Parallelism option in SQL Server

No comments yet, be the first one to post comment.

Open ID Login

Standard Login

Forgot Password?

Sign up