Management Data Warehouse Database

0 votes

1 answer

260 views

sql-server sql-server-2008-r2 sql-server-2014 management-data-warehouse

                          We have a MDW Database in our PROD Server of size 40GB.

I can see all the collector Jobs are not running properly and the purging MDW job.

    mdw_purge_data_[ManagementDWH] 
is not running saying the owner does not have access to server.

When I access the Tables in MDW Database I can see all the tables are updated few months ago.

Can anyone help me with below queries :

 1. Do we really need MDW Database ? 
 2. What if I delete my existing MDW Database (Unless we need to troubleshoot any performance issues) ?

Please let me know if is required to keep the MDW Database.

Thanks

Asked by Learning_Learning (1620 rep)

Oct 27, 2016, 08:18 AM
Last activity: Oct 27, 2016, 11:49 AM

Management Data Warehouse Database

Related Questions