To use more than 4GB:
SQL 2005 32 Bit
1. Add /PAE to boot.ini
2. Configure lock pages in memory, in group policy , computer configuration
expand window settings, expand security settting, local policies, user right assignments,
click lock pages in memory , add sql account that starts up sql.
3 In sql 2005 memory settings tick flag use AWE.
In error log see SET AWE enabled to 1 in configuration parameter to allow use of more memory.
(Do not see anything in lock pages in memory and only have 4GB so not sure
if message should be coming out).
SQL 2005 64 Bit
1. No ini files to set
2. configure lock pages in memory, in group policy , computer configuration expand window settings,
expand security settting, local policies, user right assignments, click lock pages in memory , add
sql account that starts up sql
3. Do not set the awe flag in sql.
Error Log see message "lock page in memory" not sure of exact message not got 64 bit machine yet.