Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [ola-hallengren-scripts]

Refers to the set of SQL Server Management Scripts created and maintained by Ola Hallengren. Questions tagged with this tag should be about how to use the scripts or about how to resolve an issue with the script.

Ola Hallengren's scripts can be downloaded from his site at https://ola.hallengren.com/

From his site:

The SQL Server Maintenance Solution comprises scripts for running backups, integrity checks, and index and statistics maintenance on all editions of Microsoft SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, and SQL Server 2014. The solution is based on stored procedures, the sqlcmd utility, and SQL Server Agent jobs. I designed the solution for the most mission-critical environments, and it is used in many organizations around the world.

275 questions
15
votes
3 answers

Transaction Log Backups Serial or Parallel?

We happen to be using SQL Server 2012 Standard Edition. I also happen to use Ola Hallengren's scripts to provide an easy, more flexible framework for doing backups and maintenance. This question isn't so much about Ola's scripts as they are about a…
Chris Aldrich
  • 4,916
  • 5
  • 34
  • 55
13
votes
3 answers

Queries and updates extremely slow after IndexOptimize

Database SQL Server 2017 Enterprise CU16 14.0.3076.1 We recently tried switching from the default Index Rebuild maintenance jobs to the Ola Hallengren IndexOptimize. The default Index Rebuild jobs had been running for a couple of months without…
Martin Bergström
  • 133
  • 6
13
votes
3 answers

Understanding CleanupTime in Ola Hallengren's SQL Server scripts in relation to FULL backups and LOG backups

I am having trouble understanding what exactly to expect from the CleanupTime option in the Ola Hallengren Server Maintenance Solution. I'm finding some related questions, and elaborate answers, but the explanations still puzzle me a…
Wouter
  • 833
  • 2
  • 10
  • 22
11
votes
4 answers

Alternatives to Network Backup

In our environment we have some servers that are in an Always On Availability Group, and some that are standalone. We normally backup to a network share, but we have recently observed that as the databases are growing bigger the time taken is…
SQL_NoExpert
  • 1,107
  • 1
  • 21
  • 37
11
votes
5 answers

What are pros and cons of Ola’s scripts vs using maintenance plan?

Will you please help me understand pros and cons of using Ola’s solution over maintenance plan? I have prepared a presentation based on SQL Pass (http://www.pass.org/DownloadFile.aspx?File=ebae1b31) which I will present. I am also preparing few…
Pat
  • 357
  • 1
  • 5
  • 13
8
votes
1 answer

Index fragmentation problem after disabling page-level locking for an Index

I have an Index which has page level locking disabled and now I have index fragmentation issues for that index. I was aware that I won't be able to Reorganize the index, but I believed that I would be able to rebuild the index. Now I think rebuild…
user9516827
  • 1,345
  • 3
  • 19
  • 41
8
votes
2 answers

How often should we use Update Statistcs.(More frequent or Not)

We usually use Ola Hallengren's solution that takes care of Update Statistics which is inside the Index optimize job that we have. We have it scheduled for every Sunday midnight in all servers (1500+) as a standard practice. Now, there are a few…
Ramakant Dadhichi
  • 2,338
  • 1
  • 17
  • 33
7
votes
3 answers

Ola Hallengren index maintenance - long periods of time between commands?

I run the Ola Hallengren scripts on all of my servers for index and statistics maintenance. When I look through the command log table, I notice long periods of time between a command ending, and the next command starting. Sometimes this gap is over…
Erik Reasonable Rates Darling
  • 45,549
  • 14
  • 145
  • 532
7
votes
2 answers

Ola Hallengren IndexOptimize - does it do retries?

It's been awhile since I needed to tend a SQL Server, but have used Ola's solution with great success in the past. I was told by a DBA today that when you pass options like these for IndexOptimize: @FragmentationMedium =…
Eric Tarasoff
  • 171
  • 1
7
votes
2 answers

IndexOptimize - Configuration

We recently switched to Ola Hallengren's maintenance script and automated the deployment of MaintenanceSolution.sql to our customers's SQL Server instance. We need to set these parameters for the job IndexOptimize -…
William
  • 73
  • 1
  • 4
7
votes
2 answers

How to maintain Index and Statistics on AWS RDS?

In the process of setting up the SQL Server Index and Statistics Maintenance code on our AWS RDS instance, I've managed to set up the scripts and can run it from SSMS. Please advice on how to setup SQL Server Agent considering the restrictions of…
Andy Felton
  • 71
  • 1
  • 1
  • 2
7
votes
3 answers

(Ola Hallengren) Deleting log backups older than last FULL backup

When I deploy Ola Hallengren's backup script into my servers, I always set the @CleanupTime parameter for log backups to zero. This way, every time the log backup job runs, it checks for log backup files older than the last full backup and deletes…
Guillermo G
  • 182
  • 2
  • 11
7
votes
2 answers

How to change job output log location, when using Ola Hallengren's scripts

When using Ola Hallengren's SQL Server Maintenance Solution, the job output log is going to a local directory on the SQL server. I was thinking of placing these logs on a fileserver to allow access to more people so they can review the job…
cspell
  • 511
  • 1
  • 7
  • 18
7
votes
1 answer

Ola Hallengren Index Script not Reindexing

First, I realize a similar question was asked and the poster had page count set to 1000 for a 679 page index; not what's going on. I have Ola's script set as @Databases nvarchar(max) ,@FragmentationLow nvarchar(max) = null ,@FragmentationMedium…
jbkelly
  • 93
  • 7
6
votes
2 answers

Ola Hallengren with database mirroring

I am about to setup Ola Hallengrens database maintenance plan. We have our database mirrored and I was just wanting to know if I need to run the script on both my Sql Server instances or only the primary?
Peuge
  • 209
  • 1
  • 9
1
2 3
…
18 19