Multi Instances - Using unused memory of stopped instance

• sivaprasad

  SSCertifiable

  Points: 6183

  More actions

  July 15, 2004 at 5:50 am

  #85854

  Scanario, wherein SQL Server multi instances are running in a box with 8 GB RAM and Quad processor 1.5 Ghz. Each instances set with maximum memory. In that case if one instance stoped and not used, How to make it, that other instances to share the memory ?

  Sivaprasad S - [ SIVA ][/url]http://sivasql.blogspot.com/[/url]

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  July 15, 2004 at 7:47 am

  #514655

  If SQL Server is configured to use memory dynamically, It will allocate memeory when it needs, if there is available memory for allocation.