January 15, 2003 at 11:10 am
Hi,
I need an input on this couter. I do a nightly full backup of all user databases to a network share. It takes 20 minutes to backup 90 databases . The backup do backup database one by one. I have no problem with 20 minute backup since the usage during backup is almost none. Anyway I setup a perfomance log to run during the backup. The Network Interface: Output Queue Length is 4294966260 (average). I did a search and http://www.sql-server-performance.com/performance_monitor_tips.asp
is an article regarding this counter. The author saying that, quoted, Output Queue Length counter to be very unreliable on an SMP machine, consistently reporting a base value of 4294966272 on my 8-way box!). Mine is a dual 700 box. I just did a real time monitor on the server; it stay at 4294934360! So how do I use this number? Can I trust it to say if I have a bottleneck?
Thx.
January 15, 2003 at 1:17 pm
I've found this counter to be very unreliable myself. I would look at Packets/sec and Bytes/sec and see if those values are out of range for the particular NIC card you have. There are also ways within SQL Server to determine if there is Network I/O bottleneck.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply