title: SQL Server slow down issue, occupies more than allocated memory. Possible Leak
body: <p>Using SQL Server 2012 64 bit (v11.0.6020.0)</p>
  
  <p>Below is the scenario:</p>
  
  <p>On our production we have 32 GB DDR3 RAM installed:</p>
  
  <p><a href="https://i.stack.imgur.com/UsETL.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/UsETL.png" alt="enter image description here"></a></p>
  
  <p>Maximum memory limit has been set in SQL server to 16 GB ie 50% capacity:</p>
  
  <p><a href="https://i.stack.imgur.com/cvjfu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/cvjfu.png" alt="enter image description here"></a></p>
  
  <p>When I fire up task manager and check memory occupied in Value it shows 16 GB which is correct:</p>
  
  <p><a href="https://i.stack.imgur.com/oqMdF.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/oqMdF.png" alt="enter image description here"></a></p>
  
  <p>But when I select memory occupied by Percentage, it shows 80%-85% which is NOT RIGHT:</p>
  
  <p><a href="https://i.stack.imgur.com/GcPRP.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/GcPRP.png" alt="enter image description here"></a></p>
  
  <p>This will keep on Increasing, until it occupies more than 95% and the </p>
  
  <ol>
  <li>entire system will slow down</li>
  <li>Queries will time out</li>
  </ol>
  
  <p>The only way to correct this is a server restart</p>
  
  <p>My questions are</p>
  
  <ol>
  <li>Is SQL Server leaking memory?</li>
  <li>Any quick fix so I don't have to restart?</li>
  <li>Permanent resolution?</li>
  </ol>