Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition

Using the Performance Monitor for Trend Analysis

Frequently problems arise because DBAs are caught off guard and run out of system resources such as disk space, processing power or memory. For example, a DBA may not realize that a particular database (maybe one of 100 he is managing) is growing at an alarming rate due to heavy transaction load. Or perhaps your company is adding new employees on a monthly basis to use your SQL Server systems and suddenly one day you realize that the processors on the machine are pegged constantly above 90 percent. Maybe you do a great job monitoring your system resources and you are always looking for ways to improve the performance of your SQL Server and databases and one such way would be to properly size tempDB ...