SQL Server Management Data Warehouse

E277002

SQL Server feature performance data warehouse

SQL Server Management Data Warehouse is a SQL Server feature that collects, stores, and reports performance and configuration data from managed servers to support monitoring and analysis.

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

All labels observed (3)

Label	Occurrences
Data Collection feature in SQL Server	1
SQL Server Data Collection feature	1
SQL Server Management Data Warehouse canonical	1

How this entity was disambiguated

This entity first appeared as the object of triple T2555784 — 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: SQL Server Management Data Warehouse
Context triple: [Policy-Based Management, integratesWith, SQL Server Management Data Warehouse]

A. 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.
B. 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.
C. SQL Server Data Tools
SQL Server Data Tools is an integrated development environment within Visual Studio for designing, developing, debugging, and deploying SQL Server and Azure SQL databases and related business intelligence solutions.
D. SQL Server Integration Services
SQL Server Integration Services is a Microsoft ETL and data integration platform used to extract, transform, and load data between diverse sources within the SQL Server ecosystem.
E. SQL Server Analysis Services Tabular
SQL Server Analysis Services Tabular is a Microsoft in-memory analytical engine for building tabular data models that support fast, interactive business intelligence and reporting.
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: SQL Server Management Data Warehouse
Target entity description: SQL Server Management Data Warehouse is a SQL Server feature that collects, stores, and reports performance and configuration data from managed servers to support monitoring and analysis.

A. 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.
B. 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.
C. SQL Server Data Tools
SQL Server Data Tools is an integrated development environment within Visual Studio for designing, developing, debugging, and deploying SQL Server and Azure SQL databases and related business intelligence solutions.
D. SQL Server Integration Services
SQL Server Integration Services is a Microsoft ETL and data integration platform used to extract, transform, and load data between diverse sources within the SQL Server ecosystem.
E. SQL Server Analysis Services Tabular
SQL Server Analysis Services Tabular is a Microsoft in-memory analytical engine for building tabular data models that support fast, interactive business intelligence and reporting.
F. None of above. chosen

Statements (48)

Predicate	Object
instanceOf	SQL Server feature ⓘ performance data warehouse ⓘ
category	database performance monitoring tool ⓘ
collects	configuration data ⓘ performance data ⓘ
collectsFrom	managed servers ⓘ
configuredUsing	Data Collection Wizard ⓘ SQL Server Management Studio ⓘ
dataRetentionControlledBy	collection set properties ⓘ
defaultDatabaseName	mdw ⓘ
developedBy	Microsoft ⓘ
hasComponent	data collection ⓘ management data warehouse database ⓘ reports ⓘ
introducedInVersion	SQL Server 2008 ⓘ linked to: SQL Server
monitors	SQL Server instance performance ⓘ disk space usage ⓘ query performance ⓘ resource usage ⓘ
partOf	Microsoft SQL Server ⓘ linked to: SQL Server
provides	built-in performance reports ⓘ disk usage reports ⓘ query statistics reports ⓘ server activity history ⓘ
requires	SQL Server Agent ⓘ database engine ⓘ
storesDataIn	relational tables ⓘ
storesIn	relational database ⓘ
supports	capacity planning ⓘ centralized performance repository ⓘ collection from multiple servers ⓘ custom data collection sets ⓘ performance monitoring ⓘ trend analysis ⓘ troubleshooting ⓘ
supportsVersion	SQL Server 2008 ⓘ linked to: SQL Server SQL Server 2008 R2 ⓘ linked to: SQL Server SQL Server 2012 ⓘ linked to: SQL Server SQL Server 2014 ⓘ linked to: SQL Server SQL Server 2016 ⓘ linked to: SQL Server SQL Server 2017 ⓘ linked to: SQL Server SQL Server 2019 ⓘ linked to: SQL Server
uses	Management Data Warehouse database ⓘ SQL Server Agent jobs ⓘ SQL Server Integration Services ⓘ SQL Server Reporting Services ⓘ data collection sets ⓘ data collectors ⓘ

How these facts were elicited

Referenced by (3)

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

Policy-Based Management → integratesWith → SQL Server Management Data Warehouse ⓘ

Data Collection Wizard → requires → SQL Server Data Collection feature ⓘ

linked to: SQL Server Management Data Warehouse

Data Collection Wizard → relatedTo → Data Collection feature in SQL Server ⓘ