The buffer manager detected that the system was low on virtual memory | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

The buffer manager detected that the system was low on virtual memory

Hi,
I am extracting data from Oracle table and storing in .caw file (using cache connection manager)
Total number of records in source =2500000
when extraction progress reaches at 1100000 , throughs error "given below"
"[SSIS.Pipeline] Information: The buffer manager detected that the system was low on virtual memory, but was unable to swap out any buffers. 0 buffers were considered and 0 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.
" I have used following setting in my package.
DefaultBufferMaxrows 1000
Ddefaultbuffersize 104857600
BLOBTempstoragepath pointed to D: Derive, being OS is in C derive
BufferTempStoragePath pointed to D: Derive ,being OS is in C derive Please let me know how can i get complete records in target file.
Thanks in advance.
regards,
Ashok

How frequently you are running this package to obtain the rows?
What is the memory setting on SQL Server?
What is the physical memory set on server?

Hi , Thanks for response.
This is one time job only. I need to run it only once. Available Physical Memory 539627520 Available Virtual Memory 304111616.
Regards,
Ashok

This doesn’t help, you have to confrim that what is the memory setting on SQL SErver and what is the physical memory on the server.

HI thank for response.
Currently I am working on my desktop and made same as server. It is not of high cofigration as it is required for our job to accomplish.
Can you please suggest me the Server level configration required for transfering crors of records from one database to another database. though its one time transfer only.
Few tables are having 4 Crores + reocrds .
It will be very helpfull for me if I can know best configration for a server to deal with these many records. Also please advise some more configration at SSIS level which I can follow up and get ot done.
Thanks in Advance.

See this MSDN page http://msdn.microsoft.com/en-us/library/ms143506.aspx that taslk about hardware configuration to install SQL Server, which talks about 2005/2008/2008 R2 and upcoming DENALI version too.

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |