I'm performing a bulkcopy of 400.000 rows, and while the BCP (BULK INSERT)
is running the amount of memory used by SQL Server increases from 90 MB to
215 Mb. The ROWS_PER_BATCH is set to 10.000, but I just read the option
ROWS_PER_BATCH doesn't work if the BATCHSIZE parameter is not specified.
There is an index on the table, and the log was getting full, but that is
fixed now. But why doesn't release SQL Server the memory? The PC has 256Mb,
which should be enough, but the performance is not to good when 215 Mb is
used by SQL Server.
Even if all clients are disconnected, the memory used by SQL Server stays
215 Mb. Restarting the server will bring back a good performance.
Did anyone had the same problems or know a solution?
Kind regards and a Merry Christmas,