Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Free Learning

You're reading from Learn T-SQL Querying A guide to developing efficient and elegant T-SQL code

Product type Paperback

Published in May 2019

Publisher Packt

ISBN-13 9781789348811

Length 484 pages

Edition 1st Edition

Languages

SQL

Tools

T-SQL

Concepts

Database Administration

Authors (2):

Pedro Lopes

Pam Lahoud

View More author details

Table of Contents (18) Chapters

Preface

1. Section 1: Query Processing Fundamentals FREE CHAPTER

2. Anatomy of a Query

3. Understanding Query Processing

4. Mechanics of the Query Optimizer

5. Section 2: Dos and Donts of T-SQL

6. Exploring Query Execution Plans

7. Writing Elegant T-SQL Queries

8. Easily-Identified T-SQL Anti-Patterns

9. Discovering T-SQL Anti-Patterns in Depth

10. Section 3: Assemble Your Query Troubleshooting Toolbox

11. Building Diagnostic Queries Using DMVs and DMFs

12. Building XEvent Profiler Traces

13. Comparative Analysis of Query Plans

14. Tracking Performance History with Query Store

15. Troubleshooting Live Queries

16. Managing Optimizer Changes with the Query Tuning Assistant

17. Other Books You May Enjoy

Leave a review - let other readers know what you think

Introducing Dynamic Management Views

SQL Server 2005 introduced a new concept in the Database Engine—the SQL Operating System (SQLOS). The SQLOS is an abstraction layer that encapsulates all the low-level resource management and monitoring tasks that the Database Engine must perform, while providing an application programming interface (API) for other components of the Database Engine to leverage these services. Not only does this centralization of resource management code make the Database Engine more efficient, it also provides a central location for monitoring various aspects of Database Engine performance. Dynamic Management Views (DMVs) take advantage of this centralized architecture by providing the user with a mechanism to view this information in a way that is lightweight and accurate.

DMVs allow the user to query memory structures in the SQLOS. Some DMVs show information...

The rest of the chapter is locked

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $19.99/month. Cancel anytime

Authors (2)

Pedro Lopes

Pedro Lopes is a Program Manager in the Database Systems group, based in Redmond, WA, USA. He has over 19 years of industry experience and has been with Microsoft for 9 years. He is currently responsible for program management of Database Engine features for in-market and vNext versions of SQL Server, with a special focus on the Relational Engine. He has extensive experience with query performance troubleshooting and is a regular speaker at numerous conferences such as SQLBits, PASS Summit, SQLIntersection, Microsoft Ignite, and Microsoft Build. He blogs about SQL on the SQL Server Team blog. He has authored several tools in the Tiger toolbox on GitHub: AdaptiveIndexDefrag maintenance solution, BPCheck, and usp_WhatsUp.

See other products by Pedro Lopes

Lahoud

Pam Lahoud is a Program Manager in the Database Systems group, based in Redmond, WA, USA. She has been with Microsoft for 13 years and is currently responsible for program management of Database Engine features for in-market and vNext versions of SQL Server, with a special focus on the Storage Engine area. She is passionate about SQL Server performance and has focused on performance tuning and optimization, particularly from the developer's perspective, throughout her career. She is a SQL Server 2008 Microsoft Certified Master (MCM) with over 20 years of experience working with SQL Server.

See other products by Lahoud