none
Insufficient memory

    Question

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

    WE upgraded from a 32 bit, 4 GB, Windows 2003 server, SQL server 2005 machine to a 64 bit, 2 processor quad core, 8 GB Ram, Windows server 2008, SQL server 2008 machine. 
    We used to run some pretty heavy Stored procedures on the old sever. 
    But after we migrated to this new server, which is more powerful than the old one, we are hitting this issue - There is insufficient system memory in resource pool 'internal' to run this query. 
    Initally AWE was not enabled, and there min memory for SQL server was 0, and max memory was the default value, so the SQL server service was consuming the entire 8GB, and some of the jobs started failing due to insufficient memory in the internal resource pool.

    I have enabled AWE, and set the min and max SQL memory settings to 5 GB, and that does not help either. What else could i do? The setting to the resource pools are still default settings, so please let me knwo if any tweak is required there.
    Is AWE required on a 64 bit machine?

    Please help. 
    Thursday, February 04, 2010 2:35 PM

Answers

All replies