1. Do not keep data or log files on the drive where OS is installed.
2. Keep the data file (.mdf and .ndf) and log file in seperate drive.
3. Keep the growth size of both data and log file in megabytes not in percent.
4. Set the maximum file size growth don't set is as unrestricted file growth.
5. Create a secondary filegroup and make it as default.
6. Create a secondary file (.ndf) to store the data
7. It is recommended to create (.ndf) one new file for each module.
8. Set the recovery model as full (prod env).
9. Set the Auto update statistics = True.
10. Set the page verify = CHECKSUM
No comments:
Post a Comment