My guess would be that it is refreshing the Overview Console. If you have lots (like 100,000+) being returned, this constantly refreshing table will bog your system down. You might look at reducing table sizes, modifying the query, adjusting indexes, or all three.
Rick On Tue, Jan 8, 2013 at 10:57 AM, Vishal Navale <[email protected]> wrote: > ** > Hi, > > I am seen below long runnnig query on Remedy Server which causes > performance issues. Does anyone knows what is his query? > > Thanks > Vishal > > > 895060 SQL 0000218104 Prv:390680 390680 Remedy Application Service Tue Jan > 08 2013 09:20:30.1500 > SELECT TOP 2001 > T1916.C1,C1000000161,C301626500,C1000000000,C7,C1000000164,C1000000217,C1000000218,C179,C230000009,C3 > FROM T1916 WHERE (((T1916.C230000009 = N'MAINCHANGE') AND > ((T1916.C1000000716 = N'ranjselv') OR (T1916.C4 = N'ranjselv') OR (T1916.C4 > = N'ranjselv')) AND ((T1916.C7 = 1) OR (T1916.C7 = 2) OR (T1916.C7 = 3) OR > (T1916.C7 = 4) OR (T1916.C7 = 5) OR (T1916.C7 = 6) OR (T1916.C7 = 7) OR > (T1916.C7 = 8) OR (T1916.C7 = 9))) OR ((T1916.C230000009 = N'MAINHELPDESK') > AND (T1916.C4 = N'ranjselv') AND ((T1916.C7 = 0) OR (T1916.C7 = 1) OR > (T1916.C7 = 2) OR (T1916.C7 = 3))) OR ((T1916.C230000009 = N'TMSTASK') AND > (T1916.C4 = N'ranjselv') AND ((T1916.C7 = 1000) OR (T1916.C7 = 2000) OR > (T1916.C7 = 3000) OR (T1916.C7 = 4000) OR (T1916.C7 = 5000))) OR > ((T1916.C230000009 = N'MAINKNOWLEDGEDATABASE') AND (T1916.C4 = N'ranjselv') > AND (T1916.C7 = 4)) OR ((T1916.C230000009 = N'MAINKNOWNERROR') AND > (T1916.C4 = N'ranjselv') AND ((T1916.C7 = 0) OR (T1916.C7 = 1) OR (T1916.C7 > = 2))) OR ((T1916.C230000009 = N'MAINPROBLEM') AND (T1916.C4 = N'ranjselv') > AND ((T1916.C7 = 0) OR (T1916.C7 = 1) OR (T1916.C7 = 2) OR (T1916.C7 = 3) > OR (T1916.C7 = 4) OR (T1916.C7 = 5)))) ORDER BY C1000000161 ASC, 1 ASC > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
