locked
three websites, three databases for RAM RRS feed

  • Question

  • User1069198773 posted

    Hi. I'm using three databases for three websites now. Can I save memory, if I will use only one database for three websites? 

    Wednesday, June 15, 2016 7:41 PM

Answers

  • User-821857111 posted

    No. SQL Server by default is configured to take as much RAM as it wants (to all practical intents and purposes). If you find that it is hogging RAM at the expense of other operations, you can alter the configuration: https://msdn.microsoft.com/en-us/library/ms178067.aspx

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, June 16, 2016 7:49 AM

All replies

  • User-821857111 posted

    No. SQL Server by default is configured to take as much RAM as it wants (to all practical intents and purposes). If you find that it is hogging RAM at the expense of other operations, you can alter the configuration: https://msdn.microsoft.com/en-us/library/ms178067.aspx

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, June 16, 2016 7:49 AM
  • User1069198773 posted

    Mikesdotnetting

    I have only 4Gbyte RAM. First day sql server took only 100mbyte. Next day 200Mbyte, after a week I see that it's taking 1Gbyte. If I do not configure sql server, my server will work slowly in a couple of weeks? 

    Friday, June 17, 2016 3:33 PM
  • User-166373564 posted

    Hi,

    I have only 4Gbyte RAM. First day sql server took only 100mbyte. Next day 200Mbyte, after a week I see that it's taking 1Gbyte. If I do not configure sql server, my server will work slowly in a couple of weeks? 

    This might help you:

    SQL Server caches memory to store as much data and index pages(in memory)  as possible to avoid any physical I/O which is costly and once taken memory it will not release unless SQLOS asks it to do so . It will start trimming its memory consumption when  SQLOS says it to do because of some memory pressure or other requirement.

    More about SQL Server memory and troubleshooting

    http://social.technet.microsoft.com/wiki/contents/articles/22316.sql-server-memory-and-troubleshooting.aspx

    Regards,

    Angie

    Saturday, June 18, 2016 3:18 AM
  • User-821857111 posted

    If I do not configure sql server, my server will work slowly in a couple of weeks? 
    Not necessarily. As I said. SQL Server will use as much memory as it can get hold of, but other process will be able to claim that memory back.

    Sunday, June 19, 2016 6:56 PM