Buffer

[manmaria]

I am extracting the data into a flat file before I do a bulk insert for a 4 mill records. When I am doing this in a package and the first step(extract data) is giving some messages in the results tab

[DTS.Pipeline] Information: The buffer manager detected that the system was low on virtual memory, but was unable to swap out any buffers. 3 buffers were considered and 3 were locked. Either not enough memory is available to the pipeline because not enough is installed, other processes are using it, or too many buffers are locked.


How do I change the settings to allocate more VM or a better buffer management?
TIA

 

[mrdenny]

How much memory is installed in the server?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[manmaria]

8gb

 

[mrdenny]

You can increase the amount of Virtual Memory that the system has in the system icon in the control panel.

For a SQL Server you'll also want to make sure that the system is setup to be optimized for background processes.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog