There is insufficient system memory to run this qu

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

There is insufficient system memory to run this qu

Author

Topic

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2012-03-26 : 23:11:35

Hi All,

We are having a server SQL 2005 enterprise edition with SP2 and 32GB RAM with AWE enabled.
(min server memory:0 and max server memory: 26 GB)

Ones in a day at least we used to get this error and its frequent now.

There is insufficient system memory to run this query.(701) error.

Please help me to resolve as this is production server.

Thanks,
Gangadhara MS
SQL Developer and DBA

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2012-03-27 : 06:00:50

What is the query?

N 56°04'39.26"
E 12°55'05.63"