Dynamic management views (DMVs) enable much greater visibility into the workings of SQL Server than any version prior to SQL Server 2005. They are basically just views on top of the system tables or in-memory system counters, but the concept enables Microsoft to provide a massive amount of useful information through them.
The standard syntax starts with sys.dm_, which indicates that it’s a DMV (there are also dynamic management functions, but DMV is still the collective term in popular use), followed by the area about which the DMV prov...
- Chapter 1: SQL Server Architecture
- from Professional SQL Server 2012 Internals and Troubleshooting
- Publisher: Wrox
- Released: November 2012
Share this highlighthttp://www.safaribooksonline.com/a/professional-sql-server/10388174/