SQL Standard Maintenance plan .. small business applications
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