We help IT Professionals succeed at work.

SQL Standard Maintenance plan .. small business applications

Zoldy2000
Zoldy2000 asked
on
43 Views
Last Modified: 2018-03-21
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
Comment
Watch Question

ste5anSenior Developer
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
To clarify you are suggesting I run reorg and update statistics daily instead?   Then run the rebuild once on the weekend on its own?     Can you explain what configuring those alerts does for me.
Senior Developer
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
thank you
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.