Dynamic Management Views (High Performance SQL Server)

by Louis Davidson and Tim Ford

0 ratings • 0 reviews • 0 shelved
Book cover for Dynamic Management Views

Bookhype may earn a small commission from qualifying purchases. Full disclosure.

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...Read more
  • ISBN10 1906434476
  • ISBN13 9781906434472
  • Publish Date 30 April 2010
  • Publish Status Active
  • Publish Country GB
  • Imprint Red Gate Books
  • Format Paperback (US Trade)
  • Pages 344
  • Language English