The below are the few points need to be consider to follow the best practices .
5. Install all the features and stop the services for the features which are not needed such as Reporting Services , Analysis Services , Notification services etc hence It will save time to reinstall the required features again .
1. Dedicate separate physical server to run only single instance of SQL Server and don't install any other applications .
2. For best performance turn off any operating system services that aren't needed .
3. Do not install SQL Server on a domain controller .
4. Don't use NTFS data file encryption and compression on SQL Server database and log files .
5. Install all the features and stop the services for the features which are not needed such as Reporting Services , Analysis Services , Notification services etc hence It will save time to reinstall the required features again .
6. For best I/O performance , locate the data files (.mdf) and log files (.ldf) on separate arrays on your server to avoid conflicts between reads and writes .
( mdf file is recommended to be on RAID 5 , ldf is recommended to be on RAID 10 )
7. If temp db used heavily then put it on its own separate array .
No comments:
Post a Comment