|
|
Posted by Dave on 11/03/11 11:43
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]
|