#sqlserver
SQL server configuration and server side fine tuning
Min server memory
Max server memory
MDOP - Max Degree of parallelism
Cost threesold for parallelism
optimize for adhoc queries
Remote login timeout
remote query time out
Agent Xps
Backup compression
DB mail xp
Network packet
OS
Lock pages in memory
Performance volume maintenance
Admin privilege
#sqlserver #dba #performance Tuning & Optimization