When login to a Web Page or performing a database query on a Subscriber that is remote, the user may experience a delay higher than trying on a server that is located next to the Publisher or the Publisher itself.
The same do not happen if login is performed to the OS or Seviceability pages on any servers.
The Subscriber CCM subcomponent connects to the Pub as long as the Pub is reachable, therefore WAN delay will affect subsequent SQL queries.
The root cause for this problem is the delay in the network (WAN).
A server located next to a Publisher with ping response times of 1ms then will open the website in less than 2 seconds.
A server located remotely with 40ms of delay will take up to 40 seconds to open the same Admin page.
The OS adminitration and Serviceability pages are local to the server as they manage the local resources, therefore they respond faster.
To understand better this look at the following image:
1- Http request is made
2- Database query or Login query from Subscriber is made to the Publisher
3- After processing, the response is sent to the Subscriber
4- The HTTP results are displayed in the PC.
Keep in mind that a login have about 200-300 successive SQL queries that need to go back to pub DB to populate the menu screen.
Same happens when you try to search something that requires DB intervention, such as search phones.
You can see this delay in the CCMAdmin web service logs:
These 3 queries took 1 second each to process in a 40ms delay network.
2012-10-18 16:55:52,239 DEBUG [http-8443-Processor22] actions.GenericFindListAction3 - Executing SQL :: select PSF.ENUM from ProductSupportsFeature AS PSF, Device as DV where PSF.tkproduct = DV.tkproduct and PSF.tksupportsfeature= 3 and DV.name='SEP2C36F85935AD'
2012-10-18 16:55:53,064 DEBUG [http-8443-Processor22] actions.GenericFindListAction3 - Executing SQL :: select PSF.ENUM from ProductSupportsFeature AS PSF, Device as DV where PSF.tkproduct = DV.tkproduct and PSF.tksupportsfeature= 3 and DV.name='SEP44D3CA7B8EFE'
2012-10-18 16:55:54,228 DEBUG [http-8443-Processor22] actions.GenericFindListAction3 - Executing SQL :: select PSF.ENUM from ProductSupportsFeature AS PSF, Device as DV where PSF.tkproduct = DV.tkproduct and PSF.tksupportsfeature= 3 and DV.name='SEP2C36F8599515'
Therefore this query took about 5 seconds to update the Web admin screen.
Currently using CISCO express across three sites and I am based on one site I use CISCO supervisor to listen in on calls but can only listen in to calls received into my site. I really need to listen into calls into all sites. Any ideas???
Hello AllI would like to set up a CUCM/CUC/Presence home lab to understand things in deep such as registering SIP gateways, route patterns, etc. I have brought a couple of 2911's, 3850's and IP phones and I7 8th gen 16GB laptops for lab sakeCould someone ...
We've had a couple of instances where users accidentally dial something like "9118883540". The call isn't recognized as a 911 call by CUCM, so it just routes it to our SIP Provider (Centurylink). Centurylink treats it like a 911 call. CER doesn't get trig...
Hi, We are working on an integration with Cisco UCCX (126.96.36.19901-34).We need to get skill aggregated data in 15 minute intervals.The skill data that is needed per interval is: Call volume (handled + abandoned), Handled calls, Average...