你好!
请问当前SQL Server是x86还是x64, 请注意AWE只针对32位的机器产生作用:
You do not need AWE in 64-bit SQL Server; the awe enabled sp_configure option has no meaning
参考:
https://www.simple-talk.com/sql/database-administration/great-sql-server-debates-lock-pages-in-memory/
对于启用启用 AWE 内存的一些其他详细信息,请参考:
https://technet.microsoft.com/zh-cn/library/ms190673(v=sql.100).aspx
Best Regards,
Anna Wang
Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Support, contact tnmff@microsoft.com