| title | Configure Your Utility Control Point Data Warehouse (SQL Server Utility) | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/14/2017 | |
| ms.prod | sql-server-2016 | |
| ms.reviewer | ||
| ms.suite | ||
| ms.technology |
|
|
| ms.tgt_pltfrm | ||
| ms.topic | article | |
| ms.assetid | c2c6f050-8cdb-4b8e-ad38-4aae0a949847 | |
| caps.latest.revision | 8 | |
| author | JennieHubbard | |
| ms.author | jhubbard | |
| manager | jhubbard |
Data collected by managed instances of [!INCLUDEssNoVersion] are stored in the utility management data warehouse (UMDW); the UMDW file name is sysutility_mdw.
You can configure the UMDW data retention period. For more information, see Utility Administration (SQL Server Utility).
The following configuration settings are not configurable in this release of [!INCLUDEssNoVersion]:
-
UMDW name: Sysutility_mdw.
-
Collection set upload frequency: Every 15 minutes.
The UMDW directory is configurable: <System drive>:\Program Files\Microsoft SQL Server\MSSQL10_50.<UCP_Name>\MSSQL\Data\, where <System drive> is normally the C:\ drive. The log file, Sysutility_mdw_<GUID>_LOG, is located in the same directory.
Note
The UMDW (sysutility_mdw) file location can be changed using detach/attach or ALTER DATABASE. We recommend the use of ALTER DATABASE. For more information see ALTER DATABASE (Transact-SQL).