What I have found is that fetching the "applications" does not fetch also the "external fluff" that is used by the application. It only fetches the "Forms associated to the application"... So for example, since CTM:People is not a component of the "Change Management Application" the first time you query for the requester it has to Grab&Cache...
For this reason, we have a combination of "applications" and then "forms" which are cached. A complete cache of "Change Management" takes about 38 minutes for Mid-Tier to complete, and ARSystem is 75% busy. I'm trying to find time (which is impossible) to look at the indexes in ARS7 core forms and analyze why a "select from field where schemaid = 1234" takes so freaking long, but looking at the form, schemaid IS indexed already... (again, time and investigation needed here)... Unfortunately, pressing "clear cache" in mid-tier config does not restart the cache process, so you must restart Tomcat (or what ever mid-tier you are running) to have the process kick in. Once everything is in the cache performance is quite acceptable, well, at least within the "requirements standards" for usage (form open < 5 seconds, button click to menu < 2 seconds, ...) I'm attaching the "hard coded" first pass change management prefetch for reference. We are still in the process of re-constructing this by loading the "applications" first then the extra forms later... Thanks-n-advance; HDT Platform Incident / Problem Manager & Architect Robert Molenda IT OS PA Tel: +1 408 503 2701 Fax: +1 408 503 2912 Mobile: +1 408 472 8097 [EMAIL PROTECTED] Quality begins with your actions. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of strauss Sent: Wednesday, February 28, 2007 11:48 AM To: [email protected] Subject: Re: BMC 1.0 (aka Remedy 7) Web Restarting the Tomcat web server (or IIS Admin if using IIS/SE) restarts mid-tier 7, and it almost immediately starts a prefetch if the prefetchConfig.xml file has been activated. Out of the box it is set up to prefetch the sample app, but is commented out and inactive (or at least it is when you install 7.0.01.001). Christopher Strauss, Ph.D. Remedy Database Administrator University of North Texas Computing Center http://remedy.unt.edu/helpdesk/ -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Wednesday, February 28, 2007 1:11 PM To: [email protected] Subject: Re: BMC 1.0 (aka Remedy 7) Web Chris, have you found any way to set up an automatic prefetch of the forms when the MT is restarted? Seems like a Perl script or something similar might do that. Even if a scheduled one were done each night, that would be better than nothing. Rick -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of strauss Sent: Wednesday, February 28, 2007 11:01 AM To: [email protected] Subject: Re: BMC 1.0 (aka Remedy 7) Web Are you working with the ITSM 7 applications or just simple forms? There appears to be a fundamental flaw in the way the mid-tier does caching from the AR server, and the workaround - prefetching the applications/forms, is still something of a band-aid. It also puts a horrific load on the AR server (not mid-tier or db) during the prefetch process, which currently lasts 35 minutes for ITSM 7 minus Asset, per mid-tier web server. WITHOUT prefetching, the consoles (incident, problem, change, etc.) load in up to 1 1/2 minutes the first time they are accessed. After that, it is more like 2-3 seconds. WITH prefetching, the consoles (incident, problem, change, etc.) load in up to 15 seconds the first time they are accessed; after that, it is more like 2-3 seconds. We have seen these response times on two separate systems, both running on more hardware than ARS knows how to use, so I think my assessments are pretty valid. Even if we prefetch the applications, sooner or later we hit some form that did not cache, or log in with a set of permissions that is too different from the prefetch user, and the form takes up to a minute to load even if it is a simple dialog box. It appears that a thorough prefetch is essential to having acceptable mid-tier performance, and I hear that it will be more prominently featured (and documented and supported) in an "upcoming release." I hope so; our testers rated the ITSM 7 application over mid-tier as fundamentally unusable due to the miserable response times until we got prefetching in place. They are still annoyed with it when they are the first user to open any form after a restart on mid-tier. Christopher Strauss, Ph.D. Remedy Database Administrator University of North Texas Computing Center http://remedy.unt.edu/helpdesk/ -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Todd Pasterski Sent: Tuesday, February 27, 2007 7:58 PM To: [email protected] Subject: BMC 1.0 (aka Remedy 7) Web What is the general opinion of the web on Remedy 7? We are trying to do some demo testing and the web is VERY slow, and not just the initial load. Any other experience(s) to share? If yours is fast what are you doing? ________________________________________________________________________ _______ 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" ________________________________________________________________________ _______ 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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
<?xml version="1.0" encoding="UTF-8"?> <midtier-prefetch-config xmlns="http://www.bmc.com/remedy/midtier/700";> <prefetch-user> <user-name>change</user-name> <locale>en_US</locale> <prefetch-server> <server-name>mucsar10</server-name> <prefetch-form> <form-name>Home Page</form-name> </prefetch-form> <prefetch-form> <form-name>CHG:Change Management Console</form-name> </prefetch-form> <prefetch-form> <form-name>AST:AppSettings</form-name> </prefetch-form> <prefetch-form> <form-name>BMC.CORE.CONFIG:BMC_Dataset</form-name> </prefetch-form> <prefetch-form> <form-name>CTM:SupportGroupFuncRoleLookUp</form-name> </prefetch-form> <prefetch-form> <form-name>CMS:ConfigurationManagement</form-name> </prefetch-form> <prefetch-form> <form-name>CTM:People Audit</form-name> </prefetch-form> <prefetch-form> <form-name>CTM:People Attachments</form-name> </prefetch-form> <prefetch-form> <form-name>CTM:People WorkLog</form-name> </prefetch-form> <prefetch-form> <form-name>CTM:Address Details</form-name> </prefetch-form> <prefetch-form> <form-name>CTM:Login ID</form-name> </prefetch-form> <prefetch-form> <form-name>CTM:People Benefit Info</form-name> </prefetch-form> <prefetch-form> <form-name>CTM:People HR Attendance Mgmt</form-name> </prefetch-form> <prefetch-form> <form-name>CTM:People IT Skills</form-name> </prefetch-form> <prefetch-form> <form-name>CTM:People Profile</form-name> </prefetch-form> <prefetch-form> <form-name>CTM:People Travel Profile</form-name> </prefetch-form> <prefetch-form> <form-name>CTM:People Wallet</form-name> </prefetch-form> <prefetch-form> <form-name>CTM:People Template</form-name> </prefetch-form> <prefetch-form> <form-name>CTM:People Permission Groups</form-name> </prefetch-form> <prefetch-form> <form-name>NTE:CFG-Notification Events</form-name> </prefetch-form> <prefetch-form> <form-name>CTM:People Education</form-name> </prefetch-form> <prefetch-form> <form-name>FIN:SearchCostCenterdlg</form-name> </prefetch-form> <prefetch-form> <form-name>FIN:ConfigCostCentersRepository</form-name> </prefetch-form> <prefetch-form> <form-name>CTM:Phone Details</form-name> </prefetch-form> <prefetch-form> <form-name>APR:Alternate</form-name> </prefetch-form> <prefetch-form> <form-name>CTM:People Attributes</form-name> </prefetch-form> <prefetch-form> <form-name>CTM:Profile Definition</form-name> </prefetch-form> <prefetch-form> <form-name>CTM:CFG PeopleTagNumGenerator</form-name> </prefetch-form> <prefetch-form> <form-name>FIN:CostCenterUDAAssociations</form-name> </prefetch-form> <prefetch-form> <form-name>SYS:Date Time Query Rules</form-name> </prefetch-form> <prefetch-form> <form-name>CTM:People</form-name> </prefetch-form> <prefetch-form> <form-name>CTM:CFG-ApplicationPreferences</form-name> </prefetch-form> <!-- Above is for CONSOLE --> <prefetch-form> <form-name>FIN:CostAssociationJoin</form-name> </prefetch-form> <prefetch-form> <form-name>CHG:ChangeRiskDerivedFactors</form-name> </prefetch-form> <prefetch-form> <form-name>TMS:AssocSummaryDataJoin</form-name> </prefetch-form> <prefetch-form> <form-name>AP:Dtl-Sig-MoreInfoDialog</form-name> </prefetch-form> <prefetch-form> <form-name>APR:NextApproverList</form-name> </prefetch-form> <prefetch-form> <form-name>CHG:ChangeRiskFactors</form-name> </prefetch-form> <prefetch-form> <form-name>CHG:ChangeRiskDerivedFactorsTemplateLookup</form-name> </prefetch-form> <prefetch-form> <form-name>Business Time Shared Entity-Entity Association_Join_Join</form-name> </prefetch-form> <prefetch-form> <form-name>CHG:Associations-CI Join</form-name> </prefetch-form> <prefetch-form> <form-name>CHG:ChangeRiskFieldSelection</form-name> </prefetch-form> <prefetch-form> <form-name>CHG:ChangeRiskDerivedTemplateFieldSelectionLookup</form-name> </prefetch-form> <prefetch-form> <form-name>SYS:Form Field Selection</form-name> </prefetch-form> <prefetch-form> <form-name>AST:CI Unavailability AuditLog</form-name> </prefetch-form> <prefetch-form> <form-name>AST:BOAnalysisSrch_dlg</form-name> </prefetch-form> <prefetch-form> <form-name>BMC.CORE:BMC_BaseElement</form-name> </prefetch-form> <prefetch-form> <form-name>HPD:Attachments</form-name> </prefetch-form> <prefetch-form> <form-name>CHG:CFG Rules</form-name> </prefetch-form> <prefetch-form> <form-name>CHG:SYS Notification Rules</form-name> </prefetch-form> <prefetch-form> <form-name>SLM:Measurement</form-name> </prefetch-form> <prefetch-form> <form-name>SLM:AuditLogDlg</form-name> </prefetch-form> <prefetch-form> <form-name>SLM:EventSchedule</form-name> </prefetch-form> <prefetch-form> <form-name>SIT:Site</form-name> </prefetch-form> <prefetch-form> <form-name>CTM:PostalCodesDialog</form-name> </prefetch-form> <prefetch-form> <form-name>SIT:Site Alias</form-name> </prefetch-form> <prefetch-form> <form-name>SIT:Site Company Association</form-name> </prefetch-form> <prefetch-form> <form-name>SIT:Site Zone</form-name> </prefetch-form> <prefetch-form> <form-name>CHG:ChangeAPDetailSignature</form-name> </prefetch-form> <prefetch-form> <form-name>CHG:Impacted Areas</form-name> </prefetch-form> <prefetch-form> <form-name>TMS:ParentApplicationObject</form-name> </prefetch-form> <prefetch-form> <form-name>AST:AdminDomain</form-name> </prefetch-form> <prefetch-form> <form-name>AST:CI Unavailability</form-name> </prefetch-form> <prefetch-form> <form-name>FIN:Costs</form-name> </prefetch-form> <prefetch-form> <form-name>CHG:Infra. Change Effort Log</form-name> </prefetch-form> <prefetch-form> <form-name>CHG:Infrastructure Change</form-name> </prefetch-form> <prefetch-form> <form-name>CHG:Attachments</form-name> </prefetch-form> <prefetch-form> <form-name>RMG:SrvTime</form-name> </prefetch-form> <prefetch-form> <form-name>CFG:WorkLog</form-name> </prefetch-form> <prefetch-form> <form-name>PBM:Known Error Associations</form-name> </prefetch-form> <prefetch-form> <form-name>CHG:Template Associations</form-name> </prefetch-form> <!-- Above is for NEW/SEARCH Change Request --> <prefetch-form> <form-name>SHR:SchemaNames</form-name> </prefetch-form> <prefetch-form> <form-name>SYS:Menu Items</form-name> </prefetch-form> <prefetch-form> <form-name>SYS:SelectionFieldFormMapping</form-name> </prefetch-form> <!-- Above is for 'My Profile' --> <prefetch-form> <form-name>CFG:Reminders</form-name> </prefetch-form> <prefetch-form> <form-name>CFG:ReminderNotifications</form-name> </prefetch-form> <!-- Above is for 'Reminders' --> <prefetch-form> <form-name>RRC:Reporting</form-name> </prefetch-form> <prefetch-form> <form-name>RRC:Reporting-SavedSearches_dlg</form-name> </prefetch-form> <prefetch-form> <form-name>RRC:Report-SavedSearches</form-name> </prefetch-form> <!-- Above is for 'Reports' --> <prefetch-form> <form-name>SHR:FlashboardDialog</form-name> </prefetch-form> <!-- Above is for 'Flashboards' --> <prefetch-form> <form-name>SHARE:Application_Properties</form-name> </prefetch-form> <prefetch-form> <form-name>AST:ManageAssetInformation</form-name> </prefetch-form> <!-- Above is for 'Manage CI's' --> <prefetch-form> <form-name>CHG:CCMCalendar</form-name> </prefetch-form> <prefetch-form> <form-name>CHG:CCMCRServiceCISearch</form-name> </prefetch-form> <prefetch-form> <form-name>CHG:CCMCalendar:SaveDefaultDialog</form-name> </prefetch-form> <prefetch-form> <form-name>CHG:CCMGetPrintTitleDialog</form-name> </prefetch-form> <prefetch-form> <form-name>CHG:CCMQuickSearch</form-name> </prefetch-form> <prefetch-form> <form-name>CHG:CCMCR-CIAdvSearch</form-name> </prefetch-form> <prefetch-form> <form-name>CHG:CCMCR-ImpLocAdvSearch</form-name> </prefetch-form> <prefetch-form> <form-name>CHG:CCMCalendar:UserDefaults</form-name> </prefetch-form> <prefetch-form> <form-name>CHG:CCMAdminGUI:ServerConfig</form-name> </prefetch-form> <!-- Above is for 'View Calendar' --> <prefetch-form> <form-name>CTM:SYS-Access Permission Grps</form-name> </prefetch-form> <prefetch-form> <form-name>Business Time Shared Entity</form-name> </prefetch-form> <prefetch-form> <form-name>RMG:Entity Type Definition Form</form-name> </prefetch-form> <prefetch-form> <form-name>RMG:EntitySearch_dlg</form-name> </prefetch-form> <!-- Above is for 'Manage Business Events' --> <prefetch-form> <form-name>AST:AssetAdvancedSearch</form-name> </prefetch-form> <!-- Above is for 'Time Segments->CI' --> <prefetch-form> <form-name>SYS:Attachments</form-name> </prefetch-form> <prefetch-form> <form-name>SYS:Viewer</form-name> </prefetch-form> <!-- Above is for 'View Process' --> <prefetch-form> <form-name>SRM:Survey</form-name> </prefetch-form> <prefetch-form> <form-name>SRM:SurveyResponseHolder</form-name> </prefetch-form> <prefetch-form> <form-name>SRM:SurveyResponseDialog</form-name> </prefetch-form> <!-- Above is for 'Survey Resonses' --> <prefetch-form> <form-name>COM:Company Alias</form-name> </prefetch-form> <prefetch-form> <form-name>SIT:Site Group</form-name> </prefetch-form> <prefetch-form> <form-name>TMS:ViewWindow</form-name> </prefetch-form> <!-- Above is for 'Configuration Manager' --> <prefetch-form> <form-name>CFG:Service Catalog LookUp</form-name> </prefetch-form> <!-- Above is for 'Select Operational' --> <prefetch-form> <form-name>PCT:ProductAliasCPYAssocLookUp</form-name> </prefetch-form> <!-- Above is for 'Select Product' --> <prefetch-form> <form-name>CHG:TemplateSPGLookUp</form-name> </prefetch-form> <prefetch-form> <form-name>CFG:Attachments</form-name> </prefetch-form> <prefetch-form> <form-name>TMS:TaskTemplate</form-name> </prefetch-form> <prefetch-form> <form-name>TMS:SummaryData</form-name> </prefetch-form> <prefetch-form> <form-name>TMS:FlowTAssocTAssocTJoin</form-name> </prefetch-form> <prefetch-form> <form-name>TMS:FlowTemplateBuilder</form-name> </prefetch-form> <prefetch-form> <form-name>TMS:AssociationTemplate</form-name> </prefetch-form> <prefetch-form> <form-name>SIT:Site Alias Company LookUp</form-name> </prefetch-form> <!-- Above is for 'Select Template' --> <prefetch-form> <form-name>CFG:Broadcast</form-name> </prefetch-form> <prefetch-form> <form-name>CFG:Broadcast Association</form-name> </prefetch-form> <prefetch-form> <form-name>CFG:CFG PBB TicketNumGenerator</form-name> </prefetch-form> <prefetch-form> <form-name>HPD:Help Desk</form-name> </prefetch-form> <prefetch-form> <form-name>CFG:Decision Tree</form-name> </prefetch-form> <prefetch-form> <form-name>CFG:Decision Tree-Branch</form-name> </prefetch-form> <prefetch-form> <form-name>HPD:WorkLog</form-name> </prefetch-form> <prefetch-form> <form-name>CTM:Location Details</form-name> </prefetch-form> <prefetch-form> <form-name>HPD:Incident Matching</form-name> </prefetch-form> <prefetch-form> <form-name>CFG:GEMScriptAssocLookup</form-name> </prefetch-form> <prefetch-form> <form-name>HPD:TemplateSPGLookUp</form-name> </prefetch-form> <prefetch-form> <form-name>HPD:Help Desk Assignment Log</form-name> </prefetch-form> <prefetch-form> <form-name>HPD:Help Desk Audit Log</form-name> </prefetch-form> <prefetch-form> <form-name>HPD:IncidentDateSearch</form-name> </prefetch-form> <prefetch-form> <form-name>HPD:Impacted Areas</form-name> </prefetch-form> <prefetch-form> <form-name>AST:CI Related Item</form-name> </prefetch-form> <prefetch-form> <form-name>HPD:Template Associations</form-name> </prefetch-form> <prefetch-form> <form-name>PBM:Solution DB Associations</form-name> </prefetch-form> <prefetch-form> <form-name>CFG:BroadcastSPGAssociation</form-name> </prefetch-form> <!-- Above is for 'View Broadcasts' --> <prefetch-form> <form-name>FIN:ConfigCostCategory</form-name> </prefetch-form> <!-- Above is for 'Search CR' --> <prefetch-form> <form-name>CHG:Copy Infrastructure Change</form-name> </prefetch-form> <!-- Above is for 'Copy Change' --> <prefetch-form> <form-name>CTM:Email System</form-name> </prefetch-form> <prefetch-form> <form-name>NTE:Notifier</form-name> </prefetch-form> <prefetch-form> <form-name>AST:Attachments</form-name> </prefetch-form> <prefetch-form> <form-name>AST:PurchaseRequisitionWorkLog</form-name> </prefetch-form> <prefetch-form> <form-name>PBM:Investigation WorkLog</form-name> </prefetch-form> <prefetch-form> <form-name>PBM:Investigation Attachments</form-name> </prefetch-form> <prefetch-form> <form-name>PBM:Known Error WorkLog</form-name> </prefetch-form> <prefetch-form> <form-name>PBM:Known Error Attachments</form-name> </prefetch-form> <!-- Above is for 'Email System' --> <prefetch-form> <form-name>CTM:Paging System</form-name> </prefetch-form> <prefetch-form> <form-name>CTM:Support Group On-Call</form-name> </prefetch-form> <prefetch-form> <form-name>CFG:Business Time Workdays</form-name> </prefetch-form> <prefetch-form> <form-name>CFG:BusTimeTagGenerator</form-name> </prefetch-form> <prefetch-form> <form-name>CTM:Support Group Alias LookUp</form-name> </prefetch-form> <!-- Above is for 'Paging System' --> <prefetch-form> <form-name>CHG:Change Request Audit</form-name> </prefetch-form> <prefetch-form> <form-name>CHG:ChangeRequest_AuditLogSystem</form-name> </prefetch-form> <!-- Above is for 'Audit Log' --> <prefetch-form> <form-name>CHG:Impacted Areas</form-name> </prefetch-form> <!-- Above is for 'Impacted Areas' --> <prefetch-form> <form-name>CHG:ChangeRiskReportDialog</form-name> </prefetch-form> <prefetch-form> <form-name>CHG:ChangeRiskDerivedTemplateSelectionDerivedFactorsLookup</form-name> </prefetch-form> <prefetch-form> <form-name>CHG:ChangeRiskReportTemplate</form-name> </prefetch-form> <!-- Above is for 'View Risk Report' --> <prefetch-form> <form-name>RMG:EntitySearch_dlg</form-name> </prefetch-form> <prefetch-form> <form-name>AST:AssetAdvancedSearch</form-name> </prefetch-form> <prefetch-form> <form-name>SHR:OverviewConsole</form-name> </prefetch-form> <prefetch-form> <form-name>SHR:OverviewConsole_SelectRequestType_dlg</form-name> </prefetch-form> <prefetch-form> <form-name>SHR:OverviewConsole_SelectStatusValues_dlg</form-name> </prefetch-form> <prefetch-form> <form-name>SHR:ARDBC_OverviewConsole</form-name> </prefetch-form> <prefetch-form> <form-name>SYS:Status Query Rules</form-name> </prefetch-form> <!-- Above is for 'Overview Console' --> <prefetch-form> <form-name>NTE:Notifier Log</form-name> </prefetch-form> <prefetch-form> <form-name>CHG:ChangeRequesterDialogView</form-name> </prefetch-form> <prefetch-form> <form-name>TMS:IntegrationConfiguration</form-name> </prefetch-form> <prefetch-form> <form-name>TMS:TaskFlowViewer</form-name> </prefetch-form> <prefetch-form> <form-name>TMS:Relationships</form-name> </prefetch-form> <prefetch-form> <form-name>TMS:TaskEffort</form-name> </prefetch-form> <prefetch-form> <form-name>CHG:Infra. Change Effort Log</form-name> </prefetch-form> <prefetch-form> <form-name>CTM:SupportGroupFunctionalRole</form-name> </prefetch-form> <prefetch-form> <form-name>APR:Non-ApprovalNotifications</form-name> </prefetch-form> <prefetch-form> <form-name>CHG:ChangeAPDetailSignature</form-name> </prefetch-form> <!-- Above is for 'Misc Change Buttons' --> </prefetch-server> </prefetch-user> <prefetch-user> <user-name>Demo</user-name> <locale>en_US</locale> <prefetch-server> <server-name>mucsar10</server-name> <prefetch-form> <form-name>Application Pending</form-name> </prefetch-form> </prefetch-server> </prefetch-user> </midtier-prefetch-config>
