Creating Baseline repository for DMV Data

Question

I have started to use DMVs to identify the performance issues we have been encountering in our SQL Server.

Has anyone built a repository to capture this DMV data which can be then baselined and compared against the current data moving forward?

Regards

Answer 1

What version of SQL Server? If 2008 you can take a look at the Management data warehouse. Otherwise you could have a look at the DMVStats project.

Answer 2

Take a look at Creating a baseline for SQL Server to get some ideas

You can not just grab someone's baseline....your server is most likely completely different