Is there any way to import old performance data into SPA?
I'm "always" copying all our BTP file to my local drive where I can start Performance Manager and analyze data really quickly, So now when we are starting to use SPA I was thinking if there was anyway to populate SPA with old performance data....
/Lars
Solved! Go to Solution.
highly unlikely. SPA uses mySQL database and BTP is a binary file. Maybe you can figure out which tables in the mySQL database correspond to fields in a ttp file and import that data.
highly unlikely. SPA uses mySQL database and BTP is a binary file. Maybe you can figure out which tables in the mySQL database correspond to fields in a ttp file and import that data.
I was hoping that some EMC'er would have built a import routine for this 🙂
Hi Dynamox, so if btp is mysql binary file it should be decoded into readable format ?
Thanks
Lars, Dynamox is correct. SPA does not understand .btp files. I wish it did too or at least provided some files that could be dowloaded and worked offline.
....
I might try to find out the structure of the mySQL DB... and write an import routine from BTP to the mySQL.... But time and knowledge might be an issue... 🙂
Is there a standard connection name and password for the SPA DB (a jdbc connection URL 🙂 ?
e.g. .... jdbc:mysql://localhost:3306/database
I use Crystal Reports for Eclipse quite much for reporting from StorageScope, DPA and custom DB's... would like to find out the mySQL DB structure to se if any useful reports might be built 🙂
Any way need to tackle the time issues, there is so many things that are fun and so little time 🙂
Sorry Lars, I do not have an answer to your question, and would not even know who to contact for this information. Hopefully someone else can provide some insight.
On page 7 in the Tools section of the Symmetrix Performance Workshop Student Guide, it reads:
"If you add Symmetrix Performance Analyzer to an environment that already contains
Performance Manager, you can import the older Performance Manager to preserve the history of
your existing arrays. The data will be read from Performance Manager’s BTP files into the
Symmetrix Performance Analyzer MySQL database. Once you import the old archives, you
should configure Symmetrix Performance Analyzer to collect its own data on the existing arrays
so that data will be updated automatically.
You can only import archives from arrays that have already been discovered by Symmetrix
Performance Analyzer. In other words, the Symmetrix ID in the BTP file must match an array
already in Symmetrix Performance Analyzer. When read, the large number of Performance
Manager metrics will be reduced to just the key performance indicators that Symmetrix
Performance Analyzer records."
That is the only reference to this that I can find. I am scheduled for this class on Monday and I will see what the instructor says about it and let you know.
🙂 .... now I'm happy ... need to se if it's still there in 2.x.. than's "the_san_man" for triggering me to look deeper!
From SPA Installation Guide 1.0 pn 300-007-397 ....
--- cut ---
The SPA Metric Import Tool (SMIT) is a Symmetrix Performance
Analyzer CLI application used to extract metric data from ECC
Performance Manager daily files, convert them to Key Performance
Indicators (KPIs) and store them in the SPA database.
The SMIT application is intended as a resource to jump start a new
SPA installation by using pre-existing customer performance data in
BTP format to populate the SPA database using the existing SPA
server functionality.
--- paste ---
/Lars
Well half way there BUT....
The IMPORT did not result in more data showing up in SPA 😞 and I don't known if the IMPORT did any population of the mySQL DB or not ... But during the import both the SPA process and the mySQL DB process consumed much CPU cycles so I assume that some this happened..
Is there any EMC'er that can awnser if the smit.jar file should word in SPA 2.x or not?
/Lars