Configure Management Data Warehouse Storage (Configure Management Data Warehouse Wizard)
Use this page to select a SQL Server database server and management data warehouse. The management data warehouse is a relational database that will store collected data.
Note
You must have the appropriate level of permissions in order to create the management data warehouse on the server. For more information, see CREATE DATABASE (Transact-SQL). You also must have the appropriate level of permissions to create logins for management data warehouse roles. For more information, see Data Collector Security.
Server name
Specifies the name of the server that will host the management data warehouse.When configuring a management data warehouse, Server name is always the name of the local server and cannot be modified.
…
Open the Connect to Server dialog box, where you can select a server that will host the management data warehouse.This option is available only when configuring a data collection set.
Database name
Specifies the relational database that will store collected data. Use the list to select an existing database or click New to create a new database using the New Database dialog.The New option is available only when configuring a data collection set
Cache directory
Specifies the location where collected data is cached locally before it is uploaded to the management data warehouse. By default, the data collector uses the %Temp% or %Tmp% directory if it is configured on the computer where the data collector is installed.This option is available only when configuring a data collection set.
…
Open the Find cache directory browser. This is only necessary if the %Temp% or %Tmp% directory is not configured for the host computer.This option is available only when configuring a data collection set.
Start data collection
Check this option to automatically start the data collection set after completing the wizard.This option is available only when configuring a data collection set.
See Also