Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Hariarul
Posting Yak Master
160 Posts |
 Posted - 2007-02-13 : 06:32:02
|
| Hi all, This would be a simple question related to the memory configuration for SQL Server 2005.The production server has nearly 3.50 GB RAM with 4 processors on which our SQL Server 2005 is running.Will configuring the below parameters is good or leaving the default values would be better?AWE to allocated memory Minimum server memory Maximum server memoryIndex creation memory Minimum memory per queryIf configuring them is better , what could be the ideal parameters ?Any help would be appriciated.Thanks , HHA. |
|
|
|
|
|
SQL Server Memory Configuration.