Thank you for the response. I put the information on my last post but forgot to add it to this one (slap on the wrist)
AR System is 7.5 patch 6 CMDB version is 7.6.00 patch 1 Oracle 10g I'll present your suggestion as one of our options. In the meantime I am going to try and spend some time seeing if I can just make it return faster for any of the queries they are running. Thanks, Sean From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Thad Esser Sent: Monday, July 18, 2011 1:23 PM To: [email protected] Subject: Re: Asset Management Console is slow ... trying to index/tweak query with no luck ** Sean, I don't see any version info for you, but on 7.0.3 (patch 9) at least, that main table on the Asset Management console refreshes something like three different times when you open it from the home page. Combined with the slow queries you see, it can be agonizing to use. The code was sufficiently spaghettified that I didn't take the time to fix it, but depending on your idea of "fun", you could. :-) One thing that sort of helps is to set the default class that gets searched when the console first loads. With the console open, select "Application Preferences" on the left. On the asset management tab, under the "Search Criteria Default" section, choose a CI Type that isn't used very much in your organization (mine is currenlty set to "Role"). I suppose you could change it for all users, but I haven't done that yet. Not ideal, but something. Thad On Mon, Jul 18, 2011 at 5:49 AM, Garrison, Sean (Norcross) <[email protected]<mailto:[email protected]>> wrote: ** Sort order on the table, on AST:BaseElement, and on BMC.CORE:BMC_BaseElement are all blank. I tried adding "InstanceId" to the sort order which would return the results fast. However it added both request id and instance id to the "ORDER BY" portion of the SQL. This is out of the box workflow with the asset management console so you should (in theory) see the same thing. Weird stuff .... Sean From: Action Request System discussion list(ARSList) [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Meyer, Jennifer L Sent: Friday, July 15, 2011 5:30 PM To: [email protected]<mailto:[email protected]> Subject: Re: Asset Management Console is slow ... trying to index/tweak query with no luck ** Did you check the sort order set on the table? Jennifer Meyer Remedy Technical Support Specialist State of North Carolina Office of Information Technology Services Service Delivery Division ITSM & ITAM Services Office: 919-754-6543<tel:919-754-6543> ITS Service Desk: 919-754-6000<tel:919-754-6000> [email protected]<mailto:[email protected]> http://its.state.nc.us<http://its.state.nc.us/> E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. From: Action Request System discussion list(ARSList) [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Garrison, Sean (Norcross) Sent: Friday, July 15, 2011 4:06 PM To: [email protected]<mailto:[email protected]> Subject: Asset Management Console is slow ... trying to index/tweak query with no luck ** Hello ARSListers, I was wondering if you guys had done any tweaking on the asset management console and what suggestions you could make. I have the following query: SELECT * FROM ( SELECT T1262.C1,C210000000,C7,C200000005,C179,C200000007,C240001008,C240001003,C200000001,C260100004,C490021100,C200000020,C200000003,C200000004,C240001002,C260000001,C400129200,C240001005,C1000000150,C8,C400079600 FROM T1262 WHERE ((T1262.C400127400 = 'BMC.ASSET') AND (1 = 1) AND (T1262.C7 >= 3) AND (T1262.C7 <= 3) AND (1 = 1) AND (1 = 1)) ORDER BY 1 ASC ) WHERE ROWNUM <= 51 Which is generated from the out of the box asset management console when it first loads. It is taking ~51 seconds for this query to run. If I change it to this: SELECT * FROM ( SELECT T1262.C1,C210000000,C7,C200000005,C179,C200000007,C240001008,C240001003,C200000001,C260100004,C490021100,C200000020,C200000003,C200000004,C240001002,C260000001,C400129200,C240001005,C1000000150,C8,C400079600 FROM T1262 WHERE ((T1262.C400127400 = 'BMC.ASSET') AND (1 = 1) AND (T1262.C7 >= 3) AND (T1262.C7 <= 3) AND (1 = 1) AND (1 = 1)) ) WHERE ROWNUM <= 51 The query takes ~ 7 seconds to run. I have double checked all of the "Sort Order" settings for BMC.CORE:BMC_BaseElement, table, and AST:BaseElement to no avail. I can't seem to get Remedy to remove the "ORDER BY 1 ASC" part. On a side note I have found that this form is also using the "AST:BaseElement". I tried changing it to "BMC.CORE:BMC_BaseElement" so that it does not use the join. That doesn't do much either. I have also tried creating an index on base element to include the following fields when searching BMC.CORE:BMC_BaseElement: Request ID, InstanceId, DatasetID, and Status That didn't seem to speed it up either. Any help/suggestions? Thanks, Sean _attend WWRUG11 www.wwrug.com<http://www.wwrug.com/> ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com<http://www.wwrug.com/> ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com<http://www.wwrug.com/> ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
