NAV2009 Webservice using multiple SQL connections

Sog · 2013-03-21

Hello everybody.

We have a website that communicates with NAV trough a webservice.
When the website is being used, we sometimes see the webservice using multiple (SQL) connections and thus multiple licenses.
(not multicompany nor multiple instances of webservices).
I was not aware that the webservice would behave like that.
Can anybody shed some light on this?

Thanks in advance

Sogg

kriki · 2013-03-21

Each call to the NAV 2009 webservice (same goes for each RTC-session) is a session in itself and each one opens its own connection to SQL Server, so, yes, it is possible to see multiple sessions in SQL Server that come from the NAV webservice.

In NAV2013, this behaviour is changed. The Dynamics NAV server opens 1 connection to SQL and all sessions connecting to that Dynamics NAV Server uses that 1 connection to SQL Server.

Sog · 2013-03-21

Thank you for your prompt response kriki.

Sog · 2013-03-25

A followup question about this:
Are there extra NAV sessions used when the webservice uses more than 1 sql connection?

kriki · 2013-03-26

No.

But you can put a limit to how many calls can be done at anyone time to the webservice. It is a parameter "MaxConcurrentCalls" (default=40) in the CustomSettings.config-file of the service.

Howdy, Stranger!

Quick Links

Categories

NAV2009 Webservice using multiple SQL connections

Answers