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

Reverse Engineering a Physical Model Diagram

By

I recently wrote about a logical diagram with Redgate Data Modeler. That was interesting,...

Prepping for Certification, Part 3 of ?

By

After I have understood the details for a certification test (part 1), including format...

SQL Training Black Friday Deals

By

If you're looking for particular "Black Friday" deals, here is what I've seen advertised...

Read the latest Blogs

Forums

Best analysis approach to reduce data type length in multiple tables

By Lord Slaagh

Hello SSC, I hope everyone is having a happy and safe holiday season! I...

Do you separate data/log files and TempDB files on different disks using AWS EC2

By WebTechie

Hello,   I am receiving multiple direction on deploying SQL Servers in AWS EC2. ...

Service account being in local admin in AWS EC2 environment?

By WebTechie

Hello, I am working with a company on their database administration.  I am trying...

Visit the forum

Question of the Day

A New Operator

In SQL Server 2025, what does this code return? 

SELECT '1' || '0'
 

See possible answers