Would you suggest using AWE Memory on Windows 2008 R2 for MS SQL 2008?
What are the benefits of using it or not using it.
Thanks
|
Would you suggest using AWE Memory on Windows 2008 R2 for MS SQL 2008? What are the benefits of using it or not using it. Thanks |
|||
|
|
|
AWE will allow a 32-bit SQL Server to use more than 2-3 GB of RAM. If it's not a 32-bit installation of SQL Server, or the system doesn't have more RAM than that, then you don't need to enable it. |
|||
|
|
|
You might be interested in this blog which has detailed info regarding the issue. |
||||
|
|