SQL Server Performance

min/max memory setting multiple instances

Discussion in 'SQL Server Clustering' started by jsciii, Jun 20, 2007.

  1. jsciii New Member

    I have a cluster with 15 instances. None have had the min/max memory set. Should it? I was watching the memory usage and saw where one very active instance had grabbed nearly a quarter of all the available ram.

    Thanks...JC III
  2. satya Moderator

    What is the availble physicial memory on this server?
    What is the operating system?

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  3. jsciii New Member

    There is 4gb RAM and 2 processors. THe OS is Win 2003 server SP1.

    THanks

Share This Page