4 votes

Whether to run integrity check before or after backups (Ola H FAQ)?

It really doesn't matter, either way, to be honest. If you run the backup first and then run the integrity check, you don't know if the backup is good - you know it ran. If you run the integrity check ...
Sean Gallardy's user avatar
4 votes
Accepted

IndexOptimize Question

probably not Ola already uses SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED in the queries that get run to gather data. Adding the outer SET statement will not do much of anything. Though there ...
Erik Darling's user avatar
  • 40.5k
3 votes
Accepted

Questions about the @DatabasesInParallel parameter for the Ola Hallengren Index and Statistics Maintenance scripts?

Solution If you want to perform Ola jobs in parallel, then you have to watch out for a couple of things. It's not very clear in the documentation. You need to download two additional scripts: Queue....
John K. N.'s user avatar
  • 17.6k
2 votes
Accepted

Ola Hallengren's Maintenance Solution script doesn't dump transactional log file to Destination

Kedar. First of all, to fix the discrepancy between @@SERVERNAME and its SERVERPROPERTY counterpart, please run the following script: https://github.com/MadeiraData/MadeiraToolbox/blob/master/Utility%...
Eitan Blumin's user avatar
2 votes

IndexOptimize procedure doesn't obey @MaxNumberOfPages when only updating statistics

Don't fall into the hole I did! The page count check does not take into account LOB data to calculate the number of pages the table is using. So, for example if in row data is under the @...
Tony Lucero's user avatar
2 votes
Accepted

What happens if you stop the IndexOptimize job, because it is running long and causing blocking?

As stated by others in comments, if an index has been optimized by the IndexOptimize job, then the locks occurring on that index will also come to an end. (Except of course new transactions holding ...
John K. N.'s user avatar
  • 17.6k
2 votes
Accepted

How to prevent backup messages to be printed

AFIK, there is no native solution to this but you could control that with following two options, Option 1: Redirect the step output to a text file (dynamic), with the following you will get a file ...
S.D.'s user avatar
  • 746
1 vote

Full Database Backup failing

General Ola Error Debugging The error message in your question looks like the job step error message. The full details are normally stored in a TXT file with the name similar to this: DatabaseBackup_&...
John K. N.'s user avatar
  • 17.6k
1 vote
Accepted

Should statistics be updated manually?

Automatic statistics maintenance is based on a formula (depending on which version of SQL Server you're on) that determines which sets of statistics will be updated when. Follow this link and scroll ...
Grant Fritchey's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible