SQL Server Performance Forum – Threads Archive

Buffer problem

While doing DTS..I got this problem as below. "Information 0x4004800c: Data Flow Task: The buffer manager detected that the system was low on virtual memory, but was unable to swap out any buffers. 8 buffers were considered and 8 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." Pls tell me how to solve this in efficient manner. Regards,
Ashish Ashish Johri

---

I have run all these 4 commands: DBCC FREEPROCCACHE
DBCC FREESESSIONCACHE
DBCC FREESYSTEMCACHE
DBCC DROPCLEANBUFFERS Still problem persists.[V] Ashish Johri

---

]]>