SQL insufficient memory error occurred

Asked By james cookc 0 points N/A Posted on - 10/16/2013

Hi,

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

• Status: Open
• Question Views: 851
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Salazar Chaidez -10 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.

About Salazar Chaidez

Questions
0

Answers
53

Best Answers
5

• Vote Up 0 Vote Down

• Posted on - 10/18/2013
• Question Category: MySQL Server