Link to home
Create AccountLog in
Avatar of Star Gazr1
Star Gazr1Flag for United States of America

asked on

DMV SQL Server

I came across a term DMV (Dynamic Management Views) in SQL Server 2005.
Not sure what this is or how it is used.  Is this same as a Dynamic View?
Any feedback is greatly appreciated.
ASKER CERTIFIED SOLUTION
Avatar of sachitjain
sachitjain
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Dynamic management views and functions return internal, implementation-specific state data. Their schemas and the data they return may change in future releases of SQL Server. Therefore, dynamic management views and functions in future releases may not be compatible with the dynamic management views and functions in this release. For example, in future releases of SQL Server, Microsoft may augment the definition of any dynamic management view by adding columns to the end of the column list.

http://msdn.microsoft.com/en-us/library/ms188754(v=sql.110).aspx
Avatar of Star Gazr1

ASKER

I think I was confusing this with Dynamic Views.  That is what I am looking for information on.  What is a Dynamic View and how/when can this be used in T-SQL.  Thanks.
I see this question has an attention mark because I added this to the automotive section by accident.  How can I remove it from this group?
thanks.