Commonly used SQL Server 2000 Performance Monitors

The following items are common used "Health Meter" for SQL Server 2000:

SQL Server/NT Server Performance Monitor. (Displaying a wide range of system parameters. Activated by: Start->Run->PerfMon)
Current Activity Window. (Showing SQL Server Current Processes and Locks. Activated by: Start -> Programs -> MS SQL Server -> Enterprise Manager->Select a server->Management->Current Activity)
SQL Server Profiler. (Trace and Fine Tuning SQL Server Activities and Indexing. Activated by: Start -> Programs -> MS SQL Server -> Profiler.)
sp_monitor (Show how busy the SQL server has been. Activated by Start -> Programs -> MS SQL Server -> Query Analyzer -> sp_monitor)
sp_spaceused (Show how much disk space the table or database has used. Activated by Start -> Programs -> MS SQL Server -> Query Analyzer -> sp_spaceused)
sp_who (Show current users and status. Activated by Start -> Programs -> MS SQL Server -> Query Analyzer -> sp_who)
sp_lock (Show current lock and block information. Activated by Start -> Programs -> MS SQL Server -> Query Analyzer -> sp_lock)
DBCC commands (Database consistency checker. Activated by Start -> Programs -> MS SQL Server -> Query Analyzer -> DBCC .......)