activity monitor: resource waits

Hi experts;

i am reading about: resource waits, but i do not understand
Network IO
and
Buffer IO

what are the recommended values? when performance is an issue?
enrique_aeoAsked:
Who is Participating?
 
Mark ElySenior Coldfusion DeveloperCommented:
Reference Microsoft 70-462 books pages:

Page 373,375, 406-407 for the System Processor Queue
Pages 375 for the Network Interface Output Queue Length and Network I/O
Pages 375, 403-404 for Physical Disk Average Disk Queue Length
Page 406 for Buffer I/O
0
 
Mark ElySenior Coldfusion DeveloperCommented:
The buffer is specific to an application.  A rate of 90% or higher is desirable.  Add more memory until the value is consistently greater than 90%.  What this means is with a buffer value of 90% indicates that more than 90% of all request for data were satisfied from the data cache.  

There are three counters that indicate a system problem:

1) System Processor Queue Length
2) Network Interface Output Queue Length
3) Physical Disk Average Disk Queue Length

When the processor, network interface, or disk becomes overwhelmed with activity processes need to wait for resources to become available.
0
 
enrique_aeoAuthor Commented:
There are three counters that indicate a system problem:

1) System Processor Queue Length
2) Network Interface Output Queue Length
3) Physical Disk Average Disk Queue Length

values should shed those counters to consider a problem?
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
Mark ElySenior Coldfusion DeveloperCommented:
A processor queue of 8 indicates that there is insufficient processor capacity on the machine and that 8 request are waiting in a queue for a processor core to become available.  

With the Network Interface output values longer than 2 indicate there are delays.   The Output queue length is the length of the the output packet queue.   Large negative or values greater than 1000 are invalid and should be ignored.

The PhysicalDisk % disk time counter monitors the percentage of time that the disk is busy with read and write activity.  If this counter is above 90 % you check the Physical Disk current disk queue length to see how many system request should be sustained at 1 1/2 to 2 times the number of spindles that make up the physical disk.  (NOTE: most disks have 1 spindle; however RAID devices have more than 1 spindle).

If the current disk queue length and % disk time counter values are consistently high consider doing one of the following:
1) Use faster hard drives
2) move some files to another disk or another server
3) Add more disk to the RAID array if one is being used.

If you are using a RAID device and the % disk time counter is 100% use the physicalDisk: Avg. diskqueue length counter to determine how many system requests on average are waiting for disk access.
0
 
enrique_aeoAuthor Commented:
please, URL or article?
0
 
Mark ElySenior Coldfusion DeveloperCommented:
This information is in the Microsoft 70-462 book which is part of the DBA  test.  

You can get the book  at:

http://www.amazon.com/Training-70-462-Administering-Microsoft-Databases/dp/0735666075
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.