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

score 1 · Accepted Answer · answered Oct 07 '11 at 14:19

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.

answered Oct 07 '11 at 14:19

Martin Smith

score 0 · Answer 2 · answered Oct 07 '11 at 14:15

0

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

answered Oct 07 '11 at 14:15

SQLMenace

1

i think OP is looking for a schema that captures the baseline - so he can grab one from his own environment - then compare later.. – Randy Oct 07 '11 at 14:24

2 Answers2