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.
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 ⓘ |
Referenced by (1)
Full triples — surface form annotated when it differs from this entity's canonical label.