Author Topic: third-party-max-queuing-time  (Read 2578 times)

Offline guillote57

  • Newbie
  • *
  • Posts: 5
  • Karma: 0
third-party-max-queuing-time
« on: November 24, 2009, 06:36:30 PM »
Hi, again !

Someone knows what the optimal value for option option "third-party-max-queuing-time".

Offline René

  • Administrator
  • Hero Member
  • *****
  • Posts: 1832
  • Karma: 62
Re: third-party-max-queuing-time
« Reply #1 on: November 24, 2009, 07:19:08 PM »
Hi again :)

Something like general optimal value doesn't exist as it tightly depends on particular deployment. You should take into the account factors like number of interactions, type of requests (Identify Contact vs. Create Interaction etc.), number of requests, UCS DB size and HW sizing of database server etc.

R.

Offline guillote57

  • Newbie
  • *
  • Posts: 5
  • Karma: 0
Re: third-party-max-queuing-time
« Reply #2 on: November 24, 2009, 07:43:43 PM »
rene,

Thanks for the answer, I guessed that there was an optimum value, I
declared the installation default value is 15,000 ms
thanks again for your time.
A data base has 10 GB and is running on a sql server 2005 installed on a Windows Server 2003 R2 SP2, with 4GB of memory a processor dual core Xeon 2.6 Ghz and 300 Gb disk in RAID 1

Best regards
Guillermo

Offline René

  • Administrator
  • Hero Member
  • *****
  • Posts: 1832
  • Karma: 62
Re: third-party-max-queuing-time
« Reply #3 on: November 25, 2009, 02:53:53 PM »
Hi Guillermo,

Personally, I would say that default 15 seconds timeout should be sufficient. If it isn't then I would recommend you to analyse why simple operations like Identify Contact takes so long (313 seconds in the log you posted in other thread). Maybe some index is missing or is too fragmented...

R.

Offline guillote57

  • Newbie
  • *
  • Posts: 5
  • Karma: 0
Re: third-party-max-queuing-time
« Reply #4 on: November 25, 2009, 03:03:52 PM »
Thanks Rene

I will verify all indexes of the table and the fragmentation of the same.
Any other questions you have can consult you ?

Guillermo