Community
Select to view content in your preferred language

Every Service is a new connection to Database - running out of connections

1916
1
03-21-2013 08:37 AM
LuciHawkins
by
Frequent Contributor
‎03-21-2013 08:37 AM
Hi,

I guess this is by design in 10.1  Every published service on my Server is a connection to my SQL database.  With the default maximum connections being 64, I soon ran out of connections.  I increased that amount to 200 using the SDE command line interface and have not had the "no available connections" error anymore.  Just wondering how many connections is too many?

Also, we have 1 Windows 2008 R2 server with SQL 2008 R2, Esri Server 10.1 and Web Adaptor installed.  (SDE is not installed - all connections are direct).  For production we have a SQL GDB that is maintained by 1 GDB Admin and 3 GDB Editors.  The SQL GDB is then replicated to another SQL GDB on the same SQL server and between 50 and 100 users view that replicated data using our Flex Viewer app.

So, I guess my question is which of the following scenarious is better or are they equivalent?

65 mxd's published as a Service to Server and making 65 connections to replicated GDB

or

1 mxd that contains same data as in the 65 mxd's published as a Service to Server and making 1 connection to replicated GDB


I am still a tad confused when it comes to the difference between Pooling - Number of Instances  AND  Processes - Run instances in High or Low isolation and how many instances.

Anyone have any thoughts?

Thanks,

Luci
Tags (2)
0 Kudos
1 Reply
TonyContreras
by
Deactivated User
‎03-22-2013 02:30 PM
You could set up one map service that gets served to everyone, then take advantage of dynamic layers in each application to display the features according to the audience. This will greatly decrease the number of connections and increase performance since there will not be 65 separate services running at the same time.

Without going into too much detail I would recommend using pooling and low isolation (no more than 4 instances per process to help with stability). This will reduce the number of ArcGIS Server processes running on the Server, which translates to fewer connections to the database or SDE service.

About dynamic layers

Flex Samples using Dynamic Layers
0 Kudos