I recently installed SQL 2005 on Windows 2003 server (64 bit). We have 32 GB of physical RAM. In SSMS here are the current settings: (These were the default values.)
Use AWE to allocate memory = NOT CHECKED
Minimum Server Memory = 0
Maximum Server Memory = 2147483647
When I look at the taskmgr in Windows, it consistently shows sqlservr.exe taking almost all 32 GB of memory (even when CPU is low and there's nothing really being done in SQL). Is this normal? Input would be appreciated. Thanks!