The page size in SQL Server is 8K because the SQL Server authors made it that way.
Some other database systems allow the DBA to specify the page size. There can be some situations where a 4K or even a 32K page size can be more efficient than an 8K page size, but we do not have that choice in SQL Server.
Just about all applications will perform very well on SQL Server. If you have a very large database (> 10 TB) or a very large number of concurrent users (> 1000) you should research which database system is best for your application - it may be SQL Server, but sometimes DB2, Oracle or Teradata may be the right choice.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara