Enterprise Manager Benefits

[mstrNate]

Has anyone here used MSTR Enterprise Manager, specifically, the version released with 7.2.x? We're evaluating 7.2.2 and are curious as to what benefits EM will offer us. I know it's been around in previous versions, but we just haven't used it before. Thanks in advance!

Nate

 

[miguel3000]

I've used EM extensively to monitor and improve report performance. By capturing usage statistics (most popular reports, most frequently hit tables, longest running reports, etc), you can get a pretty good idea of the changes you need to make to your database to improve query performance.

 

[mstrNate]

Thanks for the reply Miguel. I think we'll probably try it out soon then.

 

[MstrSwede]

Have anyone of you experienced that the statistics database is missing alot of data concerning user connection.

When I check when users last logged in, accordning to EM, some haven't been using MSTR for over 14 months. When asked they say that they do use MSTR periodically.

All users access MSTR throught the web interface. It's only us users that use Desktop.

We do have a home-made authentication-routine but it seems to work as we track alot of connections every day in EM.

The question is if it is possible some users don't get logged in the statistics DB? Anyone who has experienced this?

 

[MstrSwede]

It seems that there is no problem with the MSTR products. I have checked the log-files our custom login-plug-in produces and have been able to verify that the statistics in MSTR is correct. Problem solved !