Hi All,

We have a SQL server standard edition on windows 2003 enterprise edition R2 32bit edition with 8GB memory. SQL was using the default max server memory and crashing once in...

Hi all,

Lots of confusion regarding awe as SQL SERVER 2000 and 2005 provide different features.Few important points from msdn books online

http://msdn2.microsoft.com/en-us/library/ms179301.aspx

For Windows Server 2003, the AWE mapped memory management...

Hi Simone,

Thanks for your reply. If I use AWE enable, and lock pages in memory option on , do I need to enable /3gb switch as well? Just checked that my...

Thanks Micheal.

This msdn site has Latest sql help.

It may sound naive but cannot find the answer if report services, linked servers, full text using rest of the 4gb memory(total 8gb) which is not...

Hi ,

Do you have SP1 installed on the server? I am getting the error on the servers which are  without any service pack. I'll apply SP2 and try.