Status - 8/25/2014
I wanted to give an update status to anyone following this thread. I opened up a Service Ticket with CA and provided debug logs, but I'm still waiting.
Over the Weekend, I tried a new installation, but used the same DB files. I installed 9.6, new installation. I then modified 4 config files, domains.xml, users.xml, realms.xml, server.xml. The rest are mostly out of the box. I did modify the "lax" files to increase jvm size. I did not deploy any of the customized modules from my previous installation. I used out-of-the-box CA Dashboards. I concentrated on the SOA Performance Overview Dashboard for my testing.
The new installation still used the same db's.....ie.....SmartStor, APM DB, Baseline, Trace....
Problem still the same. 7 days, sometimes I get the metrics, sometimes I don't, 30 days can crash Workstation back to the login prompt. So, a new installation, with same db files did not work.
I also did some testing basing a comparison of our 9.1.7 installation in Production, which has far more metrics than the development environment. I tried using both Workstation 9.6 and Workstation 9.5.3, with the 9.6 installation. The results are below.
------------------------Base Comparison -- Production using 9.1.7 Workstation ------------------------
Production -- Version 9.1.7 -- SOA Performance Overview Dashboard
Workstation...9.1.7 (Logged into MoM)
Time Range 7 Days......3 seconds
Time Range 30 Days......10 seconds
----- Has more Data than DEV. Same Physical Configuration as DEV. (memory,cpu,disk)
---------------------Using 9.6 Workstation ---------------------------------------
DEV -- Version 9.6 --- SOA Performance Overview Dashboard
Workstation 9.6 (Logged into Collector 01, fewer agents)
Time Range 7 Days.......1.5 minutes
Time Range 30 Days..... 4 minutes
Workstation 9.6 (Logged into MoM)
Time Range 7 Days...... Crashes Workstation back to Login Prompt (Sometimes it doesn't. but doesn't display all the data)
Time Range 30 Days...... Crashes Workstation back to Login prompt
------------------------- Using 9.5.3 Workstation --------------------------------
DEV -- Version 9.6 -- SOA Performance Overview Dashboard
Workstation 9.5.3 (Logged into Collector 01, fewer agents)
Time Range 7 Days......1 minute...all data displayed
Time Range 30 Days....3 minutes ... all data displayed
Workstation 9.5.3 (Logged into MoM)
Time Range 7 Days.....2 minutes, but partial data display, two of the graphs never updated after 10 mins.
Time Range 30 Days....After 10 minutes....nothing...didn't wait longer....but no crashes
SUMMARY: Whether using a new or upgraded 9.6 installation, looking at historical metrics is extremely slow, past 7 days, it hangs or does not display in the Workstation, at 30 days, the Workstation Crashes.