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

Experimenting with CHOOSE: #SQLNewBlogger

By

I was looking over the CHOOSE() function while editing an article at SQL Server...

Fighting Procrastination?

By

Here is another short video (~ 15 minutes). This is by the author of...

A Fun Prize at the PASS Data Community Summit

By

I had a briefing for the 2026 PASS Data Community Summit, which is just...

Read the latest Blogs

Forums

SQL Server 2025 Server-level Roles

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server 2025 Server-level Roles

Stairway to DAX and Power BI - Level 29: The DAX Combine & Aggregate Functions

By Bill Pearson

Comments posted to this topic are about the item Stairway to DAX and Power...

AI Is Improving Security

By Steve Jones - SSC Editor

Comments posted to this topic are about the item AI Is Improving Security

Visit the forum

Question of the Day

SQL Server 2025 Server-level Roles

In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?

See possible answers