Chapter 14. Using Tools to Analyze Query Performance

Exam objectives in this chapter:

  • Troubleshoot & Optimize

    • Optimize queries.

Writing queries requires basic T-SQL knowledge; writing well-performing queries needs much more advanced knowledge. However, Microsoft SQL Server 2012 helps you in this learning process. SQL Server exposes information about query execution, like amount of disk IO and CPU time needed to execute the query, detailed execution steps, missing indexes and indexes that are not used, and much more. In this chapter, you learn how to use the query execution information exposed by SQL Server.

Lessons in this chapter:

Get Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012 now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.