Is Memory really dynamic?

• RandyB

  SSCommitted

  Points: 1565

  More actions

  January 27, 2004 at 1:12 pm

  #85442

  SQL7 - WinNt

  I run a monitoring program named Spotlight and have been getting alot of paging alerts. The process doing all of the paging is a Windows process and not SQL.

  Here's the problem.

  SQL is constantly holding 1.7GB out of an available 2.25GB of memory. It isn't sharing any with the server for anything else.

  The properties show that the memory for sql is dynamically allocated from 0 - 2303MB. I have looked at this in EM server properties and sp_configure.

  Any insights on why sql is always holding the 1.7GB of memory?

   

  Thanks for any help.

  Randy

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  January 27, 2004 at 1:20 pm

  #491818

  SQL Server will not release the memory it has already allocated until other processes ask for memory.

  Which Windows process does the paging?

• RandyB

  SSCommitted

  Points: 1565

  More actions

  January 28, 2004 at 5:58 am

  #491925

  The process is WINLOGON and seems to indicate any data copying or transferring outside of sql.