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.


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.



I don't think it's our place to make the decision of you needing MDW or not. Only you and your team with your knowledge of your environments can make that decision, but if you're not using it then I would try to find out who installed it, for what reason and if that reason is still valid.

If you do decide to remove it, be aware there are some 'problems' with the uninstall. See this Connect item for all the pain people have suffered over the years with the uninstall.

You've tagged 2008 R2 and 2014, so the version of SQL Server that MDW is installed on will decide how many issues you will encounter when trying to remove MDW. 2012 added 3 stored procedures to help the process but even they don't quite remove everything. This TechNet post covers the problem and this post covers the solution for 2008 and 2012.

  • After reading the links,seriously, I never Imagined this was such a concern to mess with MDW.Thanks a lot @James Anderson,for hinting me on the serious points with MDW.Will work on these lines and it was real helpful. Oct 27 '16 at 9:49
  • @SQLBoy No worries, glad it was useful. Oct 27 '16 at 9:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.