Hi All,

I have been using different DMVs everyday as part of my DBA activities. Suddenly i got a question" from where the data is manipulated in the DMVs and DMFs? What is that internally happening which provides the dynamic result set. I basically want to understand how DMVs work.

Thanks

Code within the database engine. The data isn't actually stored on regular tables, but when you select from them the database engine kick off code that for instance traverse the structures that keep track of waiting statistics and constructs this a result set that can be passed to the client.

Hello

DMV &DMF provides the outcome for SQL Server run-time state information related to Instance/DB analyzing,troubleshoot or information.

see-

Dynamic management views and functions return internal, implementation-specific state data. Their schemas and the data they return may changes to version to version

see-

Dynamic Management Views and Functions (Transact-SQL)
http://msdn.microsoft.com/en-us/library/ms18875