Capture.PNG

<div>
To clarify you are suggesting I run reorg and update statistics daily instead? &nbsp; Then run the rebuild once on the weekend on its own? &nbsp; &nbsp; Can you explain what configuring those alerts does for me.
</div>


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.

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


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

SQL Standard Maintenance plan .. small business applications

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.

Databases

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.