Share via

Sql server 2019

Ravi Shah 1 Reputation point
2020-08-27T19:16:48.993+00:00

Wanted to migrate SQL 2012 databse of size 60 gb to SQL server 2019

Wanted to know what is the memory required for 60gb database .db server is standalone.

As there are more than 20000 users will acces the application daily basis.

Db Server is on premise

Developer technologies Transact-SQL
SQL Server Other

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator
    2020-08-27T21:24:34.963+00:00

    The memory consumption should be more or less the same as today. Then again, if there are plan regressions that starts to scan big tables, more pages may be brought into memory. If the case would be that is, that most of the data just sits on the disk and is never accessed as such.

    Or more to the point: with knowledge of your workload, the question is not possible to answer. But if you cram in 64 GB of RAM into the server, most of the database will into memory entirely.

    1 person found this answer helpful.
    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.