5.31.2013

SQL Server Performance


For SQL Server Box:
1) Configure AV to ignore several key folders and files. Such own AV folder, SQL folders, SQL files, c:\pagefile.sys
2) Change power management option from balanced to performance.
3) Do not use SQL Boost.
4) Put SQL data files on separate drive.
5) Put SQL log files on separate drive, if possible.
6) Use simple database unless full logging is required.