CODEWITHSUNDEEP
sqlsql-serverbaseline
Conrad Jagger
Conrad Jagger

Reputation: 2333

Creating Baseline repository for DMV Data

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

Upvotes: 2

Views: 531

Answers (2)

Martin Smith
Martin Smith

Reputation: 453288

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.

Upvotes: 1

SQLMenace
SQLMenace

Reputation: 135011

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

Upvotes: 0

Related Questions