|
|
Posted by John Bell on 04/01/06 17:25
Hi Dave
I am not sure where 50K comes in when you are talking about a percentage?
John
"Dave" <daveg.01@gmail.com> wrote in message
news:1143473111.005381.49830@t31g2000cwb.googlegroups.com...
>I have already done that. I am getting numbers around 50K on % write
> time while I run my ETL.
>
>
> John Bell wrote:
>> 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.
>> >
>
Navigation:
[Reply to this message]
|