UCCX 10.6.1 - CPU Running High due to Wallboard/Inova running Agent Current Totals from RtICDStatistic table
CUCM 126.96.36.19900-18 with UCCX 10.6.1.11002-15
Our CPU Utilization is over 70%. From the wallboard we can stop the report they call, Agent Current Totals, and the CPU drops by 20%. They are telling me they only use the following table, RtICDStatistics. The SQL query is:
from vw_agentcurrenttotals where agentstate <> 'Log Out';
I would like to modify this query so that it only pulls by Resource Group Name, Support Service or the Team, Support Services. It looks to me that they are pulling all agents statistics into the wallboard.
If they are displaying agent state such as Ready, Not Ready, Talking etc they will be reading the AgentStateTable
Every time an Agent changes state a new row is added to this table and over time this table get huge.
You install a new CCX and wallboard and it all works great as there is no data in the AgentStateTable and the SQL reads are fast. Overtime this table fills up and the reads take longer and the CPU load goes up.
You could look at how long you are keeping historical data for. The default is 99 months and maybe you can reduce this down to 12 months or less.
Greetings, Wanted to share a few lessons learned while migrating from a distributed to centralized IMP deployment. Our current setup included many CUCM/IMP distributed clusters with centralized Expressway server for MRA login. We did not wish to perf...
Parsec's Cisco UCCE/PCCE CC Connector application for CRM works as a bridge between the CRM and Cisco UCCE/PCCE CC solution.The CRM can be any cloud based CRM like Salesforce (SFDC), ServiceNow ,MS Dynamics or a 3rd party CRM.The CRM user/Agent will have ...
It’s a feature which allows CUCM to determine whether the phone is in its home location or a roaming station.By enabling this feature users can roam from one site to another site and acquire the site-specific settings such as Codecs, MRGL, Call rout...
Cisco just Announced their new Collaboration Toolbox resources portal. You can check it out here https://collabtoolbox.cisco.com/ It has a bunch of tools a partner can find helpful. But if your interested in learning which...