DaveWentzel.com            All Things Data

December 2012

Parallelism and Query Tuning

 

...Adam Machanic presentation on query parallelism.  Just skip to 148:00 or so.  The beginning is fluff. 
Tags: 

C1 Transitions may be hurting your server's performance

We had a customer whose SQL Server just seemed "sluggish".  PerfMon wasn't terrible but user response time was atrocious.  We checked everything and did due diligence and couldn't find anything definitively, you'll have to trust me.