| title | Configure Your Utility Control Point Data Warehouse (SQL Server Utility) | Microsoft Docs |
|---|---|
| ms.custom | |
| ms.date | 06/13/2017 |
| ms.prod | sql-server-2014 |
| ms.reviewer | |
| ms.technology | configuration |
| ms.topic | conceptual |
| ms.assetid | c2c6f050-8cdb-4b8e-ad38-4aae0a949847 |
| author | MikeRayMSFT |
| ms.author | mikeray |
| manager | craigg |
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).