SQL Server DMVs in Action: Better Queries With Dynamic Management Views - Softcover

Stirk, Ian

 
9781935182733: SQL Server DMVs in Action: Better Queries With Dynamic Management Views

Synopsis

DESCRIPTION

Every action in SQL Server ― queries, updates, whatever ― leaves a

set of tiny footprints; SQL Server records all that valuable data and

makes it visible through Dynamic Management Views, or DMVs. A

DBA or developer can use this incredibly detailed information to

significantly improve the performance of queries and better understand

what's really going on inside a SQL Server system.

SQL Server DMVs in Action is a practical guide that shows how to

obtain, interpret, and act on the information captured by DMVs to keep

SQL Server in top shape. The 100+ samples provided in this book will

help readers master DMVs and also give them a tested, working, and

instantly reusable SQL code library.

KEY POINTS

F

• The first and only book to cover DMVs

F

• Over 100 and reusable code samples

F

• Long potential selling life

"synopsis" may belong to another edition of this title.

About the Author

Ian Stirk

is a freelance consultant based in London. He's a world-class

expert in SQL Server performance and a fierce advocate for DMVs.

"About this title" may belong to another edition of this title.