Dynamic Management View in SQL SERVER

Dynamic Management View

Dynamic Management Views were introduced in SQL Server 2005. These Views give the administrator information of the database about the current state of the SQL Server machine. These values help the administrator to analyze problems and tune the server for optimal performance. These are of two types

1. Server-scoped Dynamic Management View

   These are stored only in the Master database.

2. Database-scoped Dynamic Management View

   These are stored in each database.