SQL Server 'Max' Options

Some of the Major SQL Server's 'Max' options/configurations.

- Max Worker Threads
https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-max-worker-threads-server-configuration-option?view=sql-server-ver16

- Max Server Memory Settings
https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/server-memory-server-configuration-options?view=sql-server-ver16

- MaxDOP (Degree of Parallelism)
https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-max-degree-of-parallelism-server-configuration-option?view=sql-server-ver16

- Max number of concurrent connections
https://learn.microsoft.com/en-us/answers/questions/1008380/maximum-number-of-concurrent-connections.html


Best Regards

Amit Vaid