CT08
asked on
SQL Ram maximum limit
Is there a way I can stop the SQL memory settings going back to the default settings after a reboot of the server. We only have a small sql database and want to allocate 512Mb only and we set this all ok but after a reboot this changes back to the default.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
what version of sql are you using?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Version : Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86)
I have tried setting maximum memory both by SQL query and by:
1. Select properties from the menu
2. Select memory from the options on the left-hand side.
3. Enter the values for minimum and maximum server memory in MB.
4. Click OK to confirm changes.
Both of these save the setting until a server reboot
I have tried setting maximum memory both by SQL query and by:
1. Select properties from the menu
2. Select memory from the options on the left-hand side.
3. Enter the values for minimum and maximum server memory in MB.
4. Click OK to confirm changes.
Both of these save the setting until a server reboot
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
All of the above options we correct in setting RAM size limits but I have since found out that a third party piece of software was resetting this on a system reboot via an XML configuration file. It was setting maximum SQL RAM size to 45% of physical memory.
Thanks for all the comments and help
Thanks for all the comments and help
ASKER