Hi All
IN sp_whoisactive, I found a query which makes my server cpu busy and make the system slow. when I kill that specific query then there is no effect on any users. any body can guide what is the purpose of this query and how I can permanently kill this query for future.
<?query --
SELECT COUNT(T1.RECID) FROM CUSTTRANSOPEN T1 CROSS JOIN CUSTTRANS T2 CROSS JOIN CUSTTABLE T3 WHERE
(((T1.PARTITION=@P1) AND (T1.DATAAREAID=@P2)) AND (T1.DUEDATE<@P3)) AND (((T2.PARTITION=@P4) AND
(T2.DATAAREAID=@P5)) AND (((((((T2.TRANSTYPE<=@P6) OR (T2.TRANSTYPE=@P7)) OR ((T2.TRANSTYPE=@P8) OR
(T2.TRANSTYPE=@P9))) OR (((T2.TRANSTYPE=@P10) OR (T2.TRANSTYPE=@P11)) OR (T2.TRANSTYPE=@P12))) AND
(T2.AMOUNTCUR>=@P13)) AND (T1.ACCOUNTNUM=T2.ACCOUNTNUM)) AND (T1.REFRECID=T2.RECID))) AND (((T3.PARTITION=@P14)
AND (T3.DATAAREAID=@P15)) AND (T2.ACCOUNTNUM=T3.ACCOUNTNUM)) OPTION(FAST 5)
--?>
*This post is locked for comments
I have the same question (0)
