I am having a look at SQL server parameters which I can tune to optimize database and not having much luck.
When I execute
SELECT * FROM sys.configurations
ORDER BY name ;
I see list of 70 parameters but is that all we have?
Which config parameters one should look at for configuring a production server of database 150GB and between 250-500 concurrent connections?