June 10, 2002 at 11:48 pm
Hi all
I have a box with 4 CPU's, all PIII 800Mhz. Queue length is 0.985 (4 day avg), refresh my memory but its:
"queue length per cpu should be <= 2 per cpu" ?
in my perf logs I cant select select each cpu individually, therefore, I dont need to worry until the queue hits over 8 (on average)?
Cheers
Chris.
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
June 11, 2002 at 5:08 am
Was thinking that was the number for disk queuing..will have to check!
Andy
June 11, 2002 at 5:52 am
I find most people go with 4 total and some go with 2 per CPU. Check both of these links out.
http://www.sql-server-performance.com/performance_monitoring_tutor_part4.asp
http://www.swynk.com/friends/trawick/Perfbase.asp
So in either case 0.985 looks find to me.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply