SQL Server DMVs in Action: Better Queries with Dynamic Management Views
Ian W. Stirk
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.
what's inside
* Many practical solutions
* How to correct missing indexes
* What's slowing down your queries
* What's compromising concurrency
* Much more
about the reader
This book is written for DBAs and developers.
about the author
Ian Stirk is a freelance consultant based in London. He's an expert in SQL Server performance and a fierce advocate for DMVs.
what's inside
* Many practical solutions
* How to correct missing indexes
* What's slowing down your queries
* What's compromising concurrency
* Much more
about the reader
This book is written for DBAs and developers.
about the author
Ian Stirk is a freelance consultant based in London. He's an expert in SQL Server performance and a fierce advocate for DMVs.
Kategori:
Tahun:
2011
Edisi:
1
Penerbit:
Manning Publications
Bahasa:
english
Halaman:
346
ISBN 10:
1935182730
ISBN 13:
9781935182733
File:
PDF, 6.28 MB
IPFS:
,
english, 2011