SQL Server Performance

The buffer manager failed a memory allocation call for 20485670 bytes, but was unable to swap out any buffers to relieve memory pressure

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Feb 1, 2010.

  1. Anonymous New Member

    A typical error occurred when a simple SSIS package has been executed to export 500 rows to another SQL instance, not once atleast 3 times! More information on error text from event viewer that has been generated by the 'service; The buffer manager failed a memory allocation call for 20485670 bytes, but was unable to swap out any buffers to relieve memory pressure. 235 buffers were considered and 195 were locked. Either not enough memory is available to the pipeline because not enough are installed,...(<a href="http://sqlserver-qa.net/blogs/bi/archive/2010/02/01/the-buffer-manager-failed-a-memory-allocation-call-for-20485670-bytes-but-was-unable-to-swap-out-any-buffers-to-relieve-memory-pressure.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=6271" width="1" height="1">

Share This Page