 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server / July 2008memory usage exceeding max memory setting
2 instances SQL2005, 1 instance SQL2000. We have set the max memory to 500MB on the SQL2005 and 512MB on the SQL2000. the SQL 2000 maintains between 480MB and 500MB, but the memory keeps creeping up daily past the 500MB Max setting on the SQL 2005 . Currently the Memory is 575MB and 573MB. Max Memory only affects the amount of memory SQL Server uses for the buffer pool. By default an instance of SQL Server reserves some memory on start up that is on top of the MAX Memory setting. With 2000 it defaulted to ~384MB for the MemToLeave area which is NOT included in the buffer pool. So if you want to keep it under 500MB you will need to set the Max Memory lower than 500MB. 500MB is not a lot of memory for SQL Server these days, why are you limiting it?  SignatureAndrew J. Kelly SQL MVP Solid Quality Mentors >2 instances SQL2005, 1 instance SQL2000. > We have set the max memory to 500MB on the SQL2005 and 512MB on the [quoted text clipped - 4 lines] > is > 575MB and 573MB. we have 4 instances on the server along with other items running on the box. > Max Memory only affects the amount of memory SQL Server uses for the buffer > pool. By default an instance of SQL Server reserves some memory on start up [quoted text clipped - 12 lines] > > is > > 575MB and 573MB. Well I hope you aren't concerned with performance then :). As long as these databases are small and not heavily used you may be able to get away with that. But SQL Server loves memory and it doesn't like other apps playing on its server either :). SignatureAndrew J. Kelly SQL MVP Solid Quality Mentors > we have 4 instances on the server along with other items running on the > box. [quoted text clipped - 22 lines] >> > is >> > 575MB and 573MB. Just curious what the justification is for 4 instances. As Andrew points out, that can cause significant performance issues. SignatureKevin G. Boles Indicium Resources, Inc. SQL Server MVP kgboles a earthlink dt net > we have 4 instances on the server along with other items running on the > box. [quoted text clipped - 22 lines] >> > is >> > 575MB and 573MB. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.