Tuesday, February 14, 2012

Busy Read/Write Disk

HI,
I have a problem with SQL2000, standard, sp3 running on
Win2K server, SP4.
There's a weekly operation of loading data about 30,000
records - letters. In this time my Busy Read/Write Disk
counter pages me for consistant failure and you could
imagine the performance degradation for this moment.
What could I do (I mean settings changed or?) if I could
not move the loading in off hours?
Thanks a lot.30,000 rows is not a lot of data and should not be that big a deal once a
week. What do you mean by pages you for constant failure? There is no
failure point per say with the counter. How are you loading the data and do
you have the log file on a separate disk array?
Andrew J. Kelly
SQL Server MVP
"MJ" <mschwenger@.cca-lv.com> wrote in message
news:034401c37bbb$64e27790$a301280a@.phx.gbl...
> HI,
> I have a problem with SQL2000, standard, sp3 running on
> Win2K server, SP4.
> There's a weekly operation of loading data about 30,000
> records - letters. In this time my Busy Read/Write Disk
> counter pages me for consistant failure and you could
> imagine the performance degradation for this moment.
> What could I do (I mean settings changed or?) if I could
> not move the loading in off hours?
> Thanks a lot.
>

No comments:

Post a Comment