SQL insufficient memory error occurred

Asked By 0 points N/A Posted on -


I have been working with SQL Server 2000-2008 on different tasks, but I recently I encountered a problem. While trying to call “Execute SQL task” in SSIS which calls a stored procedure, SQL throws the following error. Any ideas?

Error code: 300

SQL code: 802

There is insufficient memory available in the buffer pool

Answered By 0 points N/A #176780

SQL insufficient memory error occurred


This error has occurred due to insufficient dynamic memory that is needed for the SQL server as a result of which this error pops up. I would like you to apply these two solutions to solve this problem the solutions are:-

To make more memory available for the SQL server application follow these steps:-

1 > If other applications beside the SQL server are consuming a vast amount of memory resource try running them on a different server.

2 > Increase the max server memory setting that you have configured before.

The second solution is to free SQL server memory caches by running these commands DBCC FREESYSTEMCACHE, DBCC FREESESSIONCACHE, DBCC FREEPROCCACHE.

Login/Register to Answer

Related Questions