How can I verify the Analysis Center ETL job is not hung on step 16? (NETIQKB50006)

How can I verify the Analysis Center ETL job is not hung on step 16?

You cannot easily see the progress of a job because SQL Server does not provide detailed status for SQL jobs and the ETL job does not give status for the specific steps. Most of the data processing occurs in step 16, so this step can take a long time to complete. Processor or memory availability can affect resource consumption. Since the ETL job processes the AppManager repository fact data for Analysis Services, the time may be extended if you have a large AppManager repository. 

Early iterations of the ETL job could take more time as data is processed or transformed for the Data Mart. For example, an 18 GB QDB, the ETL job step 16 could take up to 24 hours to complete. 

To confirm that the ETL job is not hung or locked:

1. Use SQL Enterprise Manager to connect to the SQL server that hosts the Analysis Center ETL job.
2. Expand SQL Server > Management > Current Activity > Process Info.
3. Look at the column Block by to see if any other process is blocking the Data Mart database.
4. Look at the Locks Info folder to see if any objects are locked.

If there is no blocking or locks, then ETL job is still uploading the data.

Formerly known as NETIQKB50006