SQL Server DMVs in Action: Better Queries with Dynamic Management Views /By Ian W. StirkEvery. 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. Who Should Read It This book is written for DBAs and developers. What’s Inside Many practical solutions How to correct missing indexes What’s slowing down your queries What’s compromising concurrency Much more
