SQL Server Management Data Warehouse
E277002
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.
All labels observed (1)
| Label | Occurrences |
|---|---|
| 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
ⓘ
surface form:
SQL Server 2008
|
| monitors |
SQL Server instance performance
ⓘ
disk space usage ⓘ query performance ⓘ resource usage ⓘ |
| partOf |
SQL Server
ⓘ
surface form:
Microsoft 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
ⓘ
surface form:
SQL Server 2008
SQL Server ⓘ
surface form:
SQL Server 2008 R2
SQL Server ⓘ
surface form:
SQL Server 2012
SQL Server ⓘ
surface form:
SQL Server 2014
SQL Server ⓘ
surface form:
SQL Server 2016
SQL Server ⓘ
surface form:
SQL Server 2017
SQL Server ⓘ
surface form:
SQL Server 2019
|
| 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
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: SQL Server Management Data Warehouse Description of subject: 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.
Referenced by (1)
Full triples — surface form annotated when it differs from this entity's canonical label.