Posted by John Bell on 03/25/06 02:43

Hi Dave

Use perfmon to get the information you require regarding disc performance,
that will show if new hardware is needed. Look at disc queue length, idle
time, read/write rates etc see
http://www.sql-server-performance.com/sql_server_performance_audit2.asp for
more.

John

"Dave" <daveg.01@gmail.com> wrote in message
news:1142881128.014369.273010@i39g2000cwa.googlegroups.com...
> Very good suggestions John! I agree that log files should be on a
> separate spindle, and that I should break down the file groups into
> multiple physical files, etc, etc.
>
> I will implement all of these suggestions as soon as I get the
> opportunity, however I do not think they will increase the throughput
> enough to meet our needs.
>
> We are only using 2 Raid 5 arrays right now. That somewhat limits the
> load balancing options. I am really pushing for another Raid
> Controller card or even 2 so I can properly balance the system.
>
> There is some bad code out there, but I have re-written most of it and
> I'm sure I can make further improvements, though I do not think it is
> a major issue anymore.
>

[Back to original message]