How are your List Threads configured (min/max)? How many Closed records in your SHR:ConsolidatedList table?
Tim -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mike Parker Sent: Wednesday, November 01, 2006 2:58 PM To: [email protected] Subject: Re: Server sizing & Performance I would turn on your SQL logs and get a few query statements (ex: Open a form, run a query, etc.) Try running those queries locally on your DB (through Query Analyzer) and from your Remedy Box (SQL Client) and see see the results. If they are different, it could be your network. I saw this not too long ago and I guess the switch was set to 100 Full, and Windows 2003 was set to Auto-Configure. Soon as I set the NIC to 100 Full, the speed of the app increased tremendously. >From: Thad Esser <[EMAIL PROTECTED]> >Reply-To: [email protected] >To: [email protected] >Subject: Re: Server sizing & Performance >Date: Wed, 1 Nov 2006 11:50:39 -0800 > >I'd check all your tabs for tables that are being refreshed on display. >If the tab isn't displayed, odds are good that the table doesn't need >to be refreshed until the user selects the tab. That's the easiest >bang for the buck. You should then check into why its taking so long >to refresh those tables (indexing on underlying forms/bad quals/etc) > >Thad >"Argue for your limitations, and sure enough, they're yours."-- Richard >Bach > > > >"[EMAIL PROTECTED]" <[EMAIL PROTECTED]> Sent by: "Action >Request System discussion list(ARSList)" ><[email protected]> >11/01/2006 11:42 AM >Please respond to >[email protected] > > >To >[email protected] >cc > >Subject >Server sizing & Performance > > > > > > >We're currently suffering performance issues with the configuration >below. > >Server and Mid-tier running version 6.03 patch 18 and a moderately >customized RSM / HelpDesk app and the SLA module (ver 6). > >200 concurrent users between citrix and windows clients (6.03 patch 15) >50-100 mid-tier users (not quite there yet but expecting this kind of >traffic) > >App Server is DELL PowerEdge 2850 DUAL 3.6GHz with 4GB RAM running >windows server 2003 Mid-Tier server is HP Proliant DL380 QUAD 2.6GHz >with 4GB RAM running windows server 2003 DB Server is mystery QUAD 3GHz >with 4GB RAM running windows server 2003 > >We're serving users all over the country from a western based >server/db/midtier, hardware is all on the same subnet, and the network >folks say bandwidth isn't a problem, the hardware folks say there isn't >anything suffering any kind of bottle neck yet our users pretty much >across the board complain of slowness. It takes an average of about 6 >to 8 seconds to view (load) an existing help desk case or task through >the Support console. > >Nothing is really standing out to me as a pain point outside of >application tuning. Network folks are looking at routing for me to >ensure our users aren't getting bounced around before hitting the >server... I'm at a loss. > >Thoughts? Ideas? My gut tells me to add memory to the app server and >or perhaps processors. This is a hot item for us though, the slowness >is bad news. > >_______________________________________________________________________ >________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >ARSlist:"Where the Answers Are" > > > >***IMPORTANT NOTICE: This communication, including any attachment, >contains information that may be confidential or privileged, and is >intended solely for the entity or individual to whom it is addressed. >If you are not the intended recipient, you should delete this message >and are hereby notified that any disclosure, copying, or distribution >of this message is strictly prohibited. Nothing in this email, >including any attachment, is intended to be a legally binding >signature.*** > >_______________________________________________________________________ >________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >ARSlist:"Where the Answers Are" _________________________________________________________________ Try the next generation of search with Windows Live Search today! http://imagine-windowslive.com/minisites/searchlaunch/?locale=en-us&source=h mtagline ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
