Re: delayed write failures

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Phillip Windell (_at_.)
Date: 08/06/04 

Date: Fri, 6 Aug 2004 16:08:29 -0500

Just a guess,...maybe you could turn off write caching on the effected drive
temporarily to see if it improves.

In Device Manager, goto Properties of the Drive, select the "Disk
Properties" of the Drive, uncheck the "Write Cache enabled" box. 

-- 
Phillip Windell [MCP, MVP, CCNA]
www.wandtv.com
"Shawn Smith" <acegator@hotmail.com> wrote in message
news:O4ufwg$eEHA.636@TK2MSFTNGP12.phx.gbl...
> Our databases are residing on the Windows2003 File share, They are a
mixture
> of foxpro and access databases, main issue we are seeing is when we do
> compacting of access databases and reindexing of the foxpro databases. The
> errors are inconsistant and randly occur during the processes.
>
>
>
> "Ron" <anonymous@discussions.microsoft.com> wrote in message
> news:192f01c47bef$223cb2e0$a401280a@phx.gbl...
> > It is NOT the hardware.  If you read my MAS90 lockup
> > situation just below your post - we are in the same boat!
> > XP and W2K3 are having some serious network connectivity
> > problems with DB's using ODBC or delayed read/writes!!!!
> >
> >>-----Original Message-----
> >>XP client sp1 with all hotfixes and windows2003 server
> > with all hotfixes.
> >>
> >>Problem: when client make rapid updates to any type of
> > database we get
> >>delayed write errors on the client machines , the server
> > does not report any
> >>errors.  We opened a case with microsoft and they gave us
> > the following
> >>suggestions. ;
> >>
> >>apply KB834350  -- DONE - Latest redirector files for
> > Windowsxp
> >>
> >>force duplex settings on client and switch - DONE
> >>
> >>turn of op locking on client and server - DONE
> >>
> >>NetBIOS over TCP/IP set to Default.  -done changed to
> > Enable
> >>
> >>
> >>
> >>They sent us the latest redirector files for windows 2003
> > today; KB Article
> >>Number(s): 843517
> >>
> >>we are still able to generate the delayed write failures
> > in a testbed of 8
> >>machines consistently. It only happens when we have
> > significant bursts of IO
> >>on foxpro databases, any type of file share database.
> > Windows2000 Clients
> >>sp4 do not have the same issues.
> >>
> >>
> >>
> >>The server is a test server
> >>
> >>COMPAQ DL380 G2
> >>
> >>DUAL P4 1.4GHZ
> >>
> >>4 gigs ram
> >>
> >>Intel Pro1000f gig adapter
> >>
> >>
> >>
> >>Has anyone run into this particular issue?  and what did
> > you do to fix the
> >>issue?. thank you.
> >>
> >>
> >>.
> >>
>
>

Relevant Pages

  • Re: Performance Question when using a DataReader
    ... Client applications (where a user interacts with the ... server) to show to the user. ... performance of these routines often creating databases to manage the ... William (Bill) Vaughn ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Portable stored procedures
    ... > I haven't used Java stored procedures with databases but your statement is ... a string, that was needed in the client and in the server - in many cases, ... language you are using) and in the server in some sql-script language - or C ... memory size limits for JVM's on certain platforms etc.). ...
    (comp.lang.java.databases)
  • Re: migrating from MSAccess...
    ... > using MSAccess for some simple databases. ... > We currently have separate databases ... and add a key field to show which client the records belong to. ... > of that front-end linked to the master tables on the server. ...
    (microsoft.public.sqlserver.server)
  • Re: Need advises for multi-database webapp
    ... This modification seem to have reduced my number of connection drasticly. ... > If I were doing this with Sybase or MS SQL Server, ... > the client libraries. ... >> databases at the same time. ...
    (perl.dbi.users)
  • Re: AS2005 ... what is wrong with it?
    ... What I have seen is that the dev server is *faster* than the prod server ... And does your dev server also have all 6 databases with all these roles? ... When I restore the "PROV" i got approx 20 sec. ... Starting from an empty data folder should show if this theory is true ...
    (microsoft.public.sqlserver.olap)