SQL DMV – Dynamic Management Views
A new feature of SQL 2005 is Dynamic Management Views, commonly referred to with the acronym DMV.
DMVs give the database administrator information about the current state of the machine. DMVs can be used in conjunction with SQL Server Profiler and System monitor to actively identify problems with database systems. DMVs return internal, implementation-specific details on database performance and thus are an indispensable tool in the arsenal of any seasoned DBA. If you have not utilized DMVs in your database environment, well, now is as good a time as any to get up to speed on this new, easy-to-use feature. We will be writing a series of articles over the next few weeks that explore DMVs – What are they?; What DMVs are available?; How can they be used to tune your production environment?
In the meantime, if this short article has got you all a-tingle with anticipation, DMVs are described in this article in Microsoft’s Books Online.
