Hi, Once again I come to ARSlist for guidance. I cannot say how much I appreciate all you Remedy experts.
Anyway, Our environment is ARS 7.1 patch 3, ITSM 7.0.3, SRM 2.1 and SLM 7.1 patch 2 I've noticed that Overview Console loading uses up a lot of SQL time (Profiler shows lots of time in overview console) I'm pretty sure as the records grow, Overview Console is built inefficiently. I can see a lot of LIKE qualifications in the query. But i'm no expert if any of this so I could be reading it wrong. Now we have 50 support staff constantly loading Overview Console to look for tickets and I figure that is causing unnecessary load on the sql server. Also we have fast threads as 6/6 and list as 10/10. Seems like all overview, SRM workflow go through the fast thread. So I'm guessing a lot of actions are queued up waiting for threads to free up. Will a CAI plugin registry private thread of 4/4 help with spreading the workflow around? What does the plugin loopback RPC thread do? What applications use that? Should I decrease the plugin loopback from 2/2 to 1/1? I just want things to be running as efficiently as possible. But for some reason SRM 2.1 seems to be throwing monkey wrenches into everything. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
