August 21, 2023 at 4:06 pm
August 21, 2023 at 5:42 pm
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
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
(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
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