Loud Engine
If you’re ever on a long flight and want something to fall asleep to, ask a DBA how to set MAXDOP.
Sometimes I even ask myself that question when I’m tossing and turning at night.
There are a …
Category: MAXDOP
Common SQL Server Consulting Advice: Setting MAXDOP And Cost Threshold For Parallelism
Dirty Work
There are three classes of administrator when it comes to parallelism settings
- Never changed the defaults
- Changed the defaults to something wacky
- Changed the defaults to something safe
The beginning of this post is for the first couple …
MAXDOP: The T-Shirt
Buttery Biscuits
In yesterday’s post, I showed you the promo video and abstract for my SQLBits precon.
In today’s post, I’m gonna offer you a little bribery to show up.
First, all attendees will get one of these lovely T-Shirts. …
Starting SQL: Sorts And Memory Grants In SQL Server
Sup?
For SQL Server queries that require additional memory, grants are derived for serial plans. If a parallel plan is explored and chosen, memory will be divided evenly among threads.
Memory grant estimates are based on:
- Number of rows (cardinality)
Why Does My Serial Query Plan Have Parallel Wait Stats Like CXPACKET And CXCONSUMER?
Harkening
In dramatic fashion, I’m revisiting something from this post about stats updates.
It’s a quick post, because uh… Well. Pick a reason.
Get In Gear
Follow along as I repeat all the steps in the linked post to:
- Load
Thoughts On Setting MAXDOP Correctly In SQL Server
Microsoft recently published new guidance on setting server level MAXDOP. I hope to help the community by analyzing the new guidance and offering some of my own thoughts on query parallelism.
Line by line
Documentation is meant to be shared …
Video: Is Setting MAXDOP and Cost Threshold for Parallelism Really Easy?
Asked and Answered
Thanks for watching!
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount on to my blog readers if you click from here…