Friday, July 14, 2017

Memory setting recommendations for SQL Server 2016.




Physical RAM                           Maximum Server Memory Settings
2GB                                           1500
4GB                                           3200
6GB                                           4800
8GB                                           6400
12GB                                         10000
16GB                                         13500
24GB                                         21500
32GB                                         29000
48GB                                         44000
64GB                                         60000
72GB                                         68000
96GB                                         92000
128GB                                       124000

You should leave the minimum server settings at the default as changing this may cause performance problems.
Posted by at

1 comment:

  1. AdminFebruary 18, 2020 at 1:56 AM

    I think you did an awesome job explaining it. Sure beats having to research it on my own. Thanks
    Agra University BCom Time Table 2020
    Allahabad BCom Time Table 2020

    ReplyDelete

Subscribe to: Post Comments (Atom)