Monday, August 17, 2015

SQL Server Brain Basher of the Week #025 - DMVs and DMFs

The best and easiest way of getting real-time state information and recent historical information related to SQL Server is using Dynamic Management Views and Dynamic Management Functions. This week question is based on them, here is the question;

If I want to see DMVs and DMFs using Object Explorer, where should I look for?
  • Master database
  • Resource database
  • Any user-defined database
  • MSDB database
Generally all DMVs and DMFs are defined in the resource database and then mapped to other databases. If you want to see DMVs using Object Explorer, they can be seen in System View node of any database.

If you want to see DMFs using Object Explorer, they can be seen only in Table Valued Function node of master database.

No comments: