MS SQL Buffer Manager Detected Low Virtual Memory
Posted on 2007-10-03
I'm running a pretty basic select statement in SQL 2005 that takes data from one table in one database and copies certain columns and records to a similar but smaller table in a second database (using a Data Flow task in SSIS).
SELECT SALES_ORD_NR, SALES_ORD_LN_NR, EDP_NO_ID, ITM_QTY, EXT_PRC_AMT, EXT_COST_AMT, ORD_ITM_STA_LGCY_CD, 'Shipped' AS ItemStatus,
SHIP_DT AS Date
WHERE (ORD_ITM_STA_LGCY_CD = 'O') OR
(ORD_ITM_STA_LGCY_CD = 'S') OR
(ORD_ITM_STA_LGCY_CD = 'U') OR
(ORD_ITM_STA_LGCY_CD = '4') OR
(ORD_ITM_STA_LGCY_CD = 'R')
It appears that all the data is moving, but I'm getting the following when running the .dtsx using the Execute Package Utility:
"Information: The buffer manager detected that the system was low on virtual memory, but was unable to swap out any buffers. 4 buffers were considered and 4 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."
Any ideas why this might be happening and what I can do about it (if anything)? Please keep in mind that I have very basic knowledge of SSIS and MS SQL administration, so I will need detailed information in any responses - hence the 500 points.