Management Data Warehouse Cleanup

Question

question

Blackhawk-17 asked Jan 29, '10

Management Data Warehouse Cleanup

Ok,

I've been reading about the new Management Data Warehouse (MDW) feature in SQL 2008. It looks good on paper. Instant baselines, trend analysis capabilities and historical performance analysis are all potentially a click away. There are canned reports with drill-down capability out-of-the-box.

By default you get 2 years of file size data (data and logs) and 2 weeks of query and system info before the automatic purge routines kick in.

My question is to those who have actually implemented this as a solution: How do I archive the reports?

Based on what I've read the MDW grows by 1 GB every 3-4 days or so. But for true performance analysis you would want to be able to look back over long periods.

I'm sure someone will have a quick, easy answer but I haven't stumbled across it yet.

As an aside... if you have set it up - how is it working for you?

Thanks;
Greg

sql-server-2008 performance mdw trend-analysis

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2010-02-01T06:13:17Z

Steinar answered Feb 1, '10

I Have used it for a while, and had some problems with the jobs stopping, and not working. Other thatn that I have also had problems with db size, trying to keep more than the default 14 days worth of data (exept file sizes 730 days) have filled up disks quite quickly. So I usually leave it at 14 days. The easy solution for archiving is to print the reports :-).

Havent tried to save a copy of the db every 14 days, but that migth be an idea too.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question