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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

Any help would be greatly appreciated.

share|improve this question

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

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


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.