-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Hi,
I would recommend to you to do a schema statistic update on all database servers, if you have an Oracle database. Cheers Tristan Am 29.03.2016 um 20:30 schrieb William Rentfrow: > ** > > I did find something interesting - the time it takes our test > environment to load definitions is 2 minutes - in prod, it's 9+ > minutes. > > > > We'll need to look at the database performance next I think - those > two load times should be very close to the same in the ideal > world. > > > > William Rentfrow > > [email protected] > > Office: 715-204-3061 or 701-232-5697x25 > > Cell: 715-498-5056 > > > > *From:*Action Request System discussion list(ARSList) > [mailto:[email protected]] *On Behalf Of *Kelly Logan *Sent:* > Tuesday, March 29, 2016 1:08 PM *To:* [email protected] > *Subject:* Re: Ever increasing AR server start up times > > > > ** > > Email and other transactional queues may be read during startup. If > they aren't cleared out regularly, the increasing numbers of > transactional entries may account for increasing delays in startup. > You may also want to check any fast running escalations that might > be querying and acting based on forms with growing numbers of > entries. > > > > On Tue, Mar 29, 2016 at 9:35 AM, William Rentfrow > <[email protected] <mailto:[email protected]>> > wrote: > > ** > > Platform: Linux VM's, 2 servers in the server groups, running > Remedy 9.01 against a remote Oracle database. > > > > So - we have a large number of users (500, give or take) and enter > many incidents every day. I haven't pulled incident counts for a > while but I'm sure we've got at least a couple of million. > > > > We have 4 environments - Development, Test, Customer test/training, > and Production. > > > > In the first 3 server start time is nearly identical - right around > the 7 minute mark. The secondary server comes up slightly faster. > > > > In production the server start times keep getting longer. Last > time I checked it the time was 15 minutes - then 17, and now just > about 20. This is during off hours with no users online and nothing > else running that would affect it. During the day it can be even > slower. > > > > We had seen this same thing before in another separate production > version of Remedy 7.6.04 - the startup times were as long as 45 > minutes just for the AR server to complete starting up - this is > without any real errors or problems, with fast connection speeds. > > > > My question is - why? My understanding has always been that the AR > server caches all workflow/forms on startup, but that amount of > data is relatively static. Is it caching something else tied to > user data that is not advertised? I haven't yet pulled in our DBA > performance crew to look at the startup calls - I thought I'd start > here first. > > > > And to be clear - there's no timeouts anywhere, no errors, nothing > - it's a clean start...that keeps taking longer and longer. > > > > William Rentfrow > > [email protected] <mailto:[email protected]> > > Office: 715-204-3061 <tel:715-204-3061> or 701-232-5697x25 > <tel:701-232-5697x25> > > Cell: 715-498-5056 <tel:715-498-5056> > > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > > > > > > -- > > Kelly Logan > > Senior Consultant > > Rapid Technologies, Inc. <http://www.raptek.com> > > Office: 313-651-7169 > > Cell: 313-645-4552 > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > > ---------------------------------------------------------------------- - -- > > No virus found in this message. Checked by AVG - www.avg.com > <http://www.avg.com> Version: 2016.0.7497 / Virus Database: > 4545/11902 - Release Date: 03/28/16 > > _ARSlist: "Where the Answers Are" and have been for 20 years_ -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQIcBAEBCAAGBQJW+srVAAoJEEoiQq17Nf5e204P+wcf7T7oJNX+y/nAhYJRDgkQ OxS20OP6QFUJlSuz7uY0YCMLs/BmgCQ4OuGBlIpcfeEuaA+Uh9Yn6beZkNWx6rGg iSyDqKkEe5bT2QiJpNVhGpJ5CuJo4e1YxK+obsmJAlsT4h2EgRzRc02CqI7vr1wt 7IO7gA8+lnSQsHiqHopMkIvJdo0z0qodpj/w/nrxM87lT8qfarX+/ecBV4FOe7Xv 1GMBluRcZ9VLfG/g/NY6RyPffDnyxU6oZMYum0GLRsXFKj2orh4rqnIIT4dOG1Dz UTqgZbUlQs7KsfPpAGJV61BkgIgpZdxKHxhjSjv9iLe7GcLM6ZmS+VgAIylhtzVS MJUv6vRiVoEtwWsobOVGQNxBHZXFH3JKQ6YNvM1b98Gh05L2oSt5M3au5JFzSyH1 wvHAxtgwJSb4FrBRnL+mSrNlDJ/W4h7BnxzUoBqrn4m2nlu9ORBnhwIX/twVY2Y/ quNd0NqPiPHrGcUNgn3shr7vVZAZy1sFfPiekcqlpDHo/g9oUtkj2wGjrPIjvgfO NXCGHn/wcwv3VfFiZBMLD3Vl+Oxn6RuHdFuIQ9h6bc0wIMCY59EkMn3f/pPMcwXF 0vsehJNw7zu8OSNbttelnmg3zZi/5A2W8YM923DArh1paC3Dy5BP3xyw3JI6H7lV KR0YUt/wSMesq8MTu555 =peoc -----END PGP SIGNATURE----- _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
