Dynamic Management Views (DMVs)

All labels observed (8)

Label	Occurrences
Dynamic Management Functions	2
Dynamic Management Views (DMVs) canonical	1
Extended Events DMVs	1
Microsoft Docs for SQL Server DMVs	1
SQL Server dynamic management functions	1
SQL Server dynamic management views	1
sys.dm_db_index_physical_stats	1
sys.dm_exec_sql_text	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	Microsoft Docs for SQL Server DMVs ⓘ linked to: Dynamic Management Views (DMVs)
implementedAs	system views in the sys schema ⓘ
introducedInVersion	SQL Server 2005 ⓘ linked to: SQL Server
namingConvention	sys.dm_ prefix ⓘ
partOf	Microsoft SQL Server ⓘ linked to: 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 Functions ⓘ linked to: Dynamic Management Views (DMVs)
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

Referenced by (9)

Full triples — surface form annotated when it differs from this entity's canonical label.

Resource Governor → monitoredBy → Dynamic Management Views (DMVs) ⓘ

Dynamic Management Views → relatedTo → Dynamic Management Functions ⓘ

subject linked to: Dynamic Management Views (DMVs)