Ola IndexOptimize - USER_DATABASES failed

  • EXECUTE [dbo].[IndexOptimize]

    @databases = 'USER_DATABASES',

    @LogToTable = 'Y'

    Job Name                            IndexOptimize - USER_DATABASES

    Step Name                          IndexOptimize - USER_DATABASES

    Duration                              01:00:14

    Sql Severity        16

    Sql Message ID  50000

    Operator Emailed

    Operator Net sent

    Operator Paged

    Retries Attempted          0

     

    Message

    Executed as user: NT SERVICE\SQLSERVERAGENT. ...0)  Server: SERVERABC [SQLSTATE 01000] (Message 50000)  Version: 15.0.4316.3 [SQLSTATE 01000] (Message 50000)  Edition: Enterprise Edition: Core-based Licensing (64-bit) [SQLSTATE 01000] (Message 50000)  Platform: Windows [SQLSTATE 01000] (Message 50000)  Procedure: [master].[dbo].[IndexOptimize] [SQLSTATE 01000] (Message 50000)  Parameters: @databases = 'USER_DATABASES', @FragmentationLow = NULL, @FragmentationMedium = 'INDEX_REORGANIZE,INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE', @FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE', @FragmentationLevel1 = 5, @FragmentationLevel2 = 30, @MinNumberOfPages = 1000, @MaxNumberOfPages = NULL, @SortInTempdb = 'N', @MaxDOP = NULL, @FillFactor = NULL, @PadIndex = NULL, @LOBCompaction = 'Y', @UpdateStatistics = NULL, @OnlyModifiedStatistics = 'N', @StatisticsModificationLevel = NULL, @StatisticsSample = NULL, @StatisticsResample = 'N', @PartitionLevel = 'Y', @MSShippedObjects = 'N', @Indexes = NULL, @TimeLimit = NULL, @Delay = NULL, @WaitAtLowPriorityMaxDuration = NULL, @WaitAtLowPriorityAbortAfterWait = NULL, @Resumable = 'N', @AvailabilityGroups = NULL, @LockTimeout = NULL, @LockMessageSeverity = 16, @StringDelimiter = ',', @DatabaseOrder = NULL, @DatabasesInParallel = 'N', @ExecuteAsUser = NULL, @LogToTable = 'Y', @Execute = 'Y' [SQLSTATE 01000] (Message 50000)  Version: 2020-12-31 18:58:56 [SQLSTATE 01000] (Message 50000)  Source: https://ola.hallengren.com [SQLSTATE 01000] (Message 50000)                   [SQLSTATE 01000] (Message 50000)  Date and time: 2023-10-20 00:00:00 [SQLSTATE 01000] (Message 50000)  Database: [DATABASE123] [SQLSTATE 01000] (Message 50000)  State: ONLINE [SQLSTATE 01000] (Message 50000)  Standby: No [SQLSTATE 01000] (Message 50000)  Updateability: READ_WRITE [SQLSTATE 01000] (Message 50000)  User access: MULTI_USER [SQLSTATE 01000] (Message 50000)  Recovery model: SIMPLE [SQLSTATE 01000] (Message 50000)  Is accessible: Yes [SQLSTATE 01000] (Message 50000)       [SQLSTATE 01000] (Message 50000)  Date and time: 2023-10-20 00:00:01 [SQLSTATE 01000] (Message 50000)  Database context: [DATABASE123] [SQLSTATE 01000] (Message 50000)  Command: ALTER INDEX [dta_DebugTrace_index_uidInstanceId] ON [dbo].[dta_DebugTrace] REBUILD WITH (SORT_IN_TEMPDB = OFF, ONLINE = ON, MAXDOP = 1, RESUMABLE = OFF) [SQLSTATE 01000] (Message 50000)  Comment: ObjectType: Table, IndexType: Clustered, ImageText: No, NewLOB: No, FileStream: No, ColumnStore: No, AllowPageLocks: No, PageCount: 1523, Fragmentation: 88.7722 [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded [SQLSTATE 01000] (Message 50000)  Duration: 00:00:04 [SQLSTATE 01000] (Message 50000)  Date and time: 2023-10-20 00:00:05 [SQLSTATE 01000] (Message 50000)                [SQLSTATE 01000] (Message 50000)  Date and time: 2023-10-20 00:00:05 [SQLSTATE 01000] (Message 50000)  Database context: [DATABASE123] [SQLSTATE 01000] (Message 50000)  Command: ALTER INDEX [IX_dta_DebugTrace_TimeStamp] ON [dbo].[dta_DebugTrace] REBUILD WITH (SORT_IN_TEMPDB = OFF, ONLINE = ON, MAXDOP = 1, RESUMABLE = OFF) [SQLSTATE 01000] (Message 50000)  Comment: ObjectType: Table, IndexType: NonClustered, ImageText: No, NewLOB: No, FileStream: No, ColumnStore: No, AllowPageLocks: No, PageCount: 2700, Fragmentation: 90.6296 [SQLSTATE 01000] (Message 50000)  Outcome: Succeeded [SQLSTATE 01000] (Message 50000)  Duration: 00:00:01 [SQLSTATE 01000] (Message 50000)  Date and time: 2023-10-20 00:00:06 [SQLSTATE 01000] (Message 50000)      [SQLSTATE 01000] (Message 50000)  Date and time: 2023-10-20 00:00:06 [SQLSTATE 01000] (Message 50000)  Database: [BizTalkMgmtDb] [SQLSTATE 01000] (Message 50000)  State: ONLINE [SQLSTATE 01000] (Message 50000)  Standby: No [SQLSTATE 01000] (Message 50000)  Updateability: READ_WRITE [SQLSTATE 01000] (Message 50000)  User access: MULTI_USER [SQLSTATE 01000] (Message 50000)  Recovery model: SIMPLE [SQLSTATE 01000] (Message 50000)  Is accessible: Yes [SQLSTATE 01000] (Mes...  The step failed.

  • dupe post

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply