Note: Lifetime Access

Abstract: In Part 1, we learnt about cardinality estimation, index choices & tweaking the query. Therefore, the focus was on query tuning. In Part 2, we will focus on some aspects of tuning at the server level. There are many knobs and switches that you can turn on/off and tweak a few options to improve the overall performance of the workloads. There is no magic bullet though so the context is important.


  • Technique 1: Cost Threshold of Parallelism (CTP)
  • Technique 2: Read Committed Snapshot
  • Technique 3: Trace Flag 4199