SQL University: Parallelism Week - Part 3, Settings and Options

re: SQL University: Parallelism Week - Part 3, Settings and Options

unclebiguns — Fri, 28 May 2010 13:57:49 GMT

Love it. Best SQLU week yet. At least for me. Learned a lot.

re: SQL University: Parallelism Week - Part 3, Settings and Options

James Luetkehoelter — Fri, 28 May 2010 18:16:23 GMT

Excellent!

re: SQL University: Parallelism Week - Part 3, Settings and Options

Michael — Mon, 31 May 2010 03:21:33 GMT

Great series, thanks for posting it.

Something to keep in mind is that you can use the Resource Governor to specify a MAXDOP for a Workload Group. Which will override the system default, and set a maximum for the MAXDOP hint in queries. I think that it would be a good way to go for OLTP systems, where you can put the OLTP transactions in their own workgroup with MAXDOP set to a low number, and still allow other queries to take advantage of the parallelism.

re: SQL University: Parallelism Week - Part 3, Settings and Options

Adam Machanic — Mon, 31 May 2010 03:29:41 GMT

Michael, great point on RG. I had that on the list of things to discuss, but it fell into the 50% of topics I wasn't able to hit in just three blog posts. And since then I've thought of even more stuff. It's amazing how deep this one area can go.

re: SQL University: Parallelism Week - Part 3, Settings and Options

AJ Mendo — Sat, 18 Sep 2010 14:28:17 GMT

Adam,

Does the information presented here apply to all versions of SQL evenly? As in 2000, 2005, 2008 and R2?

We have all flavors in our shop. Fortunately most of mine are 08 and 08 R2, but I do have a few 05 and one project is still 2000. That one will always be around even after upgrading (SOX sucks). Anyway. Just wondering if the "tweeking" is more efficient in new version as compared to old.

Thanks for the articles. Great foundation to expand on. Looking forward to more articles on this subject.

Cheers!

re: SQL University: Parallelism Week - Part 3, Settings and Options

Adam Machanic — Sat, 18 Sep 2010 18:46:33 GMT

Hi AJ,

2005, 2008, and 2008 R2. Most if not all of it probably applies to 2000 as well but to be honest I don't really remember. It's been six years since I've done anything in-depth with a 2000 instance.