Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2008
    Posts
    135

    Unanswered: insufficient system memory

    Hi,

    Why iam getting this error when i tried to execute any stored procedure

    There is insufficient system memory in resource pool 'default' to run this query.

    How to resolve this problem.

    Please respond...

  2. #2
    Join Date
    Apr 2010
    Posts
    2
    I assumed that you are running executing this on web application with SQL 2008.

    By default, SQL 2008 setting for memory is only 256MB. Thus when it reach its limit, there is not enough memory to run the query.

    Try make changes on the SQL configuration manager start up. And used -g384 and restarted it. Now it will provide 384MB for the physical memory allocation. If that's not enough try used slightly higher. Do not use too much cause it will be wasting of physical memory space.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •