What are the types of Reports that can be taken with regards to SQL Server DBs, Performance, locks etc in a Week/Month?
I need this for SQL 2000.
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
Take a look at the excellent article series on Performance Tuning by Brent Ozar.
The series provides a complete process walkthrough, ranging from what metrics you should look to collect to how you go about collecting them, right through to analysing the results in Excel.
No one has followed this question yet.
The Gestalt of Performance? Just curious...
Upgrading database from 2000 to 2005 performance degradation
Slow delete statement
SQL 2000 - TEAMING OF NICs
SQL Server 2000, large transaction log, almost empty, performance issue?