Schedule suggestion and index rebuild / database integrity progress for Ola Hallengren’s Maintenance Script

0 votes

2 answers

677 views

                          I have to configure Ola Hallengren's Maintenance Scripts for my SQL Server 2017. SQL Database size about total 400GB.Total 10 Dbs. But I have some questions.

1- I will use these schedules like below. What is the best practices for this ? or What do you recommended?

    DatabaseBackup – SYSTEM_DATABASES – FULL job – Daily at 12:05AM
    DatabaseIntegrityCheck – SYSTEM_DATABASES job – Daily at 12:10AM
    IndexOptimize – USER_DATABASES job – Daily at 1:00AM

2-  How can I check the progress / status when index optimize  and databasSee integrity job ?

Asked by Cell-o (1106 rep)

Mar 26, 2021, 12:04 PM
Last activity: Feb 7, 2025, 11:04 AM

Schedule suggestion and index rebuild / database integrity progress for Ola Hallengren’s Maintenance Script

Related Questions