I have a server with the following configuration and I need help to configure memory allocation on SQL Server 2005:
- Windows 2003 Server Standard Edition
- SQL Server 2005 Standard Edition]
- 4 Gb RAM
- This server will only work as a databse server. I have 2 others servers to the application.
I want to know what is the best configuration for maximum performance. How many memory I need to setup in minimum and maximum options and what about awe option.
Thanks in advance !