A few best practices are given below to configure SQL Server on a newly built server:
1. Choose correct hardware:- Assuming the correct hardware specification has been selected as per user requirement & estimated load on the server.
2. Sufficient Memory:- We should allocate sufficient memory to the server as well as SQL Server to provide better performance.
As per best practice, allocate :
10-20% of total physical memory as min. memory to SQL Server,
75-80% of total physical memory as min. memory to SQL Server.
Left at least 20% for OS & other processes.
