Another thing to keep in mind is fragmentation of the ARS data dictionary. During startup, (I'm 99% sure that) ARS pulls the entire data dictionary into memory. Over time, as you implement changes and unless you've taken steps to mitigate the problem, the DD will become increasingly fragmented. I'm a little out of my depth on this, but it seems to make sense that if you have a very large database, this can mean that the DD data is spread throughout your tens/hundreds/thousands of GB of user data, and that in turn can mean that it takes the DB a while to gather it all up during startup.
Preventative mitigation strategies would include sequestering the DD tables so that this can't happen. I'm getting much further out of my depth, but I have a vague recollection that you used to somehow be able to direct ARS how to use Oracle segments, though I don't recall the granularity of this and don't know if the configuration mechanism still exists (I've dabbled a bit I'm far from being an Oracle DBA). And while I'm not a SQL server DBA either, I'm much more familiar with it as a database, and I can see how with a bit of manual effort you could certainly sequester the ARS DD tables into their own filegroup. A reactive strategy (i.e. relieve existing fragmentation) would be to copy-restore the DB, or at least the ARS tables. -charlie On Wed, Feb 19, 2014 at 8:14 AM, Tauf Chowdhury <taufc...@gmail.com> wrote: > ** > I recall a while back someone explained that there is also a difference > between SQL and Oracle DB where The ITSM env on Oracle takes longer to > start than SQL Server > > Sent from my iPhone > > On Feb 19, 2014, at 10:18 AM, "Pierson, Shawn" < > shawn.pier...@energytransfer.com> wrote: > > ** > > You bring up a good point. From what I've seen the CPU and RAM are never > too high even when starting up, and the database connection should actually > be a decent connection (both servers are on the same switch, which I can > tell thanks to ADDM) but I'd think that probably is one of the limiting > factors of startup. My suspicion is that BMC's increasing reliance on > plugins, which seem to be black boxes that are hard to gain visibility > into, is a major factor as well. > > > > It would be an interesting test to have two pieces of the same hardware > with AR System installed, one with the full ITSM, another without ITSM (but > for charity include the supporting AR System modules like Approval that > normally aren't used in fully custom shops) but with an equal number of > forms, groups, and users, and time the startup times of both. > > > > Thanks, > > > > *Shawn Pierson * > > Remedy Developer | Energy Transfer > > > > *From:* Action Request System discussion list(ARSList) [ > mailto:arslist@ARSLIST.ORG <arslist@ARSLIST.ORG>] *On Behalf Of *LJ > LongWing > *Sent:* Wednesday, February 19, 2014 8:15 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Why does the ARS Service take so long to start? > > > > ** > > Shawn, > > In later versions of Remedy, you have the options to utilize multiple > threads during the startup. As Rick points out, the main thing that Remedy > is doing is pulling metadata out of the DB and storing it in RAM. So, > there is a direct correlation between how many forms/fields/etc that you > have, and how quickly you can get them out of the DB and into memory that > determines how quickly your Remedy starts. Do you have that dedicated > Fiber channel between your DB and App server that Remedy recommends? :) > > > > On Wed, Feb 19, 2014 at 5:57 AM, Pierson, Shawn < > shawn.pier...@energytransfer.com> wrote: > > ** > > Since I have nothing better to do (just kidding, I'm swamped) I wanted to > see if anyone on the list had a good explanation for something that has > been an issue across multiple versions of Remedy for years. Specifically, > on Windows, why does it take so long for Remedy to start up, and is there > anything that can be done to make it load faster without sacrificing > performance or functionality? > > > > If someone has found a way to get it to start up in less than 30 seconds, > you should be given a job by BMC. It's been a while since I've worked with > Remedy on Unix but I don't recall it taking as long to start as it does on > Windows. > > > > Thanks, > > > > *Shawn Pierson * > > Remedy Developer | Energy Transfer > > > > Private and confidential as detailed > here<http://www.energytransfer.com/mail_disclaimer.aspx>. > If you cannot access hyperlink, please e-mail sender. > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > Private and confidential as detailed > here<http://www.energytransfer.com/mail_disclaimer.aspx>. > If you cannot access hyperlink, please e-mail sender. _ARSlist: "Where the > Answers Are" and have been for 20 years_ > > _ARSlist: "Where the Answers Are" and have been for 20 years_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
