In EM right click on the server icon and goto properties Click on the Memory Tab and you will see 3 sliders for min and max memory. You want the second one down Slide it down to a value below the maximum and click on apply. You don't need to restart SQL or reboot. This takes effect straight away
HTH Jasper Smith From: Chuck Parkey <[EMAIL PROTECTED]> Reply-To: "MSWinNT Discussions" <[EMAIL PROTECTED]> To: "MSWinNT Discussions" <[EMAIL PROTECTED]> Subject: RE: Memory error? -NT4 SQL Server Date: Tue, 30 Oct 2001 09:45:47 -0800 The easiest place is Enterprise Manager. Do a search on 'memory, fixed amount' in the SQL Books on Line and it will tell you how. Chuck -----Original Message----- From: Robert J. VadeBonCoeur [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 30, 2001 9:40 AM To: MSWinNT Discussions Subject: RE: Memory error? -NT4 SQL Server Where can one specify the max server memory option? Thanks! > 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] ------ 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]
