Tell me more ×
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.
up vote 3 down vote favorite

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
4  
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

1 Answer

up vote 4 down vote

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:

http://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/

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

 
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.