The only problem we had was that our SCSI tape driver could not handle the /3GB switch, which meant that our backups failed until we could find the problem and replace the driver.

Here is the code we used to enable AWE for SQL Server:

sp_configure ' show advanced options', 1

reconfigure

go

sp_configure 'awe enabled', 1

reconfigure

go

sp_configure 'max server memory', 7168

reconfigure

go

(Restart SQL Server)

Compaq Support told use to be aware that once awe is enabled, Task Manager no longer accurately reports the amount of memory used by SQL Server; you can determine the amount of memory used by SQL Server with the following query:

select cntr_value, cntr_type from sysperfinfo

      where

            object_name = 'SQLServer:Memory Manager' and

            counter_name = 'Total Server Memory (KB)'

You might want to watch the following "SQLServer:Buffer Manager" counters in Performance Monitor:

- AWE lookup maps/sec

- AWE stolen maps/sec

- AWE unmap calls/sec

- AWE unmap pages/sec

- AWE write maps/sec

- Buffer cache hit ratio

Jon