How does 85% gain in performance sound to you? Music to your ears?

We are not discussing about performances, sticks, bows in the world of music. This is a guest from Preeti Gupta at Novartis and  she shares about some aspects of Windchill performance tuning. This is first post in a series on this topic…

In this blog post, I, Preeti would like to cover some of my experiences in fine-tuning Enterprise applications. Over the last 12 years, I have had the opportunity to tune PTC Windchill application and databases. The PLM user base ranged from 400 users to 1100+ users.

Heard this before? “Oracle is running just fine, it’s an issue with Windchill…”

I remember vividly when Alcon first went live with Windchill 8.0 (Migrated from Intralink 3.4 back in 2007). We spent more than a month trying to tune all Windchill application components, Apache, Tomcat and Windchill application server. We tried to tune every aspect of client and application tier but left  Oracle tuning thinking that the DBAs would take care of it! But that’s not the case everywhere, they used to give me an answer which was kind of black box to me “Yes Oracle is running just fine, it is an issue with Windchill”. That’s it. Now what?  Read More

Original Posted