SQL Server Performance Series – Part 3 – Query and Index Tuning

Sign in to queue

Description

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.
For more information, check out this course on Microsoft Virtual Academy:

Day:

40

Code:

DAT342

Embed

Download

Download this episode

For more information, check out this course on Microsoft Virtual Academy:

The Discussion

Add Your 2 Cents