Re: Torn pages with DL560 and SmartArray 5302-128 controller

From: Mike Epprecht \(SQL MVP\) (mike_at_epprecht.net)
Date: 02/04/05 

Date: Fri, 4 Feb 2005 07:25:29 +0100

Hi

!00% write results in all the data being cached before write. Not good at
all.

Get a replacement card from Compaq. This issue might just be an indication
that something else is wrong on it.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"mattis" <matti.saukkonen@D0ntSpamMe.mandatum.fi> wrote in message
news:esfFuffCFHA.1392@tk2msftngp13.phx.gbl...
> Mike Epprecht (SQL MVP) wrote:
> > Hi
> >
> > 100% write causes all writes to be cached. You want 100% read, 0% write
> > setting.
> >
> > Regards
> > Mike
> >
> Hi Mike :D
>
> Have to disagree on that :)
> tested the system with 100read 0write and got the Stale Read Error in
> few minutes
>
> Have now 2 instances of SQLIOStress running, the other one for about
> 1.5hours and the second one 30 minutes, No errors so far with 0 read /
> 100% write caching :)
>
> Empirically I have to disagree with your advise,
> but thank you very much of your assistance.
> it is nice to know there are still good people
> on the news groups
>
> rgrds Matti
>
>
>

Relevant Pages