SQL 2000 usually doesn't give it back, SQL 2005 will manage the memory better. If you are using SQL 2000, you should be setting your min and max memory settings to make sure the OS has 512MB to 1GB free always and make SQL trim its working set accordingly.
Z Edward E. Ziots Network Engineer Lifespan Organization Email: [email protected] Phone: 401-639-3505 MCSE, MCP+I, ME, CCA, Security +, Network + -----Original Message----- From: Chinnery, Paul [mailto:[email protected]] Sent: Tuesday, January 13, 2009 2:46 PM To: NT System Admin Issues Subject: RE: Memory usage SQL will do that. I've got SQL2K running on a 2 gig box and it's using about 1.6 gig.It's supposed to give it back, tho, if another process needs it. Paul Chinnery Network Administrator Memorial Medical Center 231-845-2319 -----Original Message----- From: Joe Heaton [mailto:[email protected]] Sent: Tuesday, January 13, 2009 2:27 PM To: NT System Admin Issues Subject: RE: Memory usage Task manager didn't help in this case. It ends up being SQL on that box, feasting on the RAM. Joe Heaton Employment Training Panel -----Original Message----- From: Terry Dickson [mailto:[email protected]] Sent: Tuesday, January 13, 2009 8:52 AM To: NT System Admin Issues Subject: RE: Memory usage 90% of the time I can track it down with just task manager. -----Original Message----- From: Jason Morris [mailto:[email protected]] Sent: Tuesday, January 13, 2009 10:48 AM To: NT System Admin Issues Subject: RE: Memory usage Process Explorer should give you that and much much more. From: Joe Heaton [mailto:[email protected]] Sent: Tuesday, January 13, 2009 10:45 AM To: NT System Admin Issues Subject: Memory usage How can I tell exactly what is using memory on a server? I have a server that is showing 95% + memory usage for the last week, and I'd like to find out exactly what application, or process is using this memory. Joe Heaton AISA Employment Training Panel 1100 J Street, 4th Floor Sacramento, CA 95814 (916) 327-5276 [email protected] ------------------------------------------------------------------------ ------------------ The pages accompanying this email transmission contain information from MJMC, Inc., which is confidential and/or privileged. The information is to be for the use of the individual or entity named on this cover sheet. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, distribution, or copying of this communication is strictly prohibited. If you received this transmission in error, please immediately notify us by telephone so that we can arrange for the retrieval of the original document. ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
