sql-server-maintenance-solution

sql-server-maintenance-solution copied to clipboard

Select indexes slow performance, doesn't use indexes parameter

4

**Description of the issue** The index optimize procedure when updating statistics can be very slow on large databases with lots of objects. The two attached sections will try and get...

asos-dipeshbhundia

Exclude option expanded feature

4

Currently we have databases in AGs. We have a very large database that is no longer used but is there for historical purposes. We run our Index Optimize to update...

redtrain65

DatabasesInParallel

6

**Description of the issue** We have (8) TLOG backup jobs running across hundreds of databases in parallel. If one of the backups is still running when the job executes in...

ghost

Option to have more errors raise an expection

1

Using the DatabaseBackup stored procedure we recently had someone try to exclude a database from the backup by setting the @Databases parameter to 'USER_DATABASES -ExcludeDb'. (ie They forgot the comma.)...

kmckelve

We have deployed ola hallangren maintenance scripts in our environment(SQL Versions 2016/2019). We noticed a record in commandlog table with text similar to 'DBCC CHECKDB (databasename) WITH all_errormsgs, no_infomsgs, data_purity...

PardhaGanta

Added regions to IndexOptimize for future enhancements. Makes collapsing code much easier.

sqleagle

Using @PartitionLevel = 'N' results in error: Line 68 The multi-part identifier "partitions.partition_number" could not be bound.

1

**Description of the issue** I tried to run update stats using this command with @PartionLevel='N' I get this error: ``` Msg 4104, Level 16, State 1, Line 71 The multi-part...

danrcarollo

IndexOptimize command should exclude rdsadmin database when installed…

3

IndexOptimize command should exclude rdsadmin database when installed on RDS. Sample of generated job step with change: 

lboozer

Add support for UTC in file tokens

StrayCatDBA

Filename tokens are currently based on local time. Add a parameter '@UseUTC bit' that bases tokens on UTC time. This would allow easier integration of the Backup Solution into custom...

StrayCatDBA