0

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

RPS
  • 3
  • 3

2 Answers2

0

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.

db2
  • 2,180
  • 3
  • 15
  • 19
0

You might be interested in this blog which has detailed info regarding the issue.

DaniSQL
  • 1,107
  • 7
  • 12