Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Swordfish83
Starting Member
5 Posts |
 Posted - 2013-08-13 : 15:02:23
|
| I change the AWE configuration (SQL 2008) with this script:sp_configure 'show advanced options', 1RECONFIGUREGOsp_configure 'awe enabled', 1RECONFIGUREGOsp_configure 'max server memory', 5120RECONFIGUREGOBut i check Facets View->Server Configuration->AweEnabled and i have this value:"value of property aweenabled is not in a committed state".I reboot the server many times but i have the same message.Any suggestion? |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2013-08-16 : 19:31:08
|
| Are you in a 64-bit environment? If so, AWE Enabled is a no-op.=================================================The cure for anything is salt water -- sweat, tears, or the sea. -Isak Dinesen |
 |
|
|
Swordfish83
Starting Member
5 Posts |
Posted - 2013-09-04 : 11:45:28
|
| mmmmmmm is strange, i test on Windows 7 x64 and SQL R2 x64 and works, i go test on Server 2008 R2 x64 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
AWE Configuration