Re: BMC Remedy - Copy to Archive and Delete from Source - AR System Email Messages?
Susan, Can you elaborate on your statement, I was also notified yesterday that it is not recommended to archive system email messages, there is some unusal result related to it.? Do you remember where you got this information? Are you still archiving your email messages? Anyone else heard or read anything on this?? Thanks, Laura From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Susan Palmer Sent: Wednesday, March 26, 2008 10:28 AM To: arslist@ARSLIST.ORG Subject: Re: BMC Remedy - Copy to Archive and Delete from Source ** Mel, I have found that for 'us' keeping less than 100k Help Tickets or Tasks in those forms keeps performance at an acceptable level. You have to remember that all workflow is affected by the number of records in the form and keep in mind any table fields that are refreshed. We generally keep 13 months of or closed records. Since we upgraded to v7.0.1P3 last year I was excited about the 'archive' option. In the last month I've used it on HTs, Tasks and email messages. For us it appears to require a huge amount of disk space for the copy/delete option. That needs to be planned for and it was greater than 1 for 1 which is logical since another table is now holding the same record. For us it was quite a bit more than that infact we nearly brought the server down. I only archive in the lowest of production hours (night) when minimal users are on the system. I was also notified yesterday that it is not recommended to archive system email messages, there is some unusal result related to it. Sorry did not get more info. I found the actual archiving to go fairly quick, was doing about 70k records both times. I liked the fact I didn't have to manually delete the records afterwards. hth, Susan ShopperTrak ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: BMC Remedy - Copy to Archive and Delete from Source - AR System Email Messages?
Laura I tried to setup an Archive form for the Email Messages form a while ago, and ran into the unusual activity that Susan was referring to. Here is what I wrote to the list a few months ago about it: According to Remedy Support, creating an Archive Form for the AR System Email Messages form causes a duplication of the reserved fields used by the email engine to send email. Apparently the email engine was not setup to distinguish Field IDs such as 18085 between two separate forms. When I created an Archive form off the Email Messages form, the Email Engine decided that my Archived Email Messages form was the new form to process incoming and outgoing email on. This became somewhat amusing as Incoming email went directly to my Archive Form, and Outgoing email just sat in my original Email Messages form waiting to get processed. Removing the Archive form and restarting the Email Engine fixes the problem. (Embedded image moved to file: pic23851.gif)Countrywide James Van Sickle Remedy Developer II Enterprise Service Management 972-696-5779 Office 1000 Coit Road 92-540-5779Mail Stop: PCRD-2-19 Internal Plano, TX 75075 Nichols, Laura (Laura) [EMAIL PROTECTED] To Sent by: Action arslist@ARSLIST.ORG Request System cc discussion list(ARSList)Subject [EMAIL PROTECTED] Re: [ARSLIST] BMC Remedy - Copy to ORG Archive and Delete from Source - AR System Email Messages? 07/11/2008 12:06 PM Please respond to [EMAIL PROTECTED] RG ** Susan, Can you elaborate on your statement, I was also notified yesterday that it is not recommended to archive system email messages, there is some unusal result related to it.? Do you remember where you got this information? Are you still archiving your email messages? Anyone else heard or read anything on this?? Thanks, Laura From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Susan Palmer Sent: Wednesday, March 26, 2008 10:28 AM To: arslist@ARSLIST.ORG Subject: Re: BMC Remedy - Copy to Archive and Delete from Source ** Mel, I have found that for 'us' keeping less than 100k Help Tickets or Tasks in those forms keeps performance at an acceptable level. You have to remember that all workflow is affected by the number of records in the form and keep in mind any table fields that are refreshed. We generally keep 13 months of or closed records. Since we upgraded to v7.0.1P3 last year I was excited about the 'archive' option. In the last month I've used it on HTs, Tasks and email messages. For us it appears to require a huge amount of disk space for the copy/delete option. That needs to be planned for and it was greater than 1 for 1 which is logical since another table is now holding the same record. For us it was quite a bit more than that infact we nearly brought the server down. I only archive in the lowest of production hours (night) when minimal users are on the system. I was also notified yesterday that it is not recommended to archive system email messages, there is some unusal result related to it. Sorry did not get more info. I found the actual archiving to go fairly quick, was doing about 70k records both times. I liked the fact I didn't have to manually delete the records afterwards. hth, Susan ShopperTrak __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ == Confidentiality Notice: The information contained in and transmitted with this communication is strictly confidential
Re: BMC Remedy - Copy to Archive and Delete from Source - AR System Email Messages?
Just to share the other side We started archiving 09/2006 while on ARS 6.0.1, patch 1497. We're now running 7.0.1, patch 7 (on Solaris 5.10, Oracle 10g). We archive all Sent messages, using Archive Type Copy to Archive and Delete from Source, daily @ 0700. We've never had a problem with it. Several years ago, we tried to archive user logins as we removed them and ran into a reserved field id issue that sounds similar to what James described. We just haven't seen it on our email form. Mike White Office: 813-978-2192 E-mail: [EMAIL PROTECTED] James Van Sickle [EMAIL PROTECTED]To: arslist@ARSLIST.ORG RYWIDE.COMcc: Sent by: Action Subject: Re: BMC Remedy - Copy to Archive and Delete from Source - AR System Request System Email Messages? discussion list(ARSList) arslist@ARSLIST.ORG 07/11/2008 13:28 Please respond to arslist Laura I tried to setup an Archive form for the Email Messages form a while ago, and ran into the unusual activity that Susan was referring to. Here is what I wrote to the list a few months ago about it: According to Remedy Support, creating an Archive Form for the AR System Email Messages form causes a duplication of the reserved fields used by the email engine to send email. Apparently the email engine was not setup to distinguish Field IDs such as 18085 between two separate forms. When I created an Archive form off the Email Messages form, the Email Engine decided that my Archived Email Messages form was the new form to process incoming and outgoing email on. This became somewhat amusing as Incoming email went directly to my Archive Form, and Outgoing email just sat in my original Email Messages form waiting to get processed. Removing the Archive form and restarting the Email Engine fixes the problem. (Embedded image moved to file: pic23851.gif)Countrywide James Van Sickle Remedy Developer II Enterprise Service Management 972-696-5779 Office 1000 Coit Road 92-540-5779Mail Stop: PCRD-2-19 Internal Plano, TX 75075 Nichols, Laura (Laura) [EMAIL PROTECTED] To Sent by: Action arslist@ARSLIST.ORG Request System cc discussion list(ARSList)Subject [EMAIL PROTECTED] Re: [ARSLIST] BMC Remedy - Copy to ORG Archive and Delete from Source - AR System Email Messages? 07/11/2008 12:06 PM Please respond to [EMAIL PROTECTED] RG ** Susan, Can you elaborate on your statement, I was also notified yesterday that it is not recommended to archive system email messages, there is some unusal result related to it.? Do you remember where you got this information? Are you still archiving your email messages? Anyone else heard or read anything on this?? Thanks, Laura From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Susan Palmer Sent: Wednesday, March 26, 2008 10:28 AM To: arslist@ARSLIST.ORG Subject: Re: BMC Remedy - Copy to Archive and Delete from Source ** Mel, I have found that for 'us' keeping less than 100k Help Tickets or Tasks in those forms keeps performance at an acceptable level. You have to remember that all workflow is affected by the number of records in the form and keep in mind any table fields that are refreshed. We generally keep 13 months of or closed records. Since we upgraded to v7.0.1P3 last year I was excited about the 'archive' option. In the last month I've used it on HTs, Tasks and email messages. For us it appears to require a huge amount of disk space for the copy/delete option. That needs to be planned for and it was greater than 1 for 1 which is logical since another table is now holding the same record. For us it was quite a bit more than that infact we nearly
Re: BMC Remedy - Copy to Archive and Delete from Source - AR System Email Messages?
James and Mike, thanks for the quick responses. When our developer said he set up archiving I thought he meant he was archiving data to an archive form. When I looked at the form I saw that he had set the Archive type to Delete from Source, so we won't have an archive form after all... From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mike White Sent: Friday, July 11, 2008 12:35 PM To: arslist@ARSLIST.ORG Subject: Re: BMC Remedy - Copy to Archive and Delete from Source - AR System Email Messages? ** Just to share the other side We started archiving 09/2006 while on ARS 6.0.1, patch 1497. We're now running 7.0.1, patch 7 (on Solaris 5.10, Oracle 10g). We archive all Sent messages, using Archive Type Copy to Archive and Delete from Source, daily @ 0700. We've never had a problem with it. Several years ago, we tried to archive user logins as we removed them and ran into a reserved field id issue that sounds similar to what James described. We just haven't seen it on our email form. Mike White Office: 813-978-2192 E-mail: [EMAIL PROTECTED] James Van Sickle [EMAIL PROTECTED] James Van Sickle [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 07/11/2008 13:28 Please respond to arslist To: arslist@ARSLIST.ORG cc: Subject: Re: BMC Remedy - Copy to Archive and Delete from Source - AR System Email Messages? Laura I tried to setup an Archive form for the Email Messages form a while ago, and ran into the unusual activity that Susan was referring to. Here is what I wrote to the list a few months ago about it: According to Remedy Support, creating an Archive Form for the AR System Email Messages form causes a duplication of the reserved fields used by the email engine to send email. Apparently the email engine was not setup to distinguish Field IDs such as 18085 between two separate forms. When I created an Archive form off the Email Messages form, the Email Engine decided that my Archived Email Messages form was the new form to process incoming and outgoing email on. This became somewhat amusing as Incoming email went directly to my Archive Form, and Outgoing email just sat in my original Email Messages form waiting to get processed. Removing the Archive form and restarting the Email Engine fixes the problem. (Embedded image moved to file: pic23851.gif)Countrywide James Van Sickle Remedy Developer II Enterprise Service Management 972-696-5779 Office 1000 Coit Road 92-540-5779Mail Stop: PCRD-2-19 Internal Plano, TX 75075 Nichols, Laura (Laura) [EMAIL PROTECTED] To Sent by: Action arslist@ARSLIST.ORG Request System cc discussion list(ARSList) Subject [EMAIL PROTECTED] Re: [ARSLIST] BMC Remedy - Copy to ORG Archive and Delete from Source - AR System Email Messages? 07/11/2008 12:06 PM Please respond to [EMAIL PROTECTED] RG ** Susan, Can you elaborate on your statement, I was also notified yesterday that it is not recommended to archive system email messages, there is some unusal result related to it.? Do you remember where you got this information? Are you still archiving your email messages? Anyone else heard or read anything on this?? Thanks, Laura From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Susan Palmer Sent: Wednesday, March 26, 2008 10:28 AM To: arslist@ARSLIST.ORG Subject: Re: BMC Remedy - Copy to Archive and Delete from Source ** Mel, I have found that for 'us' keeping less than 100k Help Tickets or Tasks in those forms keeps performance at an acceptable level. You have to remember that all workflow is affected by the number of records in the form and keep in mind any table fields that are refreshed. We generally keep 13 months of or closed records. Since we upgraded to v7.0.1P3 last year I was excited about the 'archive' option. In the last month I've used it on HTs, Tasks and email messages. For us it appears
Re: BMC Remedy - Copy to Archive and Delete from Source
in my environment. Hence I went for Copy to Archive Option and deleted the data manually. I have raised this issue wi= th BMC. But as usual I didn't get a proper response. Thanks Regards, Thivagar Sankaran ITIL =96 Foundataion Certified Remedy Developer -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Melanie Snayer *Sent:* Wednesday, March 26, 2008 2:44 PM *To:* arslist@ARSLIST.ORG *Subject:* BMC Remedy - Copy to Archive and Delete from Source ** Hi Listeners We're experiencing performance issues especially when submitting incidents. Our initial plan was to archive calls that have been closed fo= r more than 5 years but as a result of the performance issues we're having = to considering archiving as soon as 1 year and 6 months after having gone-li= ve. Well, archiving is just one of the options that we have resorted to along side the current ongoing perfomance tuning that we're doing. Can you guys give me examples of how you may have gone about archiving your data? Like what the archiving criteria is and whether your archiving was done as a result of performance issue or as standard procedure. Thanks Mel __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are --=_Part_6872_1105761.1206524742321 Content-Type: text/html; charset=WINDOWS-1252 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline ** divHey Thivagar/div divnbsp;/div divWe arenbsp;in a 7.01 environment but I#39;m glad to know that this i= mproved on performance. Could you perhaps give me a rough indication of the= followingnbsp;information:/div ul liwhat your database size is/li linumber of records before the archive/li litime taken to save a call before the archive/li linumber of records after the archive/li litime taken to save a call afternbsp;the archive/li/ul divAnyone else like to share a bit of their archiving info with me?/div divnbsp;/div divRegards/div divMel/div divnbsp;/div divspan class=3Dgmail_quoteOn 3/26/08, b class=3Dgmail_sendername= Thivagar Sankaran/b lt;a href=3D mailto:[EMAIL PROTECTED] m[EMAIL PROTECTED]/agt; wrote:/span/div blockquote class=3Dgmail_quote style=3DPADDING-LEFT: 1ex; MARGIN: 0px 0= px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid**=20 div lang=3DEN-US vlink=3Dpurple link=3Dblue div div pfont face=3DArial color=3Dnavy size=3D2span style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: ArialHi Mel,/span/font/p pfont face=3DArial color=3Dnavy size=3D2span style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: Arialnbsp;/span/font/p pfont face=3DArial color=3Dnavy size=3D2span style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: ArialRecently I have archived the data i= n my 6.3 environment. I have done this to improve the performance and I obs= erve the performance has been improved considerably. But the issue was, the= /span/fontfont face=3DArial color=3Dnavy size=3D2span style= =3DFONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: ArialCopy to Archive and D= elete from Source option was not working in my environment. Hence I went fo= r Copy to Archive Option and deleted the data manually. I have raised this = issue with BMC. But as usual I didn't get a proper response./span/font= /p pfont face=3DArial color=3Dnavy size=3D2span style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: Arialnbsp;/span/font/p pfont face=3DArial color=3Dnavy size=3D2span style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: ArialThanks amp; Regards,/span/font= /p pfont face=3DArial color=3Dnavy size=3D2span style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: ArialThivagar Sankaran/span/font/p pfont face=3DArial color=3Dnavy size=3D2span style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: ArialITIL =96 Foundataion Certified/spa= n/font/p pfont face=3DArial color=3Dnavy size=3D2span style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: ArialRemedy Developer/span/font/p= /div pfont face=3DArial color=3Dnavy size=3D2span style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: Arialnbsp;/span/font/p div div style=3DTEXT-ALIGN: center align=3Dcenterfont face=3DTimes New = Roman size=3D3span
Re: BMC Remedy - Copy to Archive and Delete from Source
was not working in my environment. Hence I went for Copy to Archive Option and deleted the data manually. I have raised this issue wi= th BMC. But as usual I didn't get a proper response. Thanks Regards, Thivagar Sankaran ITIL =96 Foundataion Certified Remedy Developer -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Melanie Snayer *Sent:* Wednesday, March 26, 2008 2:44 PM *To:* arslist@ARSLIST.ORG *Subject:* BMC Remedy - Copy to Archive and Delete from Source ** Hi Listeners We're experiencing performance issues especially when submitting incidents. Our initial plan was to archive calls that have been closed fo= r more than 5 years but as a result of the performance issues we're having = to considering archiving as soon as 1 year and 6 months after having gone-li= ve. Well, archiving is just one of the options that we have resorted to along side the current ongoing perfomance tuning that we're doing. Can you guys give me examples of how you may have gone about archiving your data? Like what the archiving criteria is and whether your archiving was done as a result of performance issue or as standard procedure. Thanks Mel __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are --=_Part_6872_1105761.1206524742321 Content-Type: text/html; charset=WINDOWS-1252 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline ** Hey Thivagar We are in a 7.01 environment but I'm glad to know that this i= mproved on performance. Could you perhaps give me a rough indication of the= following information: - what your database size is - number of records before the archive - time taken to save a call before the archive - number of records after the archive - time taken to save a call after the archive Anyone else like to share a bit of their archiving info with me? Regards Mel On 3/26/08, * class=3Dgmail_sendername= Thivagar Sankaran* mailto:[EMAIL PROTECTED] m[EMAIL PROTECTED] http://3d%22%3cbr/ wrote: 0= px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid**=20 style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: ArialHi Mel, style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: Arial style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: ArialRecently I have archived the data i= n my 6.3 environment. I have done this to improve the performance and I obs= erve the performance has been improved considerably. But the issue was, the= =3DFONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: ArialCopy to Archive and D= elete from Source option was not working in my environment. Hence I went fo= r Copy to Archive Option and deleted the data manually. I have raised this = issue with BMC. But as usual I didn't get a proper response.= /p style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: Arial style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: ArialThanks Regards,= style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: ArialThivagar Sankaran style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: ArialITIL =96 Foundataion Certified n style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: ArialRemedy Developer = /div style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: Arial = Roman size=3D3 -- * FO= NT-SIZE: 10pt; FONT-FAMILY: TahomaFrom:* face=3DTa= homa size=3D2 Acti= on Request System discussion list(ARSList) [mailto:top= .js.OpenExtLink(window,event,this) href=3Dmailto:arslist@ARSLIST.ORG; tar= get=3D_blank[EMAIL PROTECTED] *bold= On Behalf Of *Melanie Snayer *Sent:* Wednesday, March 26, = 2008 2:44 PM *To:* oncl= ick=3Dreturn top.js.OpenExtLink(window,event,this) href=3D mailto:arslist= @ARSLIST.ORG target=3D_blankarslist@ARSLIST.ORG *Subject:* BMC Remedy - Copy = to Archive and Delete from Source 12pt= 12pt= ** style=3DFONT-SIZ= E: 10pt; COLOR: black; FONT-FAMILY: TahomaHi Listeners = /div 12pt= FONT-FA= MILY: TahomaWe're experiencing performance issues especiallynbs= p;when submitting incidents. Our initial plan was to archive call= s that have been closed for more than 5 years but as a result of the perfor= mance issues we're having to considering archiving as soon as = ;1 year and 6 months after having gone-live. Well, archiving is just one of= the options that we have resorted to along side the current ongoing perfom= ance tuning that we're doing. 12pt= FONT-FA= MILY: TahomaCan you guys give me examples of how you may
BMC Remedy - Copy to Archive and Delete from Source
Hi Listeners We're experiencing performance issues especially when submitting incidents. Our initial plan was to archive calls that have been closed for more than 5 years but as a result of the performance issues we're having to considering archiving as soon as 1 year and 6 months after having gone-live. Well, archiving is just one of the options that we have resorted to along side the current ongoing perfomance tuning that we're doing. Can you guys give me examples of how you may have gone about archiving your data? Like what the archiving criteria is and whether your archiving was done as a result of performance issue or as standard procedure. Thanks Mel ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: BMC Remedy - Copy to Archive and Delete from Source
Hey Thivagar We are in a 7.01 environment but I'm glad to know that this improved on performance. Could you perhaps give me a rough indication of the following information: - what your database size is - number of records before the archive - time taken to save a call before the archive - number of records after the archive - time taken to save a call after the archive Anyone else like to share a bit of their archiving info with me? Regards Mel On 3/26/08, Thivagar Sankaran [EMAIL PROTECTED] wrote: ** Hi Mel, Recently I have archived the data in my 6.3 environment. I have done this to improve the performance and I observe the performance has been improved considerably. But the issue was, the Copy to Archive and Delete from Source option was not working in my environment. Hence I went for Copy to Archive Option and deleted the data manually. I have raised this issue with BMC. But as usual I didn't get a proper response. Thanks Regards, Thivagar Sankaran ITIL – Foundataion Certified Remedy Developer -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Melanie Snayer *Sent:* Wednesday, March 26, 2008 2:44 PM *To:* arslist@ARSLIST.ORG *Subject:* BMC Remedy - Copy to Archive and Delete from Source ** Hi Listeners We're experiencing performance issues especially when submitting incidents. Our initial plan was to archive calls that have been closed for more than 5 years but as a result of the performance issues we're having to considering archiving as soon as 1 year and 6 months after having gone-live. Well, archiving is just one of the options that we have resorted to along side the current ongoing perfomance tuning that we're doing. Can you guys give me examples of how you may have gone about archiving your data? Like what the archiving criteria is and whether your archiving was done as a result of performance issue or as standard procedure. Thanks Mel __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: BMC Remedy - Copy to Archive and Delete from Source
Hi All I am having a similar problem with the Copy to Archive and Delete from Source. I set up the archive form and at first the archiving worked fine. Then I made some changes to the main form and the archiving stopped and the archive tab information is no blank. I tried to start up the archiving again and got the error that the archive form was not valid. I understood that changes to the main form would carryover the the archive. Well they did not. ARS 6.3 patch 20 SunOS 5.9 Oracle 9.2.0.7 Anybody have any ideas? Thanks Mark From: Action Request System discussion list(ARSList) on behalf of Thivagar Sankaran Sent: Wed 3/26/2008 5:25 AM To: arslist@ARSLIST.ORG Subject: Re: BMC Remedy - Copy to Archive and Delete from Source ** Hi Mel, Recently I have archived the data in my 6.3 environment. I have done this to improve the performance and I observe the performance has been improved considerably. But the issue was, the Copy to Archive and Delete from Source option was not working in my environment. Hence I went for Copy to Archive Option and deleted the data manually. I have raised this issue with BMC. But as usual I didn't get a proper response. Thanks Regards, Thivagar Sankaran ITIL - Foundataion Certified Remedy Developer From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Melanie Snayer Sent: Wednesday, March 26, 2008 2:44 PM To: arslist@ARSLIST.ORG Subject: BMC Remedy - Copy to Archive and Delete from Source ** Hi Listeners We're experiencing performance issues especially when submitting incidents. Our initial plan was to archive calls that have been closed for more than 5 years but as a result of the performance issues we're having to considering archiving as soon as 1 year and 6 months after having gone-live. Well, archiving is just one of the options that we have resorted to along side the current ongoing perfomance tuning that we're doing. Can you guys give me examples of how you may have gone about archiving your data? Like what the archiving criteria is and whether your archiving was done as a result of performance issue or as standard procedure. Thanks Mel __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: BMC Remedy - Copy to Archive and Delete from Source
Mel, We're running 7.0.1 with ITSM 6. We instituted archiving a little over a month ago, it was sorely needed, and it certainly has made a difference. Since Remedy was put into production back in the summer of 2004, approx 390,000 tickets had been submitted. The amount of tickets had not been a problem until recently when we began to see performance lags performing various actions in Remedy. Opening an existing Help Desk ticket from the Remedy Support console alone was taking anywhere from 1 to 5 seconds depending on the ticket (API and SQL logs were very helpful here). We decided to archive all Help Desk tickets with a status of Closed that were older than 13 months. We considered using Remedy's archiving feature, but eventually went with Misi Mladoniczky's rrrchive utility. Since our lab testing indicated that the archiving of an estimated 250,000 tickets would take about 6 to 7 hours (and slow the system down tremendously), we decided to archive in chunks of 40,000 which limited the performance pain to about an hour. We did this for 7 nights in a row. I can tell you that since, performance has improved tremendously (max time to open an existing ticket is about a second). Archiving is done nightly now. It takes a minute to archive the 400 to 500 tickets that meet the archive criteria. I know that my users are happy. Joe Joseph Kasell Navy Federal Credit Union Melanie Snayer [EMAIL PROTECTED] MAIL.COM To Sent by: Action arslist@ARSLIST.ORG Request System cc discussion list(ARSList)Subject [EMAIL PROTECTED] Re: BMC Remedy - Copy to Archive ORG and Delete from Source 03/26/2008 05:45 AM Please respond to [EMAIL PROTECTED] RG --=_Part_6872_1105761.1206524742321 Content-Type: text/plain; charset=WINDOWS-1252 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hey Thivagar We are in a 7.01 environment but I'm glad to know that this improved on performance. Could you perhaps give me a rough indication of the following information: - what your database size is - number of records before the archive - time taken to save a call before the archive - number of records after the archive - time taken to save a call after the archive Anyone else like to share a bit of their archiving info with me? Regards Mel On 3/26/08, Thivagar Sankaran [EMAIL PROTECTED] wrote: ** Hi Mel, Recently I have archived the data in my 6.3 environment. I have done this to improve the performance and I observe the performance has been improve= d considerably. But the issue was, the Copy to Archive and Delete from Source option was not working in my environment. Hence I went for Copy to Archive Option and deleted the data manually. I have raised this issue wi= th BMC. But as usual I didn't get a proper response. Thanks Regards, Thivagar Sankaran ITIL =96 Foundataion Certified Remedy Developer -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Melanie Snayer *Sent:* Wednesday, March 26, 2008 2:44 PM *To:* arslist@ARSLIST.ORG *Subject:* BMC Remedy - Copy to Archive and Delete from Source ** Hi Listeners We're experiencing performance issues especially when submitting incidents. Our initial plan was to archive calls that have been closed fo= r more than 5 years but as a result of the performance issues we're having = to considering archiving as soon as 1 year and 6 months after having gone-li= ve. Well, archiving is just one of the options that we have resorted to along side the current ongoing perfomance tuning that we're doing. Can you guys give me
Re: BMC Remedy - Copy to Archive and Delete from Source
Hi Joe Thanks so much for this information. Would you perhaps be able to tell me whether there was a delay on saving Help Desk tickets before you archived? Regards Mel On 3/26/08, Joseph Kasell [EMAIL PROTECTED] wrote: Mel, We're running 7.0.1 with ITSM 6. We instituted archiving a little over a month ago, it was sorely needed, and it certainly has made a difference. Since Remedy was put into production back in the summer of 2004, approx 390,000 tickets had been submitted. The amount of tickets had not been a problem until recently when we began to see performance lags performing various actions in Remedy. Opening an existing Help Desk ticket from the Remedy Support console alone was taking anywhere from 1 to 5 seconds depending on the ticket (API and SQL logs were very helpful here). We decided to archive all Help Desk tickets with a status of Closed that were older than 13 months. We considered using Remedy's archiving feature, but eventually went with Misi Mladoniczky's rrrchive utility. Since our lab testing indicated that the archiving of an estimated 250,000 tickets would take about 6 to 7 hours (and slow the system down tremendously), we decided to archive in chunks of 40,000 which limited the performance pain to about an hour. We did this for 7 nights in a row. I can tell you that since, performance has improved tremendously (max time to open an existing ticket is about a second). Archiving is done nightly now. It takes a minute to archive the 400 to 500 tickets that meet the archive criteria. I know that my users are happy. Joe Joseph Kasell Navy Federal Credit Union Melanie Snayer [EMAIL PROTECTED] MAIL.COM To Sent by: Action arslist@ARSLIST.ORG Request System cc discussion list(ARSList)Subject [EMAIL PROTECTED] Re: BMC Remedy - Copy to Archive ORG and Delete from Source 03/26/2008 05:45 AM Please respond to [EMAIL PROTECTED] RG --=_Part_6872_1105761.1206524742321 Content-Type: text/plain; charset=WINDOWS-1252 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hey Thivagar We are in a 7.01 environment but I'm glad to know that this improved on performance. Could you perhaps give me a rough indication of the following information: - what your database size is - number of records before the archive - time taken to save a call before the archive - number of records after the archive - time taken to save a call after the archive Anyone else like to share a bit of their archiving info with me? Regards Mel On 3/26/08, Thivagar Sankaran [EMAIL PROTECTED] wrote: ** Hi Mel, Recently I have archived the data in my 6.3 environment. I have done this to improve the performance and I observe the performance has been improve= d considerably. But the issue was, the Copy to Archive and Delete from Source option was not working in my environment. Hence I went for Copy to Archive Option and deleted the data manually. I have raised this issue wi= th BMC. But as usual I didn't get a proper response. Thanks Regards, Thivagar Sankaran ITIL =96 Foundataion Certified Remedy Developer -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Melanie Snayer *Sent:* Wednesday, March 26, 2008 2:44 PM *To:* arslist@ARSLIST.ORG *Subject:* BMC Remedy - Copy to Archive and Delete from Source ** Hi Listeners We're experiencing performance issues especially when submitting incidents. Our initial plan was to archive calls that have been closed fo= r more than 5 years but as a result of the performance issues we're having = to considering archiving as soon as 1 year and 6 months after having gone-li= ve. Well, archiving is just one of the options that we have resorted to along side the current ongoing perfomance tuning that we're doing. Can you guys give me examples of how you may have gone about archiving your data? Like what the archiving criteria is and whether your archiving was done as a result of performance issue or as standard procedure. Thanks Mel __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers
Re: BMC Remedy - Copy to Archive and Delete from Source
environment. I have done this to improve the performance and I observe the performance has been improve= d considerably. But the issue was, the Copy to Archive and Delete from Source option was not working in my environment. Hence I went for Copy to Archive Option and deleted the data manually. I have raised this issue wi= th BMC. But as usual I didn't get a proper response. Thanks Regards, Thivagar Sankaran ITIL =96 Foundataion Certified Remedy Developer -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Melanie Snayer *Sent:* Wednesday, March 26, 2008 2:44 PM *To:* arslist@ARSLIST.ORG *Subject:* BMC Remedy - Copy to Archive and Delete from Source ** Hi Listeners We're experiencing performance issues especially when submitting incidents. Our initial plan was to archive calls that have been closed fo= r more than 5 years but as a result of the performance issues we're having = to considering archiving as soon as 1 year and 6 months after having gone-li= ve. Well, archiving is just one of the options that we have resorted to along side the current ongoing perfomance tuning that we're doing. Can you guys give me examples of how you may have gone about archiving your data? Like what the archiving criteria is and whether your archiving was done as a result of performance issue or as standard procedure. Thanks Mel __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are --=_Part_6872_1105761.1206524742321 Content-Type: text/html; charset=WINDOWS-1252 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline ** divHey Thivagar/div divnbsp;/div divWe arenbsp;in a 7.01 environment but I#39;m glad to know that this i= mproved on performance. Could you perhaps give me a rough indication of the= followingnbsp;information:/div ul liwhat your database size is/li linumber of records before the archive/li litime taken to save a call before the archive/li linumber of records after the archive/li litime taken to save a call afternbsp;the archive/li/ul divAnyone else like to share a bit of their archiving info with me?/div divnbsp;/div divRegards/div divMel/div divnbsp;/div divspan class=3Dgmail_quoteOn 3/26/08, b class=3Dgmail_sendername= Thivagar Sankaran/b lt;a href=3D mailto:[EMAIL PROTECTED] m[EMAIL PROTECTED]/agt; wrote:/span/div blockquote class=3Dgmail_quote style=3DPADDING-LEFT: 1ex; MARGIN: 0px 0= px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid**=20 div lang=3DEN-US vlink=3Dpurple link=3Dblue div div pfont face=3DArial color=3Dnavy size=3D2span style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: ArialHi Mel,/span/font/p pfont face=3DArial color=3Dnavy size=3D2span style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: Arialnbsp;/span/font/p pfont face=3DArial color=3Dnavy size=3D2span style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: ArialRecently I have archived the data i= n my 6.3 environment. I have done this to improve the performance and I obs= erve the performance has been improved considerably. But the issue was, the= /span/fontfont face=3DArial color=3Dnavy size=3D2span style= =3DFONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: ArialCopy to Archive and D= elete from Source option was not working in my environment. Hence I went fo= r Copy to Archive Option and deleted the data manually. I have raised this = issue with BMC. But as usual I didn't get a proper response./span/font= /p pfont face=3DArial color=3Dnavy size=3D2span style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: Arialnbsp;/span/font/p pfont face=3DArial color=3Dnavy size=3D2span style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: ArialThanks amp; Regards,/span/font= /p pfont face=3DArial color=3Dnavy size=3D2span style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: ArialThivagar Sankaran/span/font/p pfont face=3DArial color=3Dnavy size=3D2span style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: ArialITIL =96 Foundataion Certified/spa= n/font/p pfont face=3DArial color=3Dnavy size=3D2span style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: ArialRemedy Developer/span/font/p= /div pfont face=3DArial color=3Dnavy size=3D2span style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: Arialnbsp;/span/font/p div div style=3DTEXT-ALIGN: center align=3Dcenterfont face=3DTimes New = Roman size=3D3span style=3DFONT-SIZE: 12pt hr align=3Dcenter width=3D100% size=3D2 /span/font/div pbfont face=3DTahoma size=3D2span style=3DFONT-WEIGHT: bold; FO= NT-SIZE: 10pt
Re: BMC Remedy - Copy to Archive and Delete from Source
-- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Melanie Snayer *Sent:* Wednesday, March 26, 2008 2:44 PM *To:* arslist@ARSLIST.ORG *Subject:* BMC Remedy - Copy to Archive and Delete from Source ** Hi Listeners We're experiencing performance issues especially when submitting incidents. Our initial plan was to archive calls that have been closed fo= r more than 5 years but as a result of the performance issues we're having = to considering archiving as soon as 1 year and 6 months after having gone-li= ve. Well, archiving is just one of the options that we have resorted to along side the current ongoing perfomance tuning that we're doing. Can you guys give me examples of how you may have gone about archiving your data? Like what the archiving criteria is and whether your archiving was done as a result of performance issue or as standard procedure. Thanks Mel __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are --=_Part_6872_1105761.1206524742321 Content-Type: text/html; charset=WINDOWS-1252 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline ** divHey Thivagar/div divnbsp;/div divWe arenbsp;in a 7.01 environment but I#39;m glad to know that this i= mproved on performance. Could you perhaps give me a rough indication of the= followingnbsp;information:/div ul liwhat your database size is/li linumber of records before the archive/li litime taken to save a call before the archive/li linumber of records after the archive/li litime taken to save a call afternbsp;the archive/li/ul divAnyone else like to share a bit of their archiving info with me?/div divnbsp;/div divRegards/div divMel/div divnbsp;/div divspan class=3Dgmail_quoteOn 3/26/08, b class=3Dgmail_sendername= Thivagar Sankaran/b lt;a href=3D mailto:[EMAIL PROTECTED] m[EMAIL PROTECTED]/agt; wrote:/span/div blockquote class=3Dgmail_quote style=3DPADDING-LEFT: 1ex; MARGIN: 0px 0= px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid**=20 div lang=3DEN-US vlink=3Dpurple link=3Dblue div div pfont face=3DArial color=3Dnavy size=3D2span style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: ArialHi Mel,/span/font/p pfont face=3DArial color=3Dnavy size=3D2span style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: Arialnbsp;/span/font/p pfont face=3DArial color=3Dnavy size=3D2span style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: ArialRecently I have archived the data i= n my 6.3 environment. I have done this to improve the performance and I obs= erve the performance has been improved considerably. But the issue was, the= /span/fontfont face=3DArial color=3Dnavy size=3D2span style= =3DFONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: ArialCopy to Archive and D= elete from Source option was not working in my environment. Hence I went fo= r Copy to Archive Option and deleted the data manually. I have raised this = issue with BMC. But as usual I didn't get a proper response./span/font= /p pfont face=3DArial color=3Dnavy size=3D2span style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: Arialnbsp;/span/font/p pfont face=3DArial color=3Dnavy size=3D2span style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: ArialThanks amp; Regards,/span/font= /p pfont face=3DArial color=3Dnavy size=3D2span style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: ArialThivagar Sankaran/span/font/p pfont face=3DArial color=3Dnavy size=3D2span style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: ArialITIL =96 Foundataion Certified/spa= n/font/p pfont face=3DArial color=3Dnavy size=3D2span style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: ArialRemedy Developer/span/font/p= /div pfont face=3DArial color=3Dnavy size=3D2span style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: Arialnbsp;/span/font/p div div style=3DTEXT-ALIGN: center align=3Dcenterfont face=3DTimes New = Roman size=3D3span style=3DFONT-SIZE: 12pt hr align=3Dcenter width=3D100% size=3D2 /span/font/div pbfont face=3DTahoma size=3D2span style=3DFONT-WEIGHT: bold; FO= NT-SIZE: 10pt; FONT-FAMILY: TahomaFrom:/span/font/bfont face=3DTa= homa size=3D2span style=3DFONT-SIZE: 10pt; FONT-FAMILY: Tahoma Acti= on Request System discussion list(ARSList) [mailto:a onclick=3Dreturn top= .js.OpenExtLink(window,event,this) href=3Dmailto:arslist@ARSLIST.ORG; tar= get=3D_blankarslist@ARSLIST.ORG/a] bspan style=3DFONT-WEIGHT: bold
Re: BMC Remedy - Copy to Archive and Delete from Source
that this improved on performance. Could you perhaps give me a rough indication of the following information: - what your database size is - number of records before the archive - time taken to save a call before the archive - number of records after the archive - time taken to save a call after the archive Anyone else like to share a bit of their archiving info with me? Regards Mel On 3/26/08, Thivagar Sankaran wrote: ** Hi Mel, Recently I have archived the data in my 6.3 environment. I have done this to improve the performance and I observe the performance has been improve= d considerably. But the issue was, the Copy to Archive and Delete from Source option was not working in my environment. Hence I went for Copy to Archive Option and deleted the data manually. I have raised this issue wi= th BMC. But as usual I didn't get a proper response. Thanks Regards, Thivagar Sankaran ITIL =96 Foundataion Certified Remedy Developer -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Melanie Snayer *Sent:* Wednesday, March 26, 2008 2:44 PM *To:* arslist@ARSLIST.ORG *Subject:* BMC Remedy - Copy to Archive and Delete from Source ** Hi Listeners We're experiencing performance issues especially when submitting incidents. Our initial plan was to archive calls that have been closed fo= r more than 5 years but as a result of the performance issues we're having = to considering archiving as soon as 1 year and 6 months after having gone-li= ve. Well, archiving is just one of the options that we have resorted to along side the current ongoing perfomance tuning that we're doing. Can you guys give me examples of how you may have gone about archiving your data? Like what the archiving criteria is and whether your archiving was done as a result of performance issue or as standard procedure. Thanks Mel __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are --=_Part_6872_1105761.1206524742321 Content-Type: text/html; charset=WINDOWS-1252 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline ** Hey Thivagar We are in a 7.01 environment but I'm glad to know that this i= mproved on performance. Could you perhaps give me a rough indication of the= following information: what your database size is number of records before the archive time taken to save a call before the archive number of records after the archive time taken to save a call after the archive Anyone else like to share a bit of their archiving info with me? Regards Mel On 3/26/08, class=3Dgmail_sendername= Thivagar Sankaran mailto:[EMAIL PROTECTED] m[EMAIL PROTECTED] wrote: 0= px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid**=20 style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: ArialHi Mel, style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: Arial style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: ArialRecently I have archived the data i= n my 6.3 environment. I have done this to improve the performance and I obs= erve the performance has been improved considerably. But the issue was, the= =3DFONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: ArialCopy to Archive and D= elete from Source option was not working in my environment. Hence I went fo= r Copy to Archive Option and deleted the data manually. I have raised this = issue with BMC. But as usual I didn't get a proper response.= /p style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: Arial style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: ArialThanks Regards,= style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: ArialThivagar Sankaran style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: ArialITIL =96 Foundataion Certified n style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: ArialRemedy Developer = /div style=3DFONT-SIZE:= 10pt; COLOR: navy; FONT-FAMILY: Arial = Roman size=3D3 - FO= NT-SIZE: 10pt; FONT-FAMILY: TahomaFrom: face=3DTa= homa size=3D2 Acti= on Request System discussion list(ARSList) [mailto:top= .js.OpenExtLink(window,event,this) href=3Dmailto:arslist@ARSLIST.ORG; tar= get=3D_blank[EMAIL PROTECTED] bold= On Behalf Of Melanie Snayer Sent: Wednesday, March 26, = 2008 2:44 PM To: oncl= ick=3Dreturn top.js.OpenExtLink(window,event,this) href=3D mailto:arslist= @ARSLIST.ORG target=3D_blankarslist@ARSLIST.ORG Subject: BMC Remedy - Copy = to Archive and Delete from Source 12pt= 12pt= ** style=3DFONT-SIZ= E: 10pt; COLOR: black; FONT-FAMILY: TahomaHi Listeners = /div 12pt= FONT-FA= MILY: TahomaWe're experiencing performance
Re: BMC Remedy - Copy to Archive and Delete from Source
Joe,
Properly indexed and tuned 400,000 tickets on a form shouldn't be a
problem. To expand on what Susan indicated, nine times out of ten, the
biggest cause of slowness when opening forms is table fields that are
needlessly being refreshed. Watch out for tables being refreshed on
hidden tabs. Have an active link that fires on Gain Focus (of that tab)
AND also on Display, with a run if of ('Page Holder' = Tab Name'). The
one action would be the table refresh.
Of course there are other causes for slowness on opening of forms, but
I've found this is the most common, and typically the easiest to fix. (oh,
and be suspect of any active link that fires on all three of Window Open,
Window Loaded, and Display - its probably running three times when you
display a ticket).
Thad Esser
Remedy Developer
Argue for your limitations, and sure enough, they're yours.-- Richard
Bach
Susan Palmer [EMAIL PROTECTED]
Sent by: Action Request System discussion list(ARSList)
arslist@ARSLIST.ORG
03/26/2008 08:27 AM
Please respond to
arslist@ARSLIST.ORG
To
arslist@ARSLIST.ORG
cc
Subject
Re: BMC Remedy - Copy to Archive and Delete from Source
**
Mel,
I have found that for 'us' keeping less than 100k Help Tickets or Tasks in
those forms keeps performance at an acceptable level. You have to
remember that all workflow is affected by the number of records in the
form and keep in mind any table fields that are refreshed.
We generally keep 13 months of or closed records.
Since we upgraded to v7.0.1P3 last year I was excited about the 'archive'
option. In the last month I've used it on HTs, Tasks and email messages.
For us it appears to require a huge amount of disk space for the
copy/delete option. That needs to be planned for and it was greater than
1 for 1 which is logical since another table is now holding the same
record. For us it was quite a bit more than that infact we nearly brought
the server down.
I only archive in the lowest of production hours (night) when minimal
users are on the system.
I was also notified yesterday that it is not recommended to archive system
email messages, there is some unusal result related to it. Sorry did not
get more info.
I found the actual archiving to go fairly quick, was doing about 70k
records both times. I liked the fact I didn't have to manually delete the
records afterwards.
hth,
Susan
ShopperTrak
On Wed, Mar 26, 2008 at 8:28 AM, Melanie Snayer [EMAIL PROTECTED]
wrote:
**
Hi Joe
Thanks so much for this information. Would you perhaps be able to tell me
whether there was a delay on saving Help Desk tickets before you archived?
Regards
Mel
On 3/26/08, Joseph Kasell [EMAIL PROTECTED] wrote:
Mel,
We're running 7.0.1 with ITSM 6. We instituted archiving a little over a
month ago, it was sorely needed, and it certainly has made a difference.
Since Remedy was put into production back in the summer of 2004, approx
390,000 tickets had been submitted. The amount of tickets had not been a
problem until recently when we began to see performance lags performing
various actions in Remedy. Opening an existing Help Desk ticket from the
Remedy Support console alone was taking anywhere from 1 to 5 seconds
depending on the ticket (API and SQL logs were very helpful here).
We decided to archive all Help Desk tickets with a status of Closed that
were older than 13 months. We considered using Remedy's archiving
feature,
but eventually went with Misi Mladoniczky's rrrchive utility. Since our
lab testing indicated that the archiving of an estimated 250,000 tickets
would take about 6 to 7 hours (and slow the system down tremendously), we
decided to archive in chunks of 40,000 which limited the performance pain
to about an hour. We did this for 7 nights in a row. I can tell you that
since, performance has improved tremendously (max time to open an existing
ticket is about a second). Archiving is done nightly now. It takes a
minute to archive the 400 to 500 tickets that meet the archive criteria. I
know that my users are happy.
Joe
Joseph Kasell
Navy Federal Credit Union
Melanie Snayer
[EMAIL PROTECTED]
MAIL.COM To
Sent by: Action arslist@ARSLIST.ORG
Request System cc
discussion
list(ARSList)Subject
[EMAIL PROTECTED] Re: BMC Remedy - Copy to Archive
ORG and Delete from Source
03/26/2008 05:45
AM
Please respond to
[EMAIL PROTECTED]
RG
--=_Part_6872_1105761.1206524742321
Content-Type: text/plain; charset=WINDOWS-1252
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Hey Thivagar
We are in a 7.01 environment but I'm glad to know that this improved
Re: BMC Remedy - Copy to Archive and Delete from Source
In response to Susan's comments about archiving the AR System Email
Messages form:
According to Remedy Support, creating an Archive Form for the AR System
Email Messages form causes a duplication of the reserved fields used by the
email engine to send email. Apparently the email engine was not setup to
distinguish Field IDs such as 18085 between two separate forms. When I
created an Archive form off the Email Messages form, the Email Engine
decided that my Archived Email Messages form was the new form to process
incoming and outgoing email on. This became somewhat amusing as Incoming
email went directly to my Archive Form, and Outgoing email just sat in my
original Email Messages form waiting to get processed.
Removing the Archive form and restarting the Email Engine fixes the
problem.
(Embedded image moved to file: pic14989.gif)Countrywide
James Van Sickle
Remedy Developer II
IT - Enterprise Change Config
972-696-5779 Office 1000 Coit Road
92-540-5779Mail Stop: PCRD-2-78
Internal Plano, TX 75075
Thad K Esser
[EMAIL PROTECTED]
COM To
Sent by: Action arslist@ARSLIST.ORG
Request System cc
discussion
list(ARSList)Subject
[EMAIL PROTECTED] Re: [ARSLIST] BMC Remedy - Copy to
ORG Archive and Delete from Source
03/26/2008 01:43
PM
Please respond to
[EMAIL PROTECTED]
RG
**
Joe,
Properly indexed and tuned 400,000 tickets on a form shouldn't be a
problem. To expand on what Susan indicated, nine times out of ten, the
biggest cause of slowness when opening forms is table fields that are
needlessly being refreshed. Watch out for tables being refreshed on hidden
tabs. Have an active link that fires on Gain Focus (of that tab) AND also
on Display, with a run if of ('Page Holder' = Tab Name'). The one action
would be the table refresh.
Of course there are other causes for slowness on opening of forms, but I've
found this is the most common, and typically the easiest to fix. (oh, and
be suspect of any active link that fires on all three of Window Open,
Window Loaded, and Display - its probably running three times when you
display a ticket).
Thad Esser
Remedy Developer
Argue for your limitations, and sure enough, they're yours.-- Richard
Bach
Susan Palmer [EMAIL PROTECTED]
Sent by: Action Request System
discussion list(ARSList) To
arslist@ARSLIST.ORG arslist@ARSLIST.ORG
cc
03/26/2008 08:27 AM Subject
Re: BMC Remedy - Copy
to Archive and Delete
Please respond to from Source
arslist@ARSLIST.ORG
Re: BMC Remedy - Copy to Archive and Delete from Source
Thad,
You bring up an excellent point regarding tables. Case in point in the
Requester's Cases table under the Requester Information tab on the Help
Desk form. Along with tickets reported by end-users we also have tickets
generated from Patrol, and all those tickets have the same Requester.
Needless to say there are a lot more of those tickets than those called-in
by our regular (i.e. - human) users. So when a ticket for that
particular Requester is opened from the Support Console, there is quite the
lag due to the query used to populate the Requester's Cases table. The
client SQL and API logs were a real eye-opener insofar as that was
concerned.
Joe
Joseph Kasell
Navy Federal Credit Union
Thad K Esser
[EMAIL PROTECTED]
COM To
Sent by: Action arslist@ARSLIST.ORG
Request System cc
discussion
list(ARSList)Subject
[EMAIL PROTECTED] Re: BMC Remedy - Copy to Archive
ORG and Delete from Source
03/26/2008 02:42
PM
Please respond to
[EMAIL PROTECTED]
RG
This is a multipart message in MIME format.
--=_alternative 0066B95B88257418_=
Content-Type: text/plain;
charset=us-ascii
Content-Transfer-Encoding: 7bit
Joe,
Properly indexed and tuned 400,000 tickets on a form shouldn't be a
problem. To expand on what Susan indicated, nine times out of ten, the
biggest cause of slowness when opening forms is table fields that are
needlessly being refreshed. Watch out for tables being refreshed on
hidden tabs. Have an active link that fires on Gain Focus (of that tab)
AND also on Display, with a run if of ('Page Holder' = Tab Name'). The
one action would be the table refresh.
Of course there are other causes for slowness on opening of forms, but
I've found this is the most common, and typically the easiest to fix. (oh,
and be suspect of any active link that fires on all three of Window Open,
Window Loaded, and Display - its probably running three times when you
display a ticket).
Thad Esser
Remedy Developer
Argue for your limitations, and sure enough, they're yours.-- Richard
Bach
Susan Palmer [EMAIL PROTECTED]
Sent by: Action Request System discussion list(ARSList)
arslist@ARSLIST.ORG
03/26/2008 08:27 AM
Please respond to
arslist@ARSLIST.ORG
To
arslist@ARSLIST.ORG
cc
Subject
Re: BMC Remedy - Copy to Archive and Delete from Source
**
Mel,
I have found that for 'us' keeping less than 100k Help Tickets or Tasks in
those forms keeps performance at an acceptable level. You have to
remember that all workflow is affected by the number of records in the
form and keep in mind any table fields that are refreshed.
We generally keep 13 months of or closed records.
Since we upgraded to v7.0.1P3 last year I was excited about the 'archive'
option. In the last month I've used it on HTs, Tasks and email messages.
For us it appears to require a huge amount of disk space for the
copy/delete option. That needs to be planned for and it was greater than
1 for 1 which is logical since another table is now holding the same
record. For us it was quite a bit more than that infact we nearly brought
the server down.
I only archive in the lowest of production hours (night) when minimal
users are on the system.
I was also notified yesterday that it is not recommended to archive system
email messages, there is some unusal result related to it. Sorry did not
get more info.
I found the actual archiving to go fairly quick, was doing about 70k
records both times. I liked the fact I didn't have to manually delete the
records afterwards.
hth,
Susan
ShopperTrak
On Wed, Mar 26, 2008 at 8:28 AM, Melanie Snayer [EMAIL PROTECTED]
wrote:
**
Hi Joe
Thanks so much for this information. Would you perhaps be able
Re: BMC Remedy - Copy to Archive and Delete from Source
Thanks for the info James, alot more detail than I had. I've deleted that
archive form!
Thanks,
Susan
On Wed, Mar 26, 2008 at 2:07 PM, James Van Sickle
[EMAIL PROTECTED] wrote:
In response to Susan's comments about archiving the AR System Email
Messages form:
According to Remedy Support, creating an Archive Form for the AR System
Email Messages form causes a duplication of the reserved fields used by
the
email engine to send email. Apparently the email engine was not setup to
distinguish Field IDs such as 18085 between two separate forms. When I
created an Archive form off the Email Messages form, the Email Engine
decided that my Archived Email Messages form was the new form to process
incoming and outgoing email on. This became somewhat amusing as Incoming
email went directly to my Archive Form, and Outgoing email just sat in my
original Email Messages form waiting to get processed.
Removing the Archive form and restarting the Email Engine fixes the
problem.
(Embedded image moved to file: pic14989.gif)Countrywide
James Van Sickle
Remedy Developer II
IT - Enterprise Change Config
972-696-5779 Office 1000 Coit Road
92-540-5779Mail Stop: PCRD-2-78
Internal Plano, TX 75075
Thad K Esser
[EMAIL PROTECTED]
COM To
Sent by: Action arslist@ARSLIST.ORG
Request System cc
discussion
list(ARSList)Subject
[EMAIL PROTECTED] Re: [ARSLIST] BMC Remedy - Copy to
ORG Archive and Delete from Source
03/26/2008 01:43
PM
Please respond to
[EMAIL PROTECTED]
RG
**
Joe,
Properly indexed and tuned 400,000 tickets on a form shouldn't be a
problem. To expand on what Susan indicated, nine times out of ten, the
biggest cause of slowness when opening forms is table fields that are
needlessly being refreshed. Watch out for tables being refreshed on
hidden
tabs. Have an active link that fires on Gain Focus (of that tab) AND also
on Display, with a run if of ('Page Holder' = Tab Name'). The one action
would be the table refresh.
Of course there are other causes for slowness on opening of forms, but
I've
found this is the most common, and typically the easiest to fix. (oh, and
be suspect of any active link that fires on all three of Window Open,
Window Loaded, and Display - its probably running three times when you
display a ticket).
Thad Esser
Remedy Developer
Argue for your limitations, and sure enough, they're yours.-- Richard
Bach
Susan Palmer [EMAIL PROTECTED]
Sent by: Action Request System
discussion list(ARSList) To
arslist@ARSLIST.ORG arslist@ARSLIST.ORG
cc
03/26/2008 08:27 AM Subject
Re: BMC Remedy - Copy
to Archive and Delete
Please respond to from Source
arslist@ARSLIST.ORG
**
Mel,
I have found that for 'us' keeping less than 100k Help Tickets or Tasks in
those forms keeps performance at an acceptable level. You have to
remember
that all workflow is affected by the number of records in the form and
keep
in mind any table fields that are refreshed.
We generally keep 13 months of or closed records.
Since we upgraded to v7.0.1P3 last year I was excited about the 'archive'
option. In the last month I've used it on HTs, Tasks and email messages.
For us it appears to require a huge amount of disk space for the
copy/delete option. That needs to be planned for and it was greater than
1
for 1 which is logical since another table is now holding the same record.
For us it was quite a bit more than that infact we nearly brought the
server down.
I only archive in the lowest of production hours (night) when minimal
users
are on the system.
I was also notified yesterday that it is not recommended to archive system
email messages, there is some unusal result related to it. Sorry did not
get more info.
I found the actual archiving to go fairly quick, was doing about 70k
records both times. I liked the fact I didn't have to manually delete the
records afterwards.
hth,
Susan
ShopperTrak
On Wed, Mar 26, 2008 at 8:28 AM, Melanie Snayer [EMAIL PROTECTED]
wrote:
**
Hi Joe
Thanks so much for this information. Would you perhaps be able to tell me
whether there was a delay on saving Help Desk tickets before you archived?
Regards
Mel
On 3/26/08, Joseph Kasell [EMAIL
Re: BMC Remedy - Copy to Archive and Delete from Source
The agreement that I have had with the user community at a few places I have worked is to always keep a full 12 months of Help Desk records. So by the time we are ready to do annual archiving we are close to 2 years worth (and some times we don't archive right at a year). This allows at least a full year reports at any time. We do roughly 180k Help Desk tickets a year. We archive the old fashion way of exporting an arx file and deleting the records. If there is ever a need to report on old records we will restore them in an another environment. On Help Desk usually most of reports don't go past 1 year and this keeps us from maintaining extra servers/cost/workflow to keep a reporting server. Another thing to keep in mind is what is an appropriate interval for the form you are archiving. You many not want to keep only a year of Change Requests or other forms that support policies and/or regulatory compliance. Maybe you want to keep 5 years for Change Request and never archive Account Requests and user system access records (both custom modules). HTH, Jason On Wed, Mar 26, 2008 at 2:13 AM, Melanie Snayer [EMAIL PROTECTED] wrote: ** Hi Listeners We're experiencing performance issues especially when submitting incidents. Our initial plan was to archive calls that have been closed for more than 5 years but as a result of the performance issues we're having to considering archiving as soon as 1 year and 6 months after having gone-live. Well, archiving is just one of the options that we have resorted to along side the current ongoing perfomance tuning that we're doing. Can you guys give me examples of how you may have gone about archiving your data? Like what the archiving criteria is and whether your archiving was done as a result of performance issue or as standard procedure. Thanks Mel __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
