tag:blogger.com,1999:blog-2530682427657016426.post2767683774686051416..comments2024-03-28T08:29:25.033+01:00Comments on Marko Sutic's Database Blog: Troubleshooting memory usageMarko Sutichttp://www.blogger.com/profile/08926232581329666732noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-2530682427657016426.post-21109952260233576972012-07-20T21:59:13.232+02:002012-07-20T21:59:13.232+02:00Damir: you would be surprised, if I tell you how m...Damir: you would be surprised, if I tell you how many small production databases we have - many of them using 4 GB RAM :)<br />If you have a small, not frequently changed database, then 4 GB RAM is really enough - more then that would be only the wastage of unused ressources.<br />It's ok when you have a couple of databases, but if you have to manage 200+ database like we, then you should take care about every single ressource, because the IT budget is not unlimited, especially if you are using some expensive storage boxes or IBM boxes. :)Dejan Topalovichttp://www.baze-podataka.netnoreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-46052474246045924612012-01-23T10:31:13.851+01:002012-01-23T10:31:13.851+01:00You are correct, 4GB is not much but it is more th...You are correct, 4GB is not much but it is more than enough for our db server in this case.<br /><br />Maybe we could solve our issues with adding more RAM, but in this post I tried to point that removing custom vm.* parameters solved our performance problems.<br /><br />Now server is pretty underused :)Marko Sutichttps://www.blogger.com/profile/08926232581329666732noreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-23444896745860913162012-01-22T13:54:23.378+01:002012-01-22T13:54:23.378+01:00When I mentioned laptop I thought on RAM power ......When I mentioned laptop I thought on RAM power ... which was cause problem of the topic ...<br /><br />And 4G are lower standard for today's laptops.<br />:-)Damir Vadashttps://www.blogger.com/profile/15963017378937428976noreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-85614804670242930302012-01-10T18:35:34.777+01:002012-01-10T18:35:34.777+01:00This server is powerful enough to host production ...This server is powerful enough to host production database for many small businesses (at least in Croatia) :)<br /><br />We're planing migration for this databases and then this server will become my dev/testing machine.<br />Add some RAM and you have decent server for various purposes.<br /><br />p.s.<br />I would be very happy to have laptop strong as this machine :DMarko Sutichttps://www.blogger.com/profile/08926232581329666732noreply@blogger.comtag:blogger.com,1999:blog-2530682427657016426.post-74251129549254266362012-01-10T17:18:42.221+01:002012-01-10T17:18:42.221+01:002 DB on same server with 4 GB of RAM and called PR...2 DB on same server with 4 GB of RAM and called PRODUCTION?<br /><br />Common, today basic laptops has that ... <br /><br />:-)Damir Vadashttps://www.blogger.com/profile/15963017378937428976noreply@blogger.com