I am running Weekly Index Optimizing job to Modify the stats but it's failing from last few times at this step - Modify Stats.
Actually we are running this off hours on Weekend using Ola's script.
Any one having issue or any suggestion?
Is it Ola's script having any work around?
We are getting following error message for some of the failed stats:
Msg 1222, Lock request time out period exceeded
Command: UPDATE STATISTICS [BIDS].[dbo].[WorkQ] [_WA_Sys_00000006_151B244E] Msg 50000, Level 16, State 1, Server BIDSSql, Procedure CommandExecute, Line 167 Msg 1222, Lock request time out period exceeded. Outcome: Failed Duration: 01:00:00 DateTime: 2021-09-26 11:14:05
This is a Sql Server 2012 and Database is around 150 GB size.