sql server - Is AWE in SQL 2005 Ent needed on 2003 32-bit w/ 24GB? -


I have a WS 2003 32-bit system that is running with SQL Server 2005 Enterprise 24 GB RAM. / PAE switch enabled Is SQL now able to use 24 GB or need to enable AVE?

You have to enable AWE and the SQL Server service account will have to give "lock page lock" privilege .

Useful Reading:

Consult books online documents for more concise steps:

Hope this is helpful but let me know if you have more questions Are there.


Comments

Popular posts from this blog

windows - Heroku throws SQLITE3 Read only exception -

lex - Building a lexical Analyzer in Java -

python - rename keys in a dictionary -