Database Reference
In-Depth Information
11. Click Next to proceed.
We should now have completed the process to manage a
UMDW
database that is formed once
all the results of SQL Server instance validation process completes as Success.
How it works...
From the previous screenshot, if you look at the option, there cannot be a database named
sysutility_mdw
on the specified instance UMDW (Utility Management Data Warehouse)
data file is
sysutility_mdw
. All the performance data and policies are stored in this
database that helps to identify resource use bottlenecks and consolidation opportunities.
The UMDW name will be
Sysutility_mdw_<GUID>_Data
and SQL Server agent service will
handle the data load collection frequency
every
15
minutes
.
The configuration settings mentioned earlier, such as
UMDW name and collection set upload frequency are not
configurable in this release of SQL Server 2008 R2.
Search WWH ::
Custom Search