Management Data Warehouse
E56732
Management Data Warehouse is a SQL Server feature that collects, stores, and reports performance and usage data to support monitoring and tuning of database systems.
All labels observed (1)
| Label | Occurrences |
|---|---|
| Management Data Warehouse canonical | 1 |
How this entity was disambiguated
This entity first appeared as the object of triple T452377 — 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.
Target entity: Management Data Warehouse Context triple: [SQL Server, supportsFeature, Management Data Warehouse]
-
A.
Office of the Chief Data Officer
The Office of the Chief Data Officer is a component of the U.S. intelligence community responsible for overseeing data governance, strategy, and management to support national intelligence objectives.
-
B.
Office of Data Science
The Office of Data Science is a specialized unit that applies advanced data analytics and quantitative methods to support the U.S. Securities and Exchange Commission’s economic, risk, and policy analysis.
-
C.
Master of Business Analytics
The Master of Business Analytics is a specialized graduate degree focused on applying advanced data science, statistical modeling, and quantitative methods to solve complex business problems and support data-driven decision-making.
-
D.
Power BI
Power BI is a Microsoft business analytics and data visualization platform used to transform, analyze, and present data through interactive dashboards and reports.
-
E.
Management Directorate
The Management Directorate is the division of the U.S. Department of Homeland Security responsible for overseeing the department’s administrative support functions, including budget, human resources, procurement, and information technology.
- F. None of above. chosen
- G. Unsure - the case is ambiguous/there is not enough information to decide.
Target entity: Management Data Warehouse Target entity description: Management Data Warehouse is a SQL Server feature that collects, stores, and reports performance and usage data to support monitoring and tuning of database systems.
-
A.
Office of the Chief Data Officer
The Office of the Chief Data Officer is a component of the U.S. intelligence community responsible for overseeing data governance, strategy, and management to support national intelligence objectives.
-
B.
Office of Data Science
The Office of Data Science is a specialized unit that applies advanced data analytics and quantitative methods to support the U.S. Securities and Exchange Commission’s economic, risk, and policy analysis.
-
C.
Master of Business Analytics
The Master of Business Analytics is a specialized graduate degree focused on applying advanced data science, statistical modeling, and quantitative methods to solve complex business problems and support data-driven decision-making.
-
D.
Power BI
Power BI is a Microsoft business analytics and data visualization platform used to transform, analyze, and present data through interactive dashboards and reports.
-
E.
Management Directorate
The Management Directorate is the division of the U.S. Department of Homeland Security responsible for overseeing the department’s administrative support functions, including budget, human resources, procurement, and information technology.
- F. None of above. chosen
Statements (50)
| Predicate | Object |
|---|---|
| instanceOf |
SQL Server feature
ⓘ
performance data repository ⓘ |
| accessedBy | SQL Server Management Studio ⓘ |
| category |
database monitoring tool
ⓘ
performance management tool ⓘ |
| collectsFrom | SQL Server instances ⓘ |
| collectsUsing |
SQL Server Agent jobs
ⓘ
data collection sets ⓘ |
| dataCollectionMode |
cached
ⓘ
continuous ⓘ scheduled ⓘ |
| dataRetention | configurable ⓘ |
| developedBy | Microsoft ⓘ |
| introducedInVersion |
SQL Server
ⓘ
surface form:
SQL Server 2008
|
| isConfiguredWith |
Transact-SQL scripts
ⓘ
data collection configuration wizard ⓘ |
| partOf |
SQL Server
ⓘ
surface form:
Microsoft SQL Server
|
| provides |
built-in reports
ⓘ
disk usage reports ⓘ historical performance data ⓘ performance trend analysis ⓘ query statistics reports ⓘ server activity reports ⓘ |
| requires |
SQL Server Agent to be enabled
ⓘ
a dedicated database ⓘ |
| runsOn |
SQL Server
ⓘ
surface form:
SQL Server Database Engine
|
| stores |
disk usage data
ⓘ
index usage statistics ⓘ performance data ⓘ query statistics ⓘ server activity data ⓘ usage data ⓘ wait statistics ⓘ |
| storesDataIn | relational tables ⓘ |
| supportsTask |
bottleneck analysis
ⓘ
capacity planning ⓘ performance monitoring ⓘ performance tuning ⓘ trend analysis ⓘ |
| 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 |
SQL Server Agent
ⓘ
SSIS packages ⓘ data collectors ⓘ relational database tables ⓘ |
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.
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.
Subject: Management Data Warehouse Description of subject: Management Data Warehouse is a SQL Server feature that collects, stores, and reports performance and usage data to support monitoring and tuning of database systems.
Referenced by (1)
Full triples — surface form annotated when it differs from this entity's canonical label.