Server memory question
-
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
-
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) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
-
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/
-
(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
-
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) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply