Hi all just completed a migration to SQL 2016. The server hosts a handful of databases for a small company. The largest database being 13 Gig in size. The business is primarily Monday to Friday 8-5 for database usage. I know maintenance plans are different for every environment. I would just like to know if what I am doing is enough. And often enough. I am confident in my backup plan but not the maintenance.
I am running a single maintenance plans as follows once a week after hours.
Check Database Integrity on all user databases default settings
Rebuild Indexes on all user databases default settings
Update Statistics on all user databases default settings
Thanks in advance
ASKER