Latest Contributions by DavidColey

Absolutely, an we would like to leverage AD as well.  It's definitely a priority for us moving forward and I will certainly post back any info/results to this thread... ... View more

That's fine George, I was not unclear.  We purposefully moved to SQL Geometry at 10.0.  I am simply trying to explain to the community that spatial index levels and number of cells per level does have a performance impact.  We were able to solve that impact by tuning our levels and counts and I am just trying to pass that info along. David ... View more

Sure I understand.  We define all of our storage parameters upfront in our dbTune tables for location, type, page fill params, spatial index params and more and assign that to a VECTOR keyword.  Whenever we import or otherwise create data we simply use our keyword and in that way we are consistently set up across all of our user instances.  We moved away from SDEBINARY storage at 10.0, and after initial struggles isolating our performance issues (disk raid config, san vs local array, network I/O, indexing) using SQL GEOMETERY storage, found that the spatial index parameter adjustment had by far the greatest impact on our performance. For example, our parcels layer was never super speedy even stored as sdebinary, but was initially terrible at sql geometry.  After eliminating disk R/W, network I/O, memory paging, sql system database locations (esp temp db), primary and secondary data file storage locations and transaction log settings we found that the resetting the spatial index levels and cells per object greatly increased our desktop performance when usgin SQL GEOMETERY. David ... View more

What I mean is that when I publish a gp tool, I make sure the mxd itself and the data connections (or database in the case of a fgdb) contained in the mxd reside in the registered data store location... ... View more

Aaron - what do you mean 'The fact remains that SDE performance was better at SQL2008R2.'?  We have not found that to be the case at all, in the fact the opposite.  I replied earlier in this thread that tuning the spatial indices from the default Medium and 16 cells per level setting at all levels did not work well for complex polygon layers with lots of vertex and area variability.  For these layers, we did find that index of Medium, Medium, Medium, Low with 64 cells per object greatly outperforms the default setting at both SQL2008 and 2012. For point and polyline layers, we found no impact in draw and query times between our adjusted levels and cells per object and the default setting. David ... View more

Are you sure everything is running from a registered location?  Are you getting a clean result from the results window in ArcMap from which to publish the tool? ... View more

good to know, thanks ... View more

That is good news Michael! ... View more

glad to help ... View more

yes several months ago ... View more

Paul, its not that AD was unstable for us, its that we in GIS don't have any control over our AD and thus it was difficult to manage effectively.  For us, using GIS tier authentication gives us more fine grained control as we have fairly restrictive AD policies and so it didn't make much sense for us to try to mix AD with the bult in roles.  Also, our AD roles just weren't set up with server in mind, but rather for pure internal R/W access to various shares, etc. David ... View more

thanks sorry about that all ... View more

Hello all- The ArcGIS 10.3 for Server Map Cache Consumption Patch is the answer. After applying the patch, caches are now created using any tile management method and whether under load or not, cache directories are now renamed along with the service if a cached service is renamed, and service overwrites with a cache in place no longer leave behind a temp service. Thank you ESRI, I would consider this thread complete. David ... View more

Matt- I'd like to mark your reply as the correct reply to this long, long thread but unfortunately I didn't post this discussion as question.  Nevertheless, the ArcGIS 10.2.2 for Server Map Cache Consumption Patch is the answer.  After applying the patch, caches are now created using any tile management method and whether under load or not, cache directories are now renamed along with the service if a cached service is renamed, and service overwrites with a cache in place no longer leave behind a temp service. Same at 10.3. Thank you ESRI, I would consider this thread complete. David ... View more