Thursday, March 14, 2013 9:16 AM
I have 2 cluster server for sql r2 64 bit.
this server is using max memory (8Gb) but when i restart the sql server memory comes down at 2.5Gb but after 12 hr. it again go at max.
Thursday, March 14, 2013 9:18 AMIt is by design. SQL Server allocates memory as much as it needs (till MAX memory param)
Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/
MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
- Proposed As Answer by Sean GallardyMicrosoft Community Contributor, Editor Thursday, March 14, 2013 5:18 PM
- Marked As Answer by Maggie LuoMicrosoft Contingent Staff, Moderator Sunday, March 24, 2013 2:14 PM
Thursday, March 14, 2013 9:19 PM
SQL Server using as much as memory if you are not set Max memory at SQL Server level, and it will not release until unless OS need memory.
To avoid High memory usage, set max memory to SQL Server.
For setting max memory use following command:
sp_configure 'max server memory', <memory value in MBs>;
Friday, March 15, 2013 8:41 AM
it is ok
why is not releasing memory when it is not in use
max memory is used by sqlservr.exe not by system.
Wednesday, March 20, 2013 4:38 PM
That is the come behavior of SQL Server, Until some other service requires memory SQL server won't released.