DMVs

E937630

SQL Server feature system view

DMVs are specialized system views in Microsoft SQL Server that provide real-time insight into server health, performance, and internal operations for monitoring and troubleshooting.

Try in SPARQL Jump to: Surface forms Disambiguation Statements Elicitation Referenced by

All labels observed (1)

Label	Occurrences
DMVs canonical	2

How this entity was disambiguated

This entity first appeared as the object of triple T11655498 — resolving that mention is where its identity was fixed. The disambiguator weighed these candidate entities and picked the highlighted one (or “None”, minting a new entity). This is how homonymy is resolved: the same surface form can point to different entities.

NED1 Entity disambiguation (via context triple) gpt-5-mini-2025-08-07

Target entity: DMVs
Context triple: [Dynamic Management Views, alsoKnownAs, DMVs]

A. DMV
DMV is a government agency that administers driver licensing, vehicle registration, and related motor vehicle services.
B. DMV
The DMV is the German Mathematical Society, a major professional organization that promotes mathematics research, education, and communication in Germany.
C. Maryland Motor Vehicle Administration
The Maryland Motor Vehicle Administration is the state agency responsible for driver licensing, vehicle registration, and related motor vehicle services in Maryland.
D. California Department of Motor Vehicles
The California Department of Motor Vehicles is the state agency responsible for driver licensing, vehicle registration, and enforcement of motor vehicle laws in California.
E. Driver and Vehicle Services
Driver and Vehicle Services is a division of Pennsylvania’s state transportation agency responsible for licensing drivers, registering vehicles, and maintaining related records and services.
F. None of above. chosen
G. Unsure - the case is ambiguous/there is not enough information to decide.

NED2 Entity disambiguation (via description) gpt-5-mini-2025-08-07

Target entity: DMVs
Target entity description: DMVs are specialized system views in Microsoft SQL Server that provide real-time insight into server health, performance, and internal operations for monitoring and troubleshooting.

A. DMV
DMV is a government agency that administers driver licensing, vehicle registration, and related motor vehicle services.
B. DMV
The DMV is the German Mathematical Society, a major professional organization that promotes mathematics research, education, and communication in Germany.
C. Maryland Motor Vehicle Administration
The Maryland Motor Vehicle Administration is the state agency responsible for driver licensing, vehicle registration, and related motor vehicle services in Maryland.
D. California Department of Motor Vehicles
The California Department of Motor Vehicles is the state agency responsible for driver licensing, vehicle registration, and enforcement of motor vehicle laws in California.
E. Driver and Vehicle Services
Driver and Vehicle Services is a division of Pennsylvania’s state transportation agency responsible for licensing drivers, registering vehicles, and maintaining related records and services.
F. None of above. chosen

Statements (49)

Predicate	Object
instanceOf	SQL Server feature ⓘ system view ⓘ
accessedBy	Transact-SQL SELECT statements ⓘ linked to: T-SQL
alsoKnownAs	DMVs ⓘ
category	database-scoped dynamic management views ⓘ server-scoped dynamic management views ⓘ
developedBy	Microsoft ⓘ
documentation	Microsoft Docs for SQL Server DMVs ⓘ
example	sys.dm_db_index_physical_stats ⓘ linked to: Dynamic Management Views (DMVs) sys.dm_db_index_usage_stats ⓘ sys.dm_exec_query_plan ⓘ sys.dm_exec_query_stats ⓘ sys.dm_exec_requests ⓘ sys.dm_exec_sessions ⓘ sys.dm_exec_sql_text ⓘ linked to: Dynamic Management Views (DMVs) sys.dm_os_buffer_descriptors ⓘ sys.dm_os_memory_clerks ⓘ sys.dm_os_performance_counters ⓘ sys.dm_os_tasks ⓘ sys.dm_os_threads ⓘ sys.dm_os_wait_stats ⓘ sys.dm_os_waiting_tasks ⓘ sys.dm_tran_locks ⓘ
introducedInVersion	SQL Server 2005 ⓘ linked to: SQL Server
namingConvention	sys.dm_ prefix ⓘ
partOf	Microsoft SQL Server ⓘ linked to: SQL Server
provides	real-time insight into internal operations ⓘ real-time insight into performance ⓘ real-time insight into server health ⓘ
relatedTo	Dynamic Management Functions ⓘ linked to: Dynamic Management Views (DMVs)
requires	VIEW DATABASE STATE permission for database-scoped DMVs ⓘ VIEW SERVER STATE permission for server-scoped DMVs ⓘ
scope	database level ⓘ server level ⓘ
usedFor	capacity planning ⓘ diagnosing blocking and deadlocks ⓘ identifying expensive queries ⓘ identifying missing indexes ⓘ monitoring CPU usage ⓘ monitoring I/O performance ⓘ monitoring SQL Server ⓘ monitoring index usage ⓘ monitoring memory usage ⓘ monitoring plan cache ⓘ monitoring query execution ⓘ monitoring wait statistics ⓘ performance tuning ⓘ tracking resource usage ⓘ troubleshooting SQL Server ⓘ