When running on Windows NT, the default is for SQL Server to attempt to keep free physical memory on the computer at 5 MB, plus or minus 200 KB (your example its within 148 KB). If you are experiencing a lot of paging and SQL isn't heavily utilised then consider specifying the max server memory server option. By default it will be set to dynamic allocation. Or buy some more memory - its cheap at the moment :)
From: Chuck Parkey <[EMAIL PROTECTED]> Reply-To: "MSWinNT Discussions" <[EMAIL PROTECTED]> To: "MSWinNT Discussions" <[EMAIL PROTECTED]> Subject: RE: Memory error? -NT4 SQL Server Date: Fri, 26 Oct 2001 12:05:46 -0700 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] _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp ------ You are subscribed as [email protected] Archives: http://www.swynk.com/sitesearch/search.asp To unsubscribe send a blank email to [EMAIL PROTECTED]
