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

How important is having great soft skills as a Software Engineer for personal growth and career…

By

How important is having great soft skills as a Software Engineer for personal growth...

Master Advanced SQL: 2 Essential Courses for Every Data Analyst

By

If you're a data analyst, you already know that SQL isn't just a nice-to-have...

Friday Flyway Tips–State-based Deployments

By

Recently the Flyway Desktop (FWD) team release support for state-based deployments. These are similar...

Read the latest Blogs

Forums

The Costs and Rewards of Speaking

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Costs and Rewards of...

Manage Elastic jobs in Azure using Azure Elastic Jobs Manager

By Kunal Rathi

Comments posted to this topic are about the item Manage Elastic jobs in Azure...

Takeaways from Data Grillen 2024

By Tonie Huizer

Comments posted to this topic are about the item Takeaways from Data Grillen 2024

Visit the forum

Question of the Day

Inserting Transaction Marks

When is a transaction mark first inserted into the msdb.dbo.logmarkhistory table?

See possible answers