Does anyone think that they have figured out all of the ins and outs of using the prefetch script with mid-tier (prefetchConfig.xml)?? Since this is a largely undocumented utility that BMC Remedy Support does not fully understand, I'll take any hints that others have already figured out. The latest script I am trying to use for ITSM 7.0 looks like this:
<?xml version="1.0" encoding="UTF-8"?> <midtier-prefetch-config xmlns="http://www.bmc.com/remedy/midtier/700";> <prefetch-user> <user-name>Demo</user-name> <locale>en_US</locale> <prefetch-server> <server-name>remedy6.ars.unt.edu</server-name> <prefetch-app> <app-name>Remedy Incident Management</app-name> </prefetch-app> <prefetch-app> <app-name>Remedy Change Management</app-name> </prefetch-app> <prefetch-app> <app-name>Remedy Change Management Dashboard</app-name> </prefetch-app> <prefetch-app> <app-name>Remedy Problem Management</app-name> </prefetch-app> <prefetch-app> <app-name>Remedy Requester Console</app-name> </prefetch-app> <prefetch-app> <app-name>Remedy Task Management</app-name> </prefetch-app> <prefetch-app> <app-name>Remedy Reporting Console</app-name> </prefetch-app> </prefetch-server> <prefetch-server> <server-name>remedy6.ars.unt.edu</server-name> <prefetch-app> <app-name>Remedy Foundation Elements</app-name> <prefetch-form> <form-name>SHR:OverviewConsole</form-name> </prefetch-form> </prefetch-app> </prefetch-server> <prefetch-server> <server-name>remedy6.ars.unt.edu</server-name> <prefetch-form> <form-name>Home Page</form-name> </prefetch-form> <prefetch-form> <form-name>SHR:OverviewConsole</form-name> </prefetch-form> <prefetch-form> <form-name>HPD:Help Desk</form-name> </prefetch-form> <prefetch-form> <form-name>CHG:Infrastructure Change</form-name> </prefetch-form> <prefetch-form> <form-name>PBM:Known Error</form-name> </prefetch-form> <prefetch-form> <form-name>PBM:Problem Investigation</form-name> </prefetch-form> <prefetch-form> <form-name>PBM:Solution Database</form-name> </prefetch-form> <prefetch-form> <form-name>TMS:Task</form-name> </prefetch-form> </prefetch-server> </prefetch-user> </midtier-prefetch-config> I am not convinced that everything in the script is in fact prefetching yet. It takes over 30 minutes for prefetch to run after the mid-tier server starts (the mid-tier shows little CPU usage but the AR Server sits at 30% utilization throughout!), but the difference in performance for the first time a form loads can be huge. Also, that difference varies based on who is logging in - the script was run with Demo, tests were with a support staff login (AREA authenticated) and then with the appadmin account, which was slower: Console Incident Change Problem Overview Requester Not Prefetched load time 0:39 1:35 0:25 0:47 0:26 Prefetched, 1st time load 0:04 0:22 0:04 0:27 0:08 (same, but different user) 0:16 0:53 0:12 0:08 0:29 All subsequent loadings 0:02 0:02 0:02 0:02 0:01 Loading forms from the consoles also differs depending on whether the form is part of the same application that the console is in: Form New Incident from Incident Console New Incident from Overview Console Not Prefetched load time 0:24 1:40 Prefetched, 1st time load 0:06 0:04 All subsequent loadings 0:03 0:03 I now believe that this utility is an essential part of any mid-tier/ITSM 7.x installation, since the load times measured for initial ITSM 7 form access are clearly unacceptable. Prefetch will need to be a lot better documented and understood before that will be possible, so please share any experience that you might have with it. Christopher Strauss, Ph.D. Remedy Database Administrator University of North Texas Computing Center http://remedy.unt.edu/helpdesk/ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
