ENV: ARS 7.5 CMDB 7.6 patch 002 ITSM 7.6 patch 001 WinServer 2008 R2 SQL Server 2008 R2
BMC.CORE:BMC_BaseElement has 3,012,967 rows BMC.CORE:BMC_BaseRelationship has 416,512 rows Some users are complaning that when they access the Inventory Location form it can take up to a minute or more to show the data. I think the problem is the CIs in Inventory table on the CIs in Inventory Tab. It is refreshing from the AST:SearchFromBase_Relationship form which is a join on AST:SearchFromBase_Relationship1 and SHR:SchemaNames. AST:SearchFromBase_Relationship1 is a join betweeen BMC.CORE:BMC_BaseRelationship and BMC.CORE:BMC_BaseElement. The SQL code that is creating the problem appears to be: SELECT TOP 11 T914.C1,C210000000,C200000020,C490009100,C400128900,C490009000,C490021100,C200000003,C200000004,C200000005,C1000000001,C240001002,C240001005 FROM T914 WHERE ((T914.C490008000 = 'AS02004C4F4F503_ytTgIjsRAANTQA') AND (T914.C300420800 != 'AS02004C4F4F503_ytTgIjsRAANTQA') AND ((T914.C160 = ' ') OR ((' ' = ' ') AND (T914.C160 IS NULL)))) ORDER BY 1 ASC T914 is AST:SearchFromBase_Relationship Has anyone had (or currently have) a similar problem that they have fixed? I tried using SQL Manager to check the code execution and it wasn't really much help. I added one index to BaseElement but the decrease in time was minimal. Scrolling though the records on this form is torture unless there are no entries in the CIs in Inventory table. Thanks. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"