Performance Tuning With SQL Server Dynamic Management Views
This book is here to de-mystify the process of collecting the information you need to troubleshoot SQL Server problems.
Tag(s): Relational Database
Publication date: 01 Sep 2010
ISBN-10: 1906434476
ISBN-13: 9781906434472
Paperback: 344 pages
Views: 6,516
Performance Tuning With SQL Server Dynamic Management Views
This book is here to de-mystify the process of collecting the information you need to troubleshoot SQL Server problems.
Publication date: 01 Sep 2010
ISBN-10: 1906434476
ISBN-13: 9781906434472
Paperback: 344 pages
Views: 6,516
Document Type: N/A
Publisher: Red Gate Books
License: n/a
Post time: 25 Apr 2016 12:00:00
Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA’s troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.
Why, then, aren’t all DBAs using them? Why do many DBAs continue to ignore them in favour of "tried and trusted" tools such as sp_who2, DBCC OPENTRAN, and so on, or make do with the "ready made" reports built into SSMS? Why do even those that do use the DMVs speak wistfully about "good old sysprocesses"?
There seem to be two main factors at work. Firstly, some DBAs are simply unaware of the depth and breadth of the information that is available from the DMvs, or how it might help them troubleshoot common issues. This book investigates all of the DMVs that are most frequently useful to the DBA in investigating query execution, index usage, session and transaction activity, disk IO, and how SQL Server is using or abusing the operating system.
Tweet
About The Author(s)
Louis Davidson is a data architect specializing in relational database design with SQL Server. Currently he is the Data Architect for Compass Technology in Chesapeake, Virginia, supporting the Christian Broadcasting Network and NorthStar Studios in Nashville, Tennessee. Louis has been a Microsoft MVP since 2004, and is an active volunteer for the Professional Association for SQL Server working in their Special Interest Groups.
Louis Davidson is a data architect specializing in relational database design with SQL Server. Currently he is the Data Architect for Compass Technology in Chesapeake, Virginia, supporting the Christian Broadcasting Network and NorthStar Studios in Nashville, Tennessee. Louis has been a Microsoft MVP since 2004, and is an active volunteer for the Professional Association for SQL Server working in their Special Interest Groups.
Tim Ford is a SQL Server MVP, and has been working with SQL Server for over ten years. He is the co-founder of SQL Cruise, LLC, a training company for SQL Server specializing in deep-dive sessions for small groups, hosted in exotic and alternative locations throughout the world. He is also a Senior SQL Server Professional for Next Wave Logistics, Inc. and is the owner and Lead Consultant for B-Side Consulting, LLC.
Tim Ford is a SQL Server MVP, and has been working with SQL Server for over ten years. He is the co-founder of SQL Cruise, LLC, a training company for SQL Server specializing in deep-dive sessions for small groups, hosted in exotic and alternative locations throughout the world. He is also a Senior SQL Server Professional for Next Wave Logistics, Inc. and is the owner and Lead Consultant for B-Side Consulting, LLC.