Post reply

Server memory question

  • August 21, 2023 at 4:06 pm

    #4267304

    I would like to know please how much memory I should add to my server

    here is what I have 51452 in MB and we be adding more data and databases,please recond how better to maintain

  • August 21, 2023 at 5:42 pm

    #4267364

    Not enough info provided for us to be able to say.  (1) Is SQL indicating that it's short of memory?  (2) How large are  your databases? (3) How many simultaneous users do you typically have? (4) etc.

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.

  • August 22, 2023 at 9:52 am

    #4267946

    Is the server currently waiting on memory?

    https://erikdarlingdata.com/signs-you-need-more-memory-in-your-sql-server/

    https://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/

  • August 22, 2023 at 2:48 pm

    #4268211

    (1) Is SQL indicating that it's short of memory?

    No(2) How large are  your databases?

    806315 MB total size for all databases

    (3) How many simultaneous users do you typically have? over 2000

     

    Thank you

  • August 22, 2023 at 2:53 pm

    #4268215

    RAM doesn't look too short there, but personally I'd add more if you could.  RAM is the cheapest overall performance boost you can get.  And bump up tempdb size if you do a lot of sorting or other big queries that would use a lot of tempdb.

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply