What is DMVs and DMFs
"First of all DMVs stands for Dynamic Management Views and DMFs stands for Dynamic Management Functions"
Dmvs and Dmfs will returns us server state and database state for performance monitoring.While we run Dmvs it will give us all data without any input parameter.But While we run Dmfs it will give us all cursors details with input parameter.
There are 2 scope present in SQL SERVER in which Dmvs and Dmfs will work:
1. In Server scope : Dmvs will returns us the entire SQL SERVER stats.It might not have _db_ in their name.
2. In database scope : Dmvs will returns us a particular database stats.It should have _db_ in their name.
Importance :
We can monitor health of the sql server and give us server stats so that we can do performance analysis.
Dmvs and Dmfs will returns us server state and database state for performance monitoring.While we run Dmvs it will give us all data without any input parameter.But While we run Dmfs it will give us all cursors details with input parameter.
There are 2 scope present in SQL SERVER in which Dmvs and Dmfs will work:
1. In Server scope : Dmvs will returns us the entire SQL SERVER stats.It might not have _db_ in their name.
2. In database scope : Dmvs will returns us a particular database stats.It should have _db_ in their name.
Importance :
We can monitor health of the sql server and give us server stats so that we can do performance analysis.
Comments
Post a Comment