Monday, May 18, 2009

The importance of SQL Server Performance Baseline Reports

As I've been reading up on how to be a 'good' DBA, I remembered the performance baselilne reports my boss and I used to create back when I was a systems administrator. All critical servers (including database servers) should have a baseline report created. It helps immensley when trying to identify the root cause of certain problems (ie - abonormalities in disk, processor, memory activity).

This site provides a great step by step procedure in creating a performance baseline report. It clearly lists the common processes to monitor, and even shows how to export the data into a nice clear excel spreadsheet (your boss will be impressed! well, atleast he/she will be thankful!).

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

Good luck!

0 comments:

Tu comentario será moderado la primera vez que lo hagas al igual que si incluyes enlaces. A partir de ahi no ser necesario si usas los mismos datos y mantienes la cordura. No se publicarán insultos, difamaciones o faltas de respeto hacia los lectores y comentaristas de este blog.