A SQL server database, has more than 10K tables. Current size is about 800G,
after data compression. ETL process happens every night. Most of them get
updated data daily, some of them get updated data weekly, and the rest get
updated data monthly. The current maintenance plan is like this:
1. Sunday - Thursday, differential backup, including data integrity check.
2. Friday, rebuild index. As of last Friday, it took 18 hours to finish
3. Saturday, full database backup, including data integrity check and update
statistics - column only. As of last Saturday, it took 24 hours to finish:
5 hours data integrity check, 15 hours update statistics, and 4 hours full
database backup.
Is there a way I can improve the plan performance?
Thanks in advance.