Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I want to design a process by which I can capture the baseline data of multiple SQL Server instances (2005 onwards) in a single database from where I can get all the info and alerts.

As of now I want to capture info about the below counters:

  1. Free space available on disks

  2. Database File and Log space available

  3. Wait statistics

  4. CPU and memory counters

Is there any free tool that I can refer to and modify if needed or any useful article that can help me to set this up?

As of now I am referring to the article by Erin Stellato in SQLServerCentral.com.

Any help would be greatly appreciated.

share|improve this question

2 Answers 2

Check out Rodney Landrum's SQL Server Tacklebox. It's a free book from Red Gate that includes scripts to do that:

http://www.red-gate.com/community/books/sql-server-tacklebox

share|improve this answer
    
Thanks alot Brent...will definitely come back to you in case I have any problem understand...thanks alot again..really appreciate.. –  Subhro Saha Jul 14 '13 at 15:55

What Brent suggested is a great resource.

There are many way of capturing baseline for your servers, just make sure that you are not collecting too much or too less and be consistent along with having a purge job to remove old data or have some mechanism to archive the collected data.

I would suggest you to also have a look at

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.