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.

AI illustration

How this image was made

AI-generated illustration of Management Data Warehouse

This AI-generated illustration was produced by black-forest-labs/FLUX.2-dev (1024x1024) from a prompt written by openai/gpt-oss-120b from the entity's label + description.

Prompt

Generate an image of Management Data Warehouse (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 2

How this entity was disambiguated

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 2008 ⓘ
linked to: SQL Server
isConfiguredWith Transact-SQL scripts ⓘ
data collection configuration wizard ⓘ
partOf Microsoft SQL Server ⓘ
linked to: 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 Database Engine ⓘ
linked to: SQL Server
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 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 SQL Server Agent ⓘ
SSIS packages ⓘ
data collectors ⓘ
relational database tables ⓘ

How these facts were elicited

Referenced by (2)

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

SQL Server → supportsFeature → Management Data Warehouse ⓘ
Data Collection Wizard → relatedTo → Management Data Warehouse ⓘ