:::: MENU ::::

Dynamic management views (DMVs) in SQL Server 2005 and later

  • Apr 17 / 2009
  • 1
dbDigger, Dynamic Management Views DMV

Dynamic management views (DMVs) in SQL Server 2005 and later

Dynamic management views (DMVs) return information on server state or database state that can be used for monitoring the health of a server instance and databases, and diagnose performance problems. Dynamic management views (DMVs) can be identified by their name, which begins with ”dm_,” plus an abbreviation of what category the DMV is a part, then a description of what the view returns. For example, dm_db_file_space_usage is part of the database category of DMVs and returns information on file space usage.

  • Anonymous

    It would be a good choice to apply filters for key purpose of DMV. Filters can be applied in SSMS. For example to search for all DMV related to OS, we may apply filter for OS keyword.

Consult us to explore the Databases. Contact us