DMVs
E937630
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.
All labels observed (1)
| Label | Occurrences |
|---|---|
| DMVs canonical | 1 |
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 NERFINISHED ⓘ |
| alsoKnownAs | DMVs NERFINISHED ⓘ |
| category |
database-scoped dynamic management views
ⓘ
server-scoped dynamic management views ⓘ |
| developedBy | Microsoft ⓘ |
| documentation | Microsoft Docs for SQL Server DMVs NERFINISHED ⓘ |
| example |
sys.dm_db_index_physical_stats
NERFINISHED
ⓘ
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 NERFINISHED ⓘ 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 NERFINISHED ⓘ |
| namingConvention | sys.dm_ prefix ⓘ |
| partOf | Microsoft SQL Server NERFINISHED ⓘ |
| provides |
real-time insight into internal operations
ⓘ
real-time insight into performance ⓘ real-time insight into server health ⓘ |
| relatedTo | Dynamic Management Functions NERFINISHED ⓘ |
| 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 ⓘ |
How these facts were elicited
The pipeline generated the facts above by prompting gpt-5.1 with this entity's name + description and the instruction below.
Instruction
You are a knowledge base construction expert. Given a subject entity and a description of it, return factual statements that you know for the subject as a JSON list of dictionaries(triples), where keys must be "subject", "predicate" and "object". The number of facts may be very high, between 25 to 50 or more, for very popular subjects. For less popular subjects, the number of facts can be very low, like 5 or 10. # Requirements - If you don't know the subject at all, return an empty list. - If the subject is not a named entity, return an empty list. - Include at least one triple where predicate is "instanceOf". - Do not get too wordy. - Separate several objects into multiple triples with one object.
Input
Subject: DMVs Description of subject: 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.
Referenced by (1)
Full triples — surface form annotated when it differs from this entity's canonical label.
subject surface form:
Dynamic Management Views