On Friday 30 November 2001 14:28, you wrote:

Hi,

> 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).

Are you leaving the connection open? I can reproduce this at will quite
easily.

> Phil, could you provide some information:
> -- is it NT4 and which service pack it has.

NT4 SP6a and W2K SP2

> -- number of page buffers configured for IB,

10,000

> -- database page size,

8K

> -- amount of RAM in the computer and

256 - 512 (I have triend on a number of machines)

> -- size of the server process working set while importing the data

84.244K

Which I believe is 10,000 x 8K = 80Mb for the Cache, and 4,244 for the actual
server?

Phil

--
Linux 2.4.4-4GB
5:40pm up 6:34, 1 user, load average: 0.51, 0.27, 0.21