I recently installed a new server for a client to replace their old SQL server. It's a huge improvement as it's not crashing anymore but users have complained about slowness. This server is Windows 2008 Standard 64Bit SP1. It originally had 4GB of RAM. The memory was always maxed out in task manager so we installed an additional 4GB for a total of 8GB of RAM. They are using SQL 2005.
In task manager, The physical Memory usage is always maxed out. This is true even at night when no one is using the server. I've read numerous articles on paging file size and thought I'd ask if anyone has encountered or has recommemdations for this issue. Currently, the virtual memory is set to "Automatically manage paging file size for all drives". Any thoughts or suggestions would be greatly appreciated.