Management Data Warehouse

External Article

Removing the SQL Server Management Data Warehouse

  • Article

SQL Server 2008 introduced a new feature, Management Data Warehouse (MDW), which allows users to collect metrics on their servers over time to aid in performance troubleshooting. A lot of people try this feature out, because it is easy to set up, and then find that it is not so easy to remove. In fact, removing MDW is not supported; in SQL Server 2012, though, a new system stored procedure was added to make this process easier. The problem is that this stored procedure (as well as several of the workarounds I've seen published) can leave several objects behind.

2012-08-09

2,418 reads

Blogs

Daily Coping 28 Jun 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Creating a Database Audit Specification can create new users & schemas in the background

By

I love database audits. They are simple, easy to use, effective, not overly resource...

Alert Filtering in SQL Monitor

By

SQL Monitor has improved a lot over the last couple of years. We have...

Read the latest Blogs

Forums

Azure Pricing, SQL Server seems pretty high?

By keven11

Hi, I'm really new to this and I think I've got this wrong, wondering...

Linked Server only tables in catalog are available

By daniel.dolan

I have two servers, ServA and ServB. ServA is set up as a linked...

NOT and NULL

By kuopaz

I've been here before on this but have come across it again, so wanted...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers