The Twelve Days of Christmas from HIPPO: No.2 – All Hail the Performance Czar!
For HIPPO’s second gift this Christmas, let’s look at a feature that has been created with your organization’s Performance Czar in mind but is equally useful for Informatica Developers, Testers and Administrators.
The new release of HIPPO has a unique feature that enables you to Search and Report by a wide variety of Performance metrics. So if you want to know which Session executions consumed more than 50 CPU seconds, or 250 MB of Memory, or Sessions whose Cache spilt to Disk, or scored highest in Time to First Row, then these and many more Performance statistics are available within HIPPO. You can set the Performance thresholds that make sense for your organization and then narrow your Search by Date & Time range, by Project, Node, Integration Service, Grid, Repository and Domain and you can even include design features in your Search such as the use of SQL Overrides!
Of course, we are not claiming that high scores in any of these categories is proof in itself of poor performance but what is certain is that these are the resource-intensive processes that should be top of your list for an optimization review. So if you are a Developer, a Tester or an Administrator then you can use HIPPO to rank Sessions by performance metrics and then drill down to see why they are so resource-intensive and what your options are to make them more efficient. Just make sure that you either make improvements or use HIPPO to have your explanation ready when the Performance Czar stops by to discuss the Performance Threshold report that they just ran using HIPPO!
So forget the usual tributes that you pay to your Performance Czar at this time of year and give them something different – something both they and you will find really useful – the HIPPO Performance report.
Check back tomorrow for number 3 in the series!
Footnote: the latest version of HIPPO has just gone on general release and it is packed with new and unique features to manage, optimize and control your Informatica environment. In the run up to Christmas I’m going to choose twelve of my favorite new benefits. It is a tradition in many parts of the world to celebrate the twelve days of Christmas and we have a Christmas carol here in the UK that associates each of the twelve days with a gift. I acknowledge that the twelve days of Christmas occur after Christmas and not before but I hope that you will allow me a little poetic license here!