Sam Haque
asked on
SQL cluster server memory utilization is very high.
How can we set up the SQL so that it will take certain amount of memory from the SQL server?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
allocating a split (50/50) OS to sql ....
OS usually needs only 2GB or so provided only sql is running on it, if there are other functions the system provide......
SQL will consume as much available memory as there is. The size of the database/s is what dictates ..
if the entire DB can be "loaded" into memory the proformance will be better compared to when the cummulative size of the active DBs are a large factor of available memory. This could potentially cause the system resources moving one data set out while responding to another query.....
If the change works for you, great..
OS usually needs only 2GB or so provided only sql is running on it, if there are other functions the system provide......
SQL will consume as much available memory as there is. The size of the database/s is what dictates ..
if the entire DB can be "loaded" into memory the proformance will be better compared to when the cummulative size of the active DBs are a large factor of available memory. This could potentially cause the system resources moving one data set out while responding to another query.....
If the change works for you, great..
ASKER