Call now: (800) 766-1884  



 Home


 SQL Server Tips
 SQL Server Training

 SQL Server Consulting
 SQL Server Support
 SQL Server Remote DBA



 Articles
 Services
 SQL Server Scripts
 Scripts Menu



 

 

 

   
  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:

  • I/O

  • CPU

  • Memory

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  

 

Burleson Consulting Remote DB Administration


 

 


 

 

 

 

 
Burleson is the America's Team

Note: The pages on this site were created as a support and training reference for use by our staff of DBA consultants.  If you find it confusing, please exit this page.

Errata?  SQL Server technology is changing and we strive to update our SQL Server support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:and include the URL for the page.
 


Burleson Consulting
SQL Server database support

 

Copyright © 1996 -  2013 by Vaaltech Web Services. All rights reserved.

Hit Counter