high memory uses and

Question

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.

---

Regards, CP

Answer 1

It 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

Answer 2

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>;
GO
RECONFIGURE;
GO

sriram

Answer 3

it is ok

why is not releasing memory when it is not in use

max memory is used by sqlservr.exe not by system.

regards

Chhatrapal

---

Regards, CP

Answer 4

That is the come behavior of SQL Server, Until some other service requires memory SQL server won't released.

Sriram