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"
