I have inherited a cluster that has several instances of SQL Server 2005. THE OS is 64 bit and the problem I am having is that there is 10GB of memory and when I look in Task Manager and order by memory at the top is
sqlserver.exe 5,931,512 KB
sqlserver.exe 2,771,548 KB
sqlserver.exe 286,036 KB
Total 8,989,096 KB
Now I want to even this out a little as obviously one of the SQL server instances is throttling the others. My instincts tell me the one that is using the most memory is a database that is not key to the users and as such I would be happy to reign in its memory usage.
Now when I look on the memory tab of the properties for the instance there is an option to enable AWE. There are Minimum and Maximum settings in MB for server memory. Can I use this in any way to control the memory that is used.
I thought I could but all the articles that I find seem to lead me to believe that AWE only works for 32 bit - is this true?
Can I still uise these memory settings to control memory usage?
Do I need to restart the server or service for this to take affect.