 |
|
SQL Server Tips by Robin Schumacher
|
Server Workload Analysis
In truth, server workload analysis is not the best judge of overall
SQL Server health. This is primarily due to the fact most of the
available statistics are cumulative in nature and are not much use
for a server that has been up a long time. Some third party monitors
and the Windows NT performance monitor get around this problem by
calculating delta measures between the monitor’s sampling intervals.
This makes it much easier to see spikes in, for example, physical
I/O.
However, the DBA can still get a feel for overworked servers by
running a few SQL scripts and stored procedures. In general, the
following three areas will be reviewed in this book:
This chapter will focus on I/O and CPU
usage, while the following chapter will explain memory workload.
One somewhat antiquated method of obtaining base CPU and I/O metrics
is to run the sp_monitor stored procedure. This procedure provides
core measurements as to the magnitude of CPU activity, read and
write activity and etc. The procedure gives the DBA an idea about
changes between the measurements from the time the last iteration of
sp_monitor was run until the current run. Although this is helpful,
it is very dependent on the DBA continually issuing the command to
obtain the data.
The above book excerpt is from:
High-Performance SQL Server DBA
Tuning & Optimization Secrets
ISBN:
0-9761573-6-5
Robin Schumacher
http://www.rampant-books.com/book_2005_2_sql_server_dba.htm |
