Difference between DMF and DMV
Stephen West ~
Modified: March 10th, 2016 ~ ~ 1 Minute Reading
- This topic has 1 reply, 2 voices, and was last updated 8 years, 9 months ago by .
Viewing 2 posts - 1 through 2 (of 2 total)
-
Posts
-
These both terms (DMV and DMF) returns server state information and these can be used for the monitoring purpose of the health state of a server instance also can be used in diagnosis of the problems and performance tuning.
The DMV and DMFs are two different entity but both are stored in query cache or in query plans sometimes these are also stored in CLR Data, Extended Events, Resource Governor info, etc. ‘s are views, DMF’s are functions. The terms Dynamic Management Views (DMVs) and Dynamic Management Functions (DMFs) were introduced in SQL 2005.
Viewing 2 posts - 1 through 2 (of 2 total)
- You must be logged in to reply to this topic.