BULK INSERT & DIRTY BUFFERS - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

BULK INSERT & DIRTY BUFFERS

Author

Topic

sonaht
Starting Member

6 Posts

Posted - 2005-08-26 : 05:34:46

Hi all

Using SQL 2000 MSDE

I'm bulk inserting about 3.200.000 records into a table

unfortunately all memory dissapears and never returns the dirty buffers count goes up to 48000 approx.

any ideas on how to rectify this ..... ?

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-08-26 : 08:03:18

If you run the CHECKPOINT command, followed by DBCC DROPCLEANBUFFERS, that should flush everything to disk and recover that buffer space. However, SQL Server/MSDE will still keep the memory allocated until you restart the service.

sonaht
Starting Member

6 Posts

Posted - 2005-08-26 : 08:35:03

Thanks .....

Through trial and error I have reached to the same conclusion

Thank you very much

sonaht
Starting Member

6 Posts

Posted - 2005-08-26 : 08:35:09

Thanks .....

Through trial and error I have reached to the same conclusion

Thank you very much

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources