Jim, What I would recommend is to turn on SQL/Filter/API logs into a single log and then run one of your 'lackluster' operations. Then run the log through the log analyzer. It'll give you your longest api and sql transactions (depending on the options you select)..then you can analyze the queries to find out what filters they come through and such..the log analyzer is a VERY powerful troubleshooting tool.
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Jim Coryat (jcoryat) Sent: Wednesday, May 12, 2010 8:35 AM To: [email protected] Subject: Question on Remedy Performance ** We are running ARS 7.1 patch 006 with ITSM 7.0.03 patch 007. The applications for the most part have been out of the box implementations, we have made some customizations but they have been minor in scope. Our application servers are dual 3.0ghz Xeon boxes with 8gb of memory running windows 2003 Enterprise. The database is Oracle 11 on a Sun V440 4 CPU 32gb memory dedicated box. Both the application server and database are on gigabit network connections. This has been bugging me for a while and I can't seem to figure out why the application server and database for the most part sit there at an idle, yet we have lackluster performance of the remedy system in regards to the customer experience on the desktop and web client. The performance is not terrible, however due to the under utilization of the hardware I would expect better response than what we are seeing. What I'm looking for is some pointers or documentation someone might know about that would help to identify anything that would be causing this behavior. I have read the scalability white papers published by BMC, which closely mirrors our configuration and this has been of little value. Jim Coryat Micron Technology Inc. _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
