Hi all Master,
Currently i'm using SAP version 8.8 and already 3 years. now my SAP getting very slow. then i check on SQL server monitor, the query stuck on
"(@P1 int,@P2 smallint,@P3 int,@P4 int,@P5 int)SELECT T0.[LayerInQty], T0.[LayerOutQ], T0.[TransValue], T0.[CalcPrice] FROM [dbo].[IVL1] T0 INNER JOIN [dbo].[OIVL] T1 ON T1.[TransSeq] = T0.[TransSeq] INNER JOIN [dbo].[OILM] T2 ON T1.[MessageID] = T2.[MessageID] WHERE T2.[AppObjAbs] = (@P1) AND T2.[AppObjLine] = (@P2) AND T2.[ApplObj] = (@P3) AND T2.[TransType] IN(@P4,@P5) "
if i check OIVL already have 1 million records. is there solution to this issues.
best Regards,
YunPho