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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,166 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,589 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 104.8K Reputation points MVP
    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