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,
ManolisSQL Server is designed to take up as much memory as it needs. See the article titled "Server Memory Options" in BOL.|||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:SELECT ServerProperty('ProductLevel')-PatP|||Link http://www.sqljunkies.com/Article/7F8518F9-FDAA-4FF3-8FC5-25E8946C8D0C.scuk to investigate & resolve the performance issues.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment