November 13, 2017 at 6:40 am
Dear all,
I have implemented OLA Maintenance (index defrag) job as per below:
Runs the following command in the database dwhLogging: EXECUTE dbo.IndexOptimize
@Databases = 'DB1, DB", etc...',
@FragmentationLow = NULL,
@FragmentationMedium = 'INDEX_REORGANIZE,INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
@FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
@FragmentationLevel1 = 5,
@FragmentationLevel2 = 30,
@UpdateStatistics = 'ALL',
The job does not stop runing (two days now) last loogeg opeartion is update statistics (stattisc name = _WA_Sys_00000004_2161CAF9) in one of the databases.
How can I see where is the job stuck?
Thank you
November 13, 2017 at 7:06 am
Use sp_whoisactive to see what statement is currently running.
John
November 13, 2017 at 9:00 am
John Mitchell-245523 - Monday, November 13, 2017 7:06 AMUse sp_whoisactive to see what statement is currently running.John
Thanks. Problem solved.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply