August 12, 2013 at 3:00 am
My Optimization job failed with below error.
Edition: Enterprise Edition (64-bit) Procedure: [master].[dbo].[IndexOptimize] Parameters: @databases = 'USER_DATABASES', @FragmentationHigh_LOB = 'INDEX_REBUILD_OFFLINE', @FragmentationHigh_NonLOB = 'INDEX_REBUILD_ONLINE', @FragmentationMedium_LOB = 'INDEX_REORGANIZE', @FragmentationMedium_NonLOB = 'INDEX_REORGANIZE', @FragmentationLow_LOB = 'NOTHING', @FragmentationLow_NonLOB = 'NOTHING', @FragmentationLevel1 = 5, @FragmentationLevel2 = 30, @PageCountLevel = 1000, @SortInTempdb = 'N', @MaxDOP = NULL, @FillFactor = NULL, @LOBCompaction = 'Y', @StatisticsSample = NULLDateTime: 2013-08-11 01:00:00 Database: [allmed] Status: ONLINE Updateability: READ_WRITEDateTime: 2013-08-11 01:01:15 Database: [archsys] Status: ONLINE Updateability: READ_WRITEDateTime: 2013-08-11 01:01:48 Database: [cs3live] Status: ONLINE Updateability: READ_WRITEDateTime: 2013-08-11 01:02:10 Command: ALTER INDEX [i_1985510508x0] ON [cs3live].[scheme].[slxrefm] REORGANIZE WITH (LOB_COMPACTION = ON) Comment: IndexType: NonClustered, LOB: No, AllowPageLocks: Yes, PageCount: 2763, Fragmentation: 5.13934Outcome: Succeeded Duration: 00:00:02 DateTime: 2013-08-11 01:02:12DateTime: 2013-08-11 01:04:38 Command: ALTER INDEX [i_1764282674x2] ON [cs3live].[scheme].[opheadm] REBUILD WITH (SORT_IN_TEMPDB = OFF, ONLINE = ON) Comment: IndexType: NonClustered, LOB: No, AllowPageLocks: Yes, PageCount: 3282, Fragmentation: 92.8702Msg 50000, Level 16, State 1, Server UKDXSDBCVTC016, Procedure CommandExecute, Line 95 Msg 1222, Lock request time out period exceeded.Outcome: Failed Duration: 01:00:12 DateTime: 2013-08-11 02:04:50DateTime: 2013-08-11 02:04:55 Command: ALTER INDEX [i_1764282674x4] ON [cs3live].[scheme].[opheadm] REBUILD WITH (SORT_IN_TEMPDB = OFF, ONLINE = ON) Comment: IndexType: NonClustered, LOB: No, AllowPageLocks: Yes, PageCount: 3238, Fragmentation: 92.0012Msg 50000, Level 16, State 1, Server UKDXSDBCVTC016, Procedure CommandExecute, Line 95 Msg 1222, Lock request time out period exceeded.Outcome: Failed Duration: 01:00:05 DateTime: 2013-08-11 03:05:00DateTime: 2013-08-11 03:05:01 Command: ALTER INDEX [i_1764282674x6] ON [cs3live].[scheme].[opheadm] REBUILD WITH (SORT_IN_TEMPDB = OFF, ONLINE = ON) Comment: IndexType: NonClustered, LOB: No, AllowPageLocks: Yes, PageCount: 3928, Fragmentation: 62.4745Msg 50000, Level 16, State 1, Server UKDXSDBCVTC016, Procedure CommandExecute, Line 95 Msg 1222, Lock request time out period exceeded.Outcome: Failed Duration: 01:00:20 DateTime: 2013-08-11 04:05:21DateTime: 2013-08-11 04:05:21 Command: ALTER INDEX [i_1764282674x8] ON [cs3live].[scheme].[opheadm] REBUILD WITH (SORT_IN_TEMPDB = OFF, ONLINE = ON) Comment: IndexType: NonClustered, LOB: No, AllowPageLocks: Yes, PageCount: 1923, Fragmentation: 85.5434Msg 50000, Level 16, State 1, Server UKDXSDBCVTC016, Procedure CommandExecute, Line 95 Msg 1222, Lock request time out period exceeded.Outcome: Failed Duration: 01:00:03 DateTime: 2013-08-11 05:05:24DateTime: 2013-08-11 05:05:25 Command: ALTER INDEX [i_1764282674x12] ON [cs3live].[scheme].[opheadm] REBUILD WITH (SORT_IN_TEMPDB = OFF, ONLINE = ON) Comment: IndexType: NonClustered, LOB: No, AllowPageLocks: Yes, PageCount: 2494, Fragmentation: 57.5782Msg 50000, Level 16, State 1, Server UKDXSDBCVTC016, Procedure CommandExecute, Line 95 Msg 1222, Lock request time out period exceeded.Outcome: Failed Duration: 01:00:04 DateTime: 2013-08-11 06:05:29DateTime: 2013-08-11 06:05:29 Command: ALTER INDEX [i_6928d132002dd31e] ON [cs3live].[scheme].[opheadm] REBUILD WITH (SORT_IN_TEMPDB = OFF, ONLINE = ON) Comment: IndexType: NonClustered, LOB: No, AllowPageLocks: Yes, PageCount: 6266, Fragmentation: 43.2333Msg 50000, Level 16, State 1, Server UKDXSDBCVTC016, Procedure CommandExecute, Line 95 Msg 1222, Lock request time out period exceeded.Outcome: Failed Duration: 01:00:04 DateTime: 2013-08... Process Exit Code 1. The step failed.
Please help me to rectify it.
advance thanks
August 13, 2013 at 12:23 am
Is it a large table you will reindex.
Lock request time out period exceeded.Outcome: Failed Duration: 01:00:04 DateTime: 2013-08... Process Exit Code 1. The step failed.
Is there a large update job running on the table/db? Is backup running on a large db? Look in the SQL log - is there any messages that could be related to this one (log files full etc).
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply