10 Configurations Best Practices

The first checklist before start using any application using SQL Server should be the default configurations. What configurations I used to change? Max Server Memory: SQL Server will grab all memory available and that will cause concurrency with the OS MAXDOP: for OLTP also yes, the good thing is to use it Cost Threshold for … Continue reading 10 Configurations Best Practices