Dynamic Management Views (DMVs)
E277003
Dynamic Management Views (DMVs) are specialized system views in SQL Server that expose real-time internal state and performance data to help monitor, diagnose, and tune the database engine and its features.
All labels observed (3)
| Label | Occurrences |
|---|---|
| Dynamic Management Functions | 1 |
| Dynamic Management Views (DMVs) canonical | 1 |
| Microsoft Docs for SQL Server DMVs | 1 |
How this entity was disambiguated
This entity first appeared as the object of triple T2555844 — 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: Dynamic Management Views (DMVs) Context triple: [Resource Governor, monitoredBy, Dynamic Management Views (DMVs)]
-
A.
SQL Server Profiler
SQL Server Profiler is a graphical tool for monitoring, tracing, and analyzing SQL Server database engine events in real time to help with performance tuning and troubleshooting.
-
B.
Database Tuning Advisor
Database Tuning Advisor is a SQL Server tool that analyzes workloads and recommends optimal indexes, indexed views, and partitioning strategies to improve database performance.
-
C.
SQL Server Management Studio
SQL Server Management Studio is a graphical administration and development environment used to configure, manage, and query Microsoft SQL Server databases.
-
D.
SQL Server
SQL Server is Microsoft's enterprise-grade relational database management system used for storing, managing, and analyzing data in a wide range of applications.
-
E.
SQL Server Reporting Services
SQL Server Reporting Services is a server-based platform from Microsoft for designing, managing, and delivering paginated and interactive reports from relational and multidimensional data sources.
- 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: Dynamic Management Views (DMVs) Target entity description: Dynamic Management Views (DMVs) are specialized system views in SQL Server that expose real-time internal state and performance data to help monitor, diagnose, and tune the database engine and its features.
-
A.
SQL Server Profiler
SQL Server Profiler is a graphical tool for monitoring, tracing, and analyzing SQL Server database engine events in real time to help with performance tuning and troubleshooting.
-
B.
Database Tuning Advisor
Database Tuning Advisor is a SQL Server tool that analyzes workloads and recommends optimal indexes, indexed views, and partitioning strategies to improve database performance.
-
C.
SQL Server Management Studio
SQL Server Management Studio is a graphical administration and development environment used to configure, manage, and query Microsoft SQL Server databases.
-
D.
SQL Server
SQL Server is Microsoft's enterprise-grade relational database management system used for storing, managing, and analyzing data in a wide range of applications.
-
E.
SQL Server Reporting Services
SQL Server Reporting Services is a server-based platform from Microsoft for designing, managing, and delivering paginated and interactive reports from relational and multidimensional data sources.
- F. None of above. chosen
Statements (52)
| Predicate | Object |
|---|---|
| instanceOf |
SQL Server feature
ⓘ
system view category ⓘ |
| accessMethod | queried using T-SQL SELECT statements ⓘ |
| alsoKnownAs | DMVs ⓘ |
| category |
database-scoped DMVs
ⓘ
server-scoped DMVs ⓘ |
| documentation |
Dynamic Management Views (DMVs)
self-linksurface differs
ⓘ
surface form:
Microsoft Docs for SQL Server DMVs
|
| implementedAs | system views in the sys schema ⓘ |
| introducedInVersion |
SQL Server
ⓘ
surface form:
SQL Server 2005
|
| namingConvention | sys.dm_ prefix ⓘ |
| partOf |
SQL Server
ⓘ
surface form:
Microsoft SQL Server
|
| provides |
CLR integration information
ⓘ
I/O statistics ⓘ availability group information ⓘ change tracking and change data capture information ⓘ database mirroring information ⓘ execution plan information ⓘ full-text search information ⓘ index physical statistics ⓘ index usage statistics ⓘ locking and blocking information ⓘ memory usage information ⓘ query execution statistics ⓘ real-time database state information ⓘ real-time server state information ⓘ resource governor statistics ⓘ security and permissions-related information ⓘ service broker information ⓘ session and connection information ⓘ transaction information ⓘ wait statistics ⓘ |
| purpose |
expose internal state of the SQL Server engine
ⓘ
support capacity planning ⓘ support performance monitoring ⓘ support performance tuning ⓘ support troubleshooting and diagnostics ⓘ |
| relatedTo |
Dynamic Management Views (DMVs)
self-linksurface differs
ⓘ
surface form:
Dynamic Management Functions
|
| requiresPermission |
VIEW DATABASE STATE
ⓘ
VIEW SERVER STATE ⓘ |
| supports |
JOIN operations with other system views
ⓘ
filtering and aggregation via T-SQL ⓘ |
| usedBy |
DBAs
ⓘ
database developers ⓘ performance engineers ⓘ |
| usedFor |
analyzing wait bottlenecks
ⓘ
identifying blocking chains ⓘ identifying long-running queries ⓘ identifying missing indexes ⓘ identifying unused indexes ⓘ monitoring index fragmentation ⓘ monitoring query plan changes ⓘ monitoring resource utilization ⓘ |
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: Dynamic Management Views (DMVs) Description of subject: Dynamic Management Views (DMVs) are specialized system views in SQL Server that expose real-time internal state and performance data to help monitor, diagnose, and tune the database engine and its features.
Referenced by (3)
Full triples — surface form annotated when it differs from this entity's canonical label.
Dynamic Management Views (DMVs)
→
relatedTo
→
Dynamic Management Views (DMVs)
self-linksurface differs
ⓘ
subject surface form:
Dynamic Management Views
this entity surface form:
Dynamic Management Functions
Dynamic Management Views (DMVs)
→
documentation
→
Dynamic Management Views (DMVs)
self-linksurface differs
ⓘ
subject surface form:
Dynamic Management Views
this entity surface form:
Microsoft Docs for SQL Server DMVs