|
Posted by Robert Klemme on 04/10/06 18:34
JSParker1@hotmail.co.uk wrote:
> Summary: Maximum number of records per second that can be inserted into
> SQLServer 2000.
>
> I am trying to insert hundreds (preferably even thousands) of records
> per second in to SQLServer table (see below) but I am getting the
> following error in the Windows Event Viewer Application log file:
>
> "Insufficent Memory......"
Did you maybe misconfigure your system? You might have set up SQL
Server to use more mem than you have virtual mem in your machine.
Otherwise I don't see how SQL Server should bail out with this error.
> And very few records were inserted and no errors where sent back via
> the JDBC.
Hint: use batch mode if you don't yet. Alternatives: bcp, DTS.
Kind regards
robert
Navigation:
[Reply to this message]
|