Database Reference
In-Depth Information
•
Compare a range of values for the counters from the current and the baseline counter logs.
The fluctuation in the individual values of the counters will be normalized by the range of
values.
•
Compare logs from the same part of the day. For most applications, the usage pattern varies
during different parts of the day. To obtain the minimum, maximum, and average values of the
counters for a specific time, adjust the time range of the counter logs as shown previously.
Once the system-level bottleneck is identified, the internal behavior of the application should be analyzed to
determine the cause of the bottleneck. Identifying and optimizing the source of the bottleneck will help use the
system resources efficiently.
Summary
In this chapter, you learned how to use the Performance Monitor tool to analyze the overall behavior of SQL Server as
well as the effect of a slow-performing database application on system resources. With this you can create a baseline
for your system behavior so that you'll be able to understand when you're experiencing deviations from that standard
behavior. You'll want to collect a baseline on a regular basis so that the data doesn't get stale.
In the next chapter, you will learn how to analyze the workload of a database application for performance tuning.
