servr memory issue - SQL Server Forums

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)

servr memory issue

Author

Topic

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2011-10-19 : 22:54:07

Hi All,
I have SQL server 2005 with enterprise edition 32 GB of RAM with AWE enabled.

I am frequently getting this error.

There is insufficient system memory to run this query.and if we restart the SQL server it will go away i wish not to restart the server.

What are the possible solution to this.

Thanks,
Gangadhara MS
SQL Developer and DBA

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-10-19 : 23:04:54

You should consider getting to 64-bit.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2011-10-20 : 00:31:52

Hi Tara,

Thanks for the response.
What are all the point we should consider to move to 64-Bit edition,i am new to admin if you suggest will be great help.

Thanks,
Gangadhara MS
SQL Developer and DBA

Cindyaz
Yak Posting Veteran

73 Posts

Posted - 2011-10-20 : 08:54:19

what are the min and max memory settings for SQL Server? How much memory is SQL Server using during peak time?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources