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

When you are hired as a DBA in a new shop, what are the important tools that you would use for establishing baselines and implementing benchmarks for 50+ instances? You advice would be highly appreciated.

share|improve this question
What database(s) are you using? Different database engines provide different facilities for that sort of thing. – Justin Cave Feb 23 '11 at 22:04
Sorry I should I mentioned that. It is for Microsoft SQL Server Databases. Thank you for your response. – db7 Feb 24 '11 at 1:58

For Microsoft SQL Server, the lowest-intrusive tool is Performance Monitor, aka Perfmon. Here's my tutorial on grabbing Perfmon counters for SQL Server and analyzing them:

share|improve this answer
Wow, It is an honor to get a response from you, Brent. Many THANKS. And, of course, your perfmon tutorial is so GREAT. I refer to it always. I was wondering if there is any other 3rd party tool to get the baseline in a very short time as there are many servers involved. Thank you again. – db7 Feb 24 '11 at 1:57
Hahaha, you're welcome, glad I could help! – Brent Ozar Feb 28 '11 at 4:00

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.