I download the utility "Performance Monitoring and Analysis" from the Analytics zone site
https://www.analyticszone.com/homepage/web/displayMarketplacePage.action#catalog/assets_cognos_pma
I read that this utility work with the IBM Business Intelligence Pattern with BLU Acceleration.
Does anyone know if this utility can be set up in a simple IBM Cognos 10?
Yes it can. We did it with 10.2.1 on top of SQL Server. No BLU acceleration/pattern in the picture.
However, we had to get help on the install from IBM, and then figure out how to use it.
The resulting analysis was amazing. We pinpointed a single prepare inside one query which was the root cause of our performance issue.
It wasn't easy but it was well worthwhile.
It appears PMA is no longer available on AnalyticsZone. I wonder why?