memory managment

• tony28

  SSCertifiable

  Points: 7112

  More actions

  April 5, 2014 at 7:06 am

  #284276

  I tried something during this day on test server then on production

  DBCC CLEANBUFFER AND FREEPROCACHE

  I saw that all db in buffer was removed and all ex.plan was removed also.

  I checked sys.view where is FreeMemory in KB and TotalMemory in KB...

  After executed these statements were almost same, it means memory was allocated, but almost all was free..

  I executed rebuild index and update statistics and all was ok.

  So totally was still 120GB and free was decrease according to reading index...

  But during rebuild in biggest table there was still 60GB free, but SQL did not use this free memory and did increase of total memory ...

  Can somebody explain this behaviour and why SQL server did not use this free memory ?

• Igor Micev

  SSC-Dedicated

  Points: 33109

  More actions

  April 5, 2014 at 2:58 pm

  #1703536

  Reading chapter 4 - Memory management of book http://www.sqlservercentral.com/articles/books/76296/

  will probably help you with wider scope of understanding some matters.

  Regards,

  Igor

  Igor Micev,My blog: www.igormicev.com