FAQ: Why have the connection times to ArcSDE slowed down when using ArcGIS Desktop versions 9.2 and later?
Why have the connection times to ArcSDE slowed down when using ArcGIS Desktop versions 9.2 and later?
In ArcGIS Desktop 9.2, additional logic was added that runs during the initial connection to an ArcSDE geodatabase. The connection to the geodatabase may take longer when using ArcCatalog, or the Add Data dialog box in ArcMap, if there are a large number of tables or a large number of users in the geodatabase.
Examples of configurations that are known to be slow include the following:
A) ArcSDE geodatabases for Oracle or Informix that have 2,000 to 10,000 tables in the database.
B) ArcSDE geodatabases for SQL Server, when 500 to 2,000 tables are present in the database.
C) ArcSDE geodatabases for DB2 with 2,000 to 10,000 tables in the database.
For all these cases, ESRI recommends installing the ArcSDE 9.2 Connection Performance and Geodatabase Repair Patch referenced in the Related Information section below.
For case B, specifically, there is an open bug with Microsoft (SRX080911601661) that, when addressed, further improves connection performance.
For case C, slight improvements in connection times may be seen; however, ESRI is working on additional improvements.
If using ArcSDE Personal for SQL Server Express, it is not expected that the number of users and tables necessary to slow down a connection will be reached. However, if slow connections are experienced, install the direct connect drivers available with the patch on the ArcGIS machines. This provides the same code changes for that ArcSDE version with no upgrade necessary.
- ArcSDE 9.2 Connection Performance and Geodatabase Repair Patch
- Diagnose ArcSDE connection and performance issues using SDEINTERCEPT