May 24, 2011 at 1:02 am
Hi Expertrs.
Windows Server 2003, 32 bit.
SQL Server 2005, Service Pack 3.
8 GB RAM.
Don't I need to enable AWE inorder for SQL Server to use more than 2 GB of memory.?
"Use AWE to allocate memory" Check box is unchecked in one of our client's SQL Server.
Please advice.
Thanks in advance.
May 24, 2011 at 1:27 am
What edition of SQL Server/OS?
__________________________
Allzu viel ist ungesund...
May 24, 2011 at 1:44 am
Joy Smith San (5/24/2011)
Hi Expertrs.Windows Server 2003, 32 bit.
SQL Server 2005, Service Pack 3.
8 GB RAM.
Don't I need to enable AWE inorder for SQL Server to use more than 2 GB of memory.?
"Use AWE to allocate memory" Check box is unchecked in one of our client's SQL Server.
Please advice.
Thanks in advance.
As started by Holio, AWE only applicable for SQL server 32 bit.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
May 24, 2011 at 2:00 am
See here:
http://msdn.microsoft.com/en-us/library/ms190673(SQL.90).aspx
Enable AWE to allow SQLServer to use more than 4 GB of RAM.
Hope this helps
Gianluca
-- Gianluca Sartori
May 24, 2011 at 4:18 am
Enable AWE 6GB if edition support and add your SQL Server Service account in lock pages memory rights
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
May 24, 2011 at 4:29 am
Syed Jahanzaib Bin hassan (5/24/2011)
... add your SQL Server Service account in lock pages memory rights
Not always needed, not always a good idea:
-- Gianluca Sartori
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply