Subject | Re: When do FB/IB 'flush' to disk? |
---|---|
Author | karyakin@cmpmail.com |
Post date | 2001-11-30T14:28:52Z |
Hello,
"Phil Shrimpton" <phil@...> wrote in message
news:01113000385001.05467@fred...
disk
success yet. On a computer with 256M RAM (W2K server) the data is
phisically written within few seconds (tested by hard power off).
file
the
if
-- is it NT4 and which service pack it has.
-- number of page buffers configured for IB,
-- database page size,
-- amount of RAM in the computer and
-- size of the server process working set while importing the data
(using the Performance Monitor it the Administrative Tools menu).
Thanks.
Regards,
Aleksey Karyakin
"Phil Shrimpton" <phil@...> wrote in message
news:01113000385001.05467@fred...
>the
> I think it is very important that at some point data is written to
disk
> files <g>I'm trying to reproduce the situation and, unfortunately, without a
success yet. On a computer with 256M RAM (W2K server) the data is
phisically written within few seconds (tested by hard power off).
> > > - I imported 200Mb of data in to a blank databasehave
> > > - Left the server and client app idle for 4 hours
> > > - Pulled the power cord
> > >
> > > ...the database was blank after boot up
> >
>
> I am running a test at the momement, (with forced writes off), I
> inserted approx 1.5 GB into an empty database (and rising), and theGDB
file
> is still only 3MB (I know about the explorer display issue). If Ipull
the
> cord, the database will be empty, but I am kepping the import goingto see
if
> Windows will eventually flush the data, or something blows.Phil, could you provide some information:
-- is it NT4 and which service pack it has.
-- number of page buffers configured for IB,
-- database page size,
-- amount of RAM in the computer and
-- size of the server process working set while importing the data
(using the Performance Monitor it the Administrative Tools menu).
Thanks.
Regards,
Aleksey Karyakin
> Phil