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 :
- Do we really need MDW Database ?
- 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.