| Info: 2012-03-14 10:51:01.51
Code: 0x4004800D
Source: my dataflow
Description: The buffer manager failed a memory allocation call for 65536 bytes, but was unable to swap out
any buffers to relieve memory pressure. 2830 buffers were considered and 2830 were locked. Either not enough
memory is available to the pipeline because not enough are installed, other processes were using it, or too ma
ny buffers are locked.
End Info |
If you are using full cached mode in your data flow, you might want to review your RAM requirement.
If you are running SQL on the very same server as SSIS, consider to reduce the max server memory in order to provide Dtexec with more RAM.
No comments:
Post a Comment