Latest Contributions by nishadwijesekara

Taking off STAThread is not the solution, it will seriously impact the application to be thread unstable and impact the performance a lot. The solution to this is to properly execute the GeoProcessing tools. Within this module, assign NULLs and release all objects properly. I had this problem for awhile, and this resolved my issue with running GeoProcessing tools within my Console Application. public static void RunTool(Geoprocessor geoprocessor, IGPProcess process, ITrackCancel TC) { // Set the overwrite output option to true geoprocessor.ClearMessages(); geoprocessor.OverwriteOutput = true; // Execute the tool try { geoprocessor.Execute(process, null); ReturnMessages(geoprocessor); geoprocessor = null; process = null; ESRI.ArcGIS.ADF.ComReleaser.ReleaseCOMObject(geoprocessor); ESRI.ArcGIS.ADF.ComReleaser.ReleaseCOMObject(process); } catch (Exception err) { ReturnMessages(geoprocessor); } } ... View more

Spatial views should be managed by using ArcSDE commands (use v 10.2.2) if you use SDE binary Storage type on 10.3 ... View more

Good move I would say, ... View more

This is a common problem Jerry as you can see in this forum and is a known issue acknowledged by ESRI. You are probably using SQL Server native Geometry type data on SQL Server 2012 connecting to ArcGIS 10.3.1 using SQL server native drivers which causes this problem. If the above setup is true for you, either of the following should work: - try to use SQL server 2014 with ODBC drivers - change all SQL server native Geometry/Geography types back to SDE binary - fine tune or create new SQL Server spatial indexes with Geometry type data (a brief procedure of that should be available in this forum) ... View more

Neil: I’ve got bunch of correspondence back and forth with ESRI and implemented many tests, so the information I passed were based on all of that. But I’m afraid I’m not sure if I can share the correspondence I had with ESRI on this forum as it involves many corporate information. But I have pretty much indicated the summary came out of that discussion. I cannot make any recommendations, you will have to test this yourself and see, if your plan is to use native Geometry with SQL server 2012 R2 PS2, you will have to disable hyper-threading and implement specific spatial indexing. I couldn’t go down that path as we could not disable hyper-threading. Nishad Wijesekara GIS Specialist, ext - 8370, TP: 403-387-8370 ALTALINK http://www.altalink.ca/ ... View more

Aaron: I came across the performance issue with Geometry data based on the connection between ArcGIS 10.3.1 (Server, Desktop) and SQL server 2012 SP2. This is mainly because of the bridge they have introduced with ArcGIS and SQL server 2012 which 64 bit SQL server native client drivers. ESRI is still working on this issue with Microsoft. ESRI used to have ODBC drivers connecting to SQL server, with SQL server 2014, they have changed the driver back to ODBC, this is why you experience it to be fast. We are migrating from 10.0 to 10.3.1. 10.3.1 ArcGIS seems to be full of issues and I tend to relate this experience to the Windows Vista release, ☺, ESRI need to put their fullest effort to resolve all these and come up with 10.3.2 soon. We have made our mind to keep our data as SDE binary, we used to have SDE binary with 10.0. Everything is fast, except for stopping and starting the map services compared to 10.0. Is there any other way to further fine tune the performance, we have rebuild the indexes, re-analyzed the tables and feature classes, etc. we still have hyper-threading on, cannot turn that off, it is a major infrastructure change. Nishad Wijesekara GIS Specialist, ext - 8370, TP: 403-387-8370 ALTALINK http://www.altalink.ca/ ... View more

We use esxi. Nishad Wijesekara GIS Specialist, ext - 8370, TP: 403-387-8370 ALTALINK http://www.altalink.ca/ ... View more

Does improving RAM, CPU power increase anything, we have 28 GB RAM and 4 Cores on the SQL server box. Nishad Wijesekara GIS Specialist, ext - 8370, TP: 403-387-8370 ALTALINK http://www.altalink.ca/ ... View more

We are going to setup ArcSDE 10.3.1 with SQL server 2012 R2 on Windows 2012 R2 environment. We experienced the same issue. However, SQL server 2012 with SDE binary (original geo-databases were on 10.0 with SDE binary and are upgraded to 10.3.1 with SDE binary) seems promising. Did disabling hyperhreading and applying https://support.microsoft.com/en-us/kb/2896720 resolve the issue of having SDE database with SQL server native Geometry type data ? ... View more