Reset SQL Memory without restart...

• Ray Laubert

  SSCrazy

  Points: 2910

  More actions

  April 7, 2010 at 8:53 am

  #142440

  I know SQL will take all the memory the box will give it. It also gives it back when Windows needs it.

  What I would like to do is force SQL to return the memory periodically. More for monitoring when the SQL thinks it needs more memory.

  Sp_configure is not what I am looking for. SQL will still be able to 'use' all the memory on the box (except 1 GB or OS), I just want to force the return of what it is not currently required.

  Anyone know of an ONLINE way to do this that does not require rebooting, restarting or otherwise making SQL unavailable?

  Thanks

  Raymond Laubert
  Exceptional DBA of 2009 Finalist
  MCT, MCDBA, MCITP:SQL 2005 Admin,
  MCSE, OCP:10g

• MVDBA (Mike Vessey)

  SSC-Insane

  Points: 21797

  More actions

  April 7, 2010 at 9:13 am

  #1147424

  ray

  have you tried

  DBCC DROPCLEANBUFFERS

  GO

  DBCC FREEPROCCACHE

  GO

  if you are using dynamic memory that might free it up - not sure if it just clears the memory or it clears it and SQL will release it

  or have i missunderstood the question

  MVDBA