SQL Server Performance Series – Part 3 – Query and Index Tuning
In the last of this three part series we look at your application workload, down to individual query level, in order to find the best way to execute them. How can we determine what queries contribute to a performance problem, examine their execution plans, and tune them? How can you find out what indexes could benefit your workload? We will answer those and many more questions by taking a deep-dive into some more advanced diagnostic tools.