SQL Server will take as much memory as it can unless you explicitly limit the amount it can use. It will give back some if it is needed elsewhere.
Is there a specific problem? Chuck -----Original Message----- From: Robert J. VadeBonCoeur [mailto:[EMAIL PROTECTED]] Sent: Friday, October 26, 2001 11:12 AM To: MSWinNT Discussions Subject: Memory error? -NT4 SQL Server (Ignore prior message, this one is correct message - sorry). Have a NT 4 Ent. (SP6A) SQL 7.0 Server (Cluster). I believe I have a memory leak, but not sure if it is a hardware problem, NT problem, or SQL problem. Server memory is being used up by SQL, and is paging it appears. SQL app just keeps using more and more memory. I think it is a SQL problem, but thought I would leave it with you guys for your opinion. Server has 1 GB RAM. Here is process information at time of problem. Image SQLSERVR.EXE, PID321, CPU00, MEM USAGE 965016 (That is alot of memory just for SQLSERVER APP!-I know we are not using it that much. Size never decreases, just gets bigger over time!). Physical Memory (k) Total 1037952 Available 4972 File Cache 13292 Kernal Memory (k) Total 20620 Paged 12580 Non 8040. ------ You are subscribed as [EMAIL PROTECTED] Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe send a blank email to [EMAIL PROTECTED] ------ You are subscribed as [email protected] Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe send a blank email to [EMAIL PROTECTED]
