Forum Discussion
Fishan009
Jul 04, 2024Copper Contributor
re-org index and statistics update jobs are failing
how to resolve failing re-org index and statistics jobs, there are not enough information in the logfile and I verified there are no jobs running at the same time,
Message
Executed as user: CFS\sqlmsdata2016svr. ....0.4125.3 for 64-bit Copyright (C) 2022 Microsoft. All rights reserved. Started: 8:00:00 PM Progress: 2024-07-03 20:00:01.90 Source: {5FB65CC1-7283-42ED-84DA-2A2506E11D2F} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query "USE [ccs_orion_new] ".: 0% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query "ALTER INDEX [CCSI_APIPoller_ApiPoller_CS_Detail_hi...".: 1% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query "USE [ccs_orion_new] ".: 1% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query "ALTER INDEX [CCSI_APIPoller_ValueToMonitor_CS_Deta...".: 2% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query "USE [ccs_orion_new] ".: 2% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query "ALTER INDEX [CCSI_APM_ActiveDirectoryBbNamingConte...".: 3% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query "USE [ccs_orion_new] ".: 3% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query "ALTER INDEX [CCSI_APM_ActiveDirectoryBbSite_CS_Det...".: 4% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query "USE [ccs_orion_new] ".: 5% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query "ALTER INDEX [CCSI_APM_ComponentError_CS_Detail_his...".: 5% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query "USE [ccs_orion_new] ".: 6% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query "ALTER INDEX [CCSI_APM_ComponentStatus_CS_Detail_hi...".: 6% complete End Progress Progress: 2024-07-03 20:03:50.35 Source: Reorganize Index Executing query "USE [ccs_orion_new] ".: 7% complete End Progress Progress: 2024-07-03 20:03:50.36 Source: Reorganize Index Executing query "ALTER INDEX [CCSI_APM_DynamicEvidence_CS_Detail_hi...".: 7% complete End Progress Progress: 2024-07-03 20:03:50.36 Source: Reorganize Index Executing query "USE [ccs_orion_new] ".: 8% complete End Progress Progress: 2024-07-03 20:03:53.35 Source: Reorganize Index Executing query "ALTER INDEX [PK_APM_HardwareItem_Detail] ON [dbo]....".: 8% complete End Progress Progress: 2024-07-03 20:03:53.35 Source: Reorganize Index Executing query "USE [ccs_orion_new] ".: 9% complete End Progress Progress: 2024-07-03 20:03:55.07 Source: Reorganize Index Executing query "ALTER INDEX [PK_APM_HardwareItem_Hourly] ON [dbo]....".: 10% complete End Progress Progress: 2024-07-03 20:03:55.07 Source: Reorganize Index Executing query "USE [ccs_orion_new] ".: 10% complete End Progress Progress: 2024-07-03 20:03:56.91 Source: Reorganize Index Executing query "ALTER INDEX [PK_APM_HardwareItemStatus_Hourly] ON ...".: 11% complete End Progress Progress: 2024-07-03 20:03:56.91 Source: Reorganize Index Executing query "USE [ccs_orion_new] ".: 11% complete End Progress Progress: 2024-07-03 20:03:56.91 Source: Reorganize Index Executing query "ALTER INDEX [CCSI_APM_PortEvidence_CS_Detail_hist]...".: 12% complete End Progress Progress: 2024-07-03 20:03:56.91 Source: Reorganize Index Executing query "USE [ccs_orion_new] ".: 12% complete End Progress Progress: 2024-07-03 20:03:56.91 Source: Reorganize Index Executing query "ALTER INDEX [CCSI_APM_ProcessEvidence_CS_De... The package execution fa... The step failed.
wondering how to resolve this issue, if any idea please let me know
Thank You,
- bandaruajeyuduCopper ContributorEven if no other jobs are running, check for other activities that might be consuming resources (e.g., long-running queries, high CPU/memory usage).
Use Performance Monitor (PerfMon) or SQL Server Dynamic Management Views (DMVs) to monitor system resource usage.
Look for Blocking and Deadlocks
Ensure there is enough free disk space on the drives where your data and log files reside.
Check for any disk I/O bottlenecks.