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.
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.
Here's how it works:
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
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: