Results 1 to 6 of 6

Thread: mssql mem usage

  1. #1
    Join Date
    Dec 2004
    Posts
    2

    Exclamation Unanswered: mssql mem usage

    running mssql server 2000. experiencing extremely high mem usage - 420 000 k. Can anyone help me determine what on earth is happening? Urgent.

    Appreciate any help.

    tq.

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    420MB of RAM used is no where near of being "too high". What's the total physical memory? If you have memory shortage you should set the max for SQL service (in fact you should always set the max value)
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Most of my machines run well over 2 Gb for SQL Server... 420 Mb would be heavy on a workstation (Personal Edition), but wouldn't be enough to start most of our servers.

    -PatP

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    420MB would be heavy on a workstation? What does it have to do with a workstation? Are you running prod environment off of it? Personal edition is for development and for occasional "select * from authors" when arguing with dbForums' bunch trying to prove the point
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  5. #5
    Join Date
    Dec 2004
    Posts
    2

    details

    this is an prod environment. machine total physical memory is 523760. sqlserver.exe is using 375 000 to 420 000 k. It has been running for a year with no problems. until now...what would be the optimal value to set the max for sql?

  6. #6
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    First, add MORE memory, at least 512MB more. With 1GB of physical memory you can set the minimum for SQL at 800MB. Since it started consuming more memory it's an indicator that some optimization needs to be performed since your volume of data increased.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •