Hi, My SQL server should utilize maximum memory , please let me know how to achieve this. Hardware Config : Dell Power Edge R710 , 96GB RAM , 4*600GB HDD (RAID-5) Software : Windows server 2003 Enterprise Edition 64bit & SQL 2005 Karuna

Hi Karuna, You can refer to: Enabling AWE Memory for SQL Server http://msdn.microsoft.com/en-us/library/ms190673.aspx Memory Support and Windows Operating Systems http://msdn.microsoft.com/en-us/windows/hardware/gg487508Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Enabling AWE Memory for SQL Server - OS is 64bit, so do i still need to enable AWE ?Karuna

Hello, for SQL related questions please use: http://social.technet.microsoft.com/Forums/en-US/category/sqlserver/ Or if programming is required also: http://social.msdn.microsoft.com/Forums/en-US/category/sqlserver/Best regards Meinolf Weber Disclaimer: This posting is provided "AS IS" with no warranties or guarantees , and confers no rights.

Hi Karuna, As Meinolf said, if you have further question related to SQL, we would like to suggest that you submit a new thread in our SQL forum for better and accurate answer to the question. The community members and support professionals there are more familiar with SQL and can help you in a more efficient way. Thank you for your understanding. BrentPlease remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.