Summary
Between the features of SSMS and the text-based query analysis tools, SQL Server 2014 provides a number of powerful utilities to help you analyze and understand how your queries are performing and also help you develop a better understanding of how queries in general are processed and optimized in SQL Server 2014. Such an understanding can help ensure that the queries you develop will be optimized more effectively by SQL Server.
The tools discussed in this chapter are useful for analyzing individual query performance. However, in a multiuser environment, query performance is often affected by more than just how a single query is optimized. One of those factors is locking contention. Chapter 37, “Locking and Performance,” delves into ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
