What do you feel is the best strategy for monitoring the performance of your SQL Server 2000 installation?
What hardware components are involved in successful monitoring of a database installation?
What can be done within the database itself to increase performance? Be sure to cite your sources.