In the company of the server 1C Enterprise 22.214.171.124 used MSSQL Server 2008 R2 SP3. Bases quite a lot — from Document management, finishing Shots.
Both servers (1C Enterprise and MSSQL) are on the same physical server.
The problem is that in 1-2 full business days MSSQL server "eats" all allocated memory. A feeling, a memory leak occurs.
Here's what shows task Manager:
The server has 64Gb RAM. Windows Server 2008 R2 Enterprise.
The maximum amount of memory to MSSQL put in 38Gb:
The properties of the server cluster 1C:
Users of 1C: Enterprise is about 95. Among them there are many those who work via a terminal.
What to do? How to prevent the leak? Help with the Council. Thank you.