December 2013
Intermediate to advanced
1872 pages
153h 31m
English
book
Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Content preview from Microsoft® SQL Server 2012 Unleashed
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Summary
Between the features of SSMS and the text-based query analysis tools, SQL Server 2012 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 2012. 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 33, “Locking and Performance,” delves into ...