Avatar of Zoldy2000
Zoldy2000Flag for Canada

asked on 

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

Thanks in advance
DatabasesSQL

Avatar of undefined
Last Comment
Zoldy2000
SOLUTION
Avatar of ste5an
ste5an
Flag of Germany image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Zoldy2000
Zoldy2000
Flag of Canada image

ASKER

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.
ASKER CERTIFIED SOLUTION
Avatar of ste5an
ste5an
Flag of Germany image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of Zoldy2000
Zoldy2000
Flag of Canada image

ASKER

thank you
Databases
Databases

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

62K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo