In this 5-minute video, Doug tells a story about a DBA whose SQL Server got fed up with being misconfigured and decided to do something about it. Topics include CPU settings like MAXDOP and Cost Threshold for Parallelism, memory and disk configuration.
Hi! I’m Brent Ozar.
I make Microsoft SQL Server go faster. I love teaching, travel, cars, and laughing. I’m based out of Las Vegas. He/him. I teach SQL Server training classes, or if you haven’t got time for the pain, I’m available for consulting too.
Want to advertise here and reach my savvy readers?
13 Comments. Leave new
I like this. A different way to get basic configuration settings explained and understood. I also appreciate the production quality. Clear video with the logo in the background gives it some professionalism while the squirrel reference keeps it real. Good work on this!
Thanks, Clint! Glad you enjoyed it.
Hi Doug,
This is very interesting. I hope you do more creative sql server videos. They are fun to watch and learn.
Thanks!
LOVE the light saber!
I kept wondering if that light saber is green or red…
If you can recognize the hilt, you’ll know the color. One hint: it’s not Luke’s from ROTJ.
Amusing and educational, fantastic.
Everything Clint Davis said plus I appreciate the light saber in the stand. Good to know you take problems serious enough to keep in within arms reach.
Well Said Doug, Good Job !
I would hope you have a permit for that light sabre. 😉
One thing to point out – make sure to set the CPU power plan in the BIOS _and_ in the OS. One of the two may not be sufficient.
Yes, very true. Finding it in the Windows power management *or* the BIOS settings is not enough. Typically, I see it turned off in Windows but not the BIOS. The way you can tell is with CPU-Z. If the clock speed fluctuates at all, it’s doing power savings somewhere.