Problem Installing SSAS Monitoring App

Oct 8, 2009 at 4:03 PM

Hi,

I've just installed the monitoring app and the management data warehouse like it was described on yout paper.

But if i look into the trace table, there are no data for the performance traces. Everything else works fine. Including the SSIS tasks.

Could you please tell me why the app still doesn't work?

Best Regards

Marcus

Nov 12, 2009 at 4:43 PM

 

 

In order to make it work you need to change WHERE P_BatchID <= @BatchID to WHERE P_BatchID < @BatchID to get rid of all batches before current batch.

Aug 20, 2010 at 4:10 PM

FYI This change is in the SSASCleanBatch stored procedure.