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!
Monday, May 18, 2009
The importance of SQL Server Performance Baseline Reports
Posted by
Aamir Syed
at
1:28 PM
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment