[asterisk-users] Asterisk AGI issues (at high load)

[Jeff LaCoursiere]

On Thu, 4 Jun 2009, Deepak wrote:

> It was not a conscious decision to use MS-SQL. We were "forced" to use
> MS-SQL since the "business" rules were on MS-SQL and other apps are using
> it.
>
> If you think it is not ODBC, then what in your opinion is causing the issue?
> I though you did mention that in your opinion database might be the
> culprit...
>
> Thanks in advance
>
> On Thu, Jun 4, 2009 at 3:23 PM, Steve Edwards <asterisk.org at sedwards.com>wrote:
>
>> On Thu, 4 Jun 2009, Deepak wrote:
>>
>>> BTW,we are using an ODBC connection to Microsoft SQL Server. We are not
>>> using MySQL.
>>>
>>> Would that be a possible cause?
>>
>> Probably not the cause, unless there is a bug in ODBC.
>>
>> But, it does multiply your support costs.
>>
>> Not because of the obvious "you have to pay MS license fees," or "it uses
>> more resources," or even "I can't ssh into it to fix it for you" but
>> because you have stepped outside of the "norm" of what people on this list
>> use so we will not be able to help much.
>>
>> If I was to guess, I'd say 99% use MySQL, 1% use PostgreSQL and something
>> very close to 0% us MSSQL.
>>

It is more likely the *way* you are using the ODBC connection.  If your 
instances are taking up so much memory, your SQL calls are probably very 
inefficient.  It is going to be very hard for anyone on the list to 
pinpoint your actual problem without seeing your code.

j