Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2005
    Posts
    25

    Unanswered: High usage of RAM on SQL2k

    Hi

    I have an sql server with very high usage. The web which is connected to the sql server has approx. 1000 unique visitors every time.
    The database is optimized and the site goes really fast now.

    But a problem we've had since the beginning is that SQL Server constantly uses 1.8 GB of RAM. Never less, never more.

    Do you have any idea on how to decrease the usage of RAM. I am sure that this high usage is necessary.

  2. #2
    Join Date
    Mar 2003
    Location
    Reading, UK
    Posts
    70
    check your logs,if they are more truncate them,
    may be it helps you.

  3. #3
    Join Date
    Jul 2005
    Posts
    25
    But arent the log files truncated during the backup?

  4. #4
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    Logs?

    run sp_configure and tell me what the results are for min server memory.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  5. #5
    Join Date
    Jul 2005
    Posts
    25
    min server memory (MB) 0 2147483647 0 0

Posting Permissions

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