Results 1 to 4 of 4
  1. #1
    Join Date
    May 2004
    Posts
    34

    Unanswered: MSSQL 2000 memory leaks

    Hi,
    I have one application in two different companies with MSSQL2000 running on Windows2000 Server and Windows2003 Server.
    It seems that memory needed for MSSQL2000 as displayed in task manager is increased every day.
    Does anybody knows anything regarding memory leaks in MSSQL2000?

    How can I find what version of service pack have I installed in a MSSQL2000 server machine?

    Regards,
    Manolis

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    SQL Server is designed to take up as much memory as it needs. See the article titled "Server Memory Options" in BOL.

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    SQL 2000 is sensistive to "Memory Pressure" where other applications request memory from the host operating system. As other apps request more memory, SQL 2000 will free up some of the memory that it is using. In general though, SQL 2000 will tend to "camp" on memory until it percieves pressure from other applications, so it has a reputation as a "memory hog" that I don't feel is justified.

    To find your present patch level, execute:
    Code:
    SELECT ServerProperty('ProductLevel')
    -PatP

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Link http://www.sqljunkies.com/Article/7F...8946C8D0C.scuk to investigate & resolve the performance issues.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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