In Part 1, we learnt about cardinality estimation, index choices & tweaking the query. Therefore, the focus was on query tuning. Part 1 is available as a free course here. 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. This will be a 60-minute, demo-focused LIVE session. Register your spot now (yeah, it's free). Click Here.

Session Title: Top 3 SQL Server Tuning Techniques - Part 2

Spread the word: Share on LinkedIn. Tweet now. Share on Facebook.

Copyright (c) SQLServerGeeks (Community unit of eDominer)