Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Configure Your Utility Control Point Data Warehouse (SQL Server Utility)

Configure Your Utility Control Point Data Warehouse (SQL Server Utility)

 

Data collected by managed instances of SQL Server 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 SQL Server:

  • 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.

System_CAPS_noteNote

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).

Community Additions

ADD
Show:
© 2015 Microsoft