O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required