Detecting A CPU Bottleneck
- 0
- Add a Comment
In SQL Server 2005 there several ways to detect a CPU bottlneck. The first way to detect a bottleneck is by looking at the System Monitor counter Processor: % Processor Time. If the value of this counter is greater than 80% for 15 to 20 minutes in duration, then it is a good indication that […]