Latest Contributions by DavidColey

Vince - Yes thanks rest assured we review proceedures with each release.  Yes, we are at 2008R2 and want to move to 2012 but are trepidicious about geometry performance.  My post SQL Server 2012 and 2008: Geometry Performance | GeoNet asks whether anyone has experienced increased or decreased geometry performance at 2012 but it has recieved no replies since June of this year.  As an SDE admin, I dislike using spatial views but must for certain datasets.  Performance is always an issue, and they are clunky to serve.  ... View more

Thanks.  I believe Ronnies comment from 2 weeks ago says that the issue still exists.  Like you say, we're just dealing with it.  Long-term, I am always concerned with constantly stopping and starting the Server windows service from a stability standpoint, so hopefully esri will resolve this locking issue (soon!) ... View more

Hi Vince- We are at the latest 10.2.2 patch release, with SQL Server 2008.  To be honest, I don't really know other than we always had difficulties registering our spatial views if we created them in the RDBMS first, as the operation would throw an error, either in command line or in the GUI.  I suspected that the system tables weren't handling the Shape column and so we always relied on create_view (hence my disagreement with 'rarely used').  I understand that each storage type has a best practice, but haven't read any documentation stating that when using SQL Geometry views should be constructed via the RDBMS.  We'll be performing some more testing and I'll get back to this thread asap. ... View more

I certainly agree with you Jeff.  My guess is true centering would require handling screen dimensions and pixel densitites? ... View more

You are correct Bob.  I started this thread because, at 10.2.2, the locks were not being handled when caching services under load in a clustered environemnt.  Prior to 10.2.2 we experienced many incomplete caches, but we never encountered the cache corruption due to a .bundle files' exchange (bundlex) file being removed without also removing the bundle. The whole point here is that prior to .2, caching services under production was a never a problem in a clustered environment. We may have had to re-create missing tiles, but never had bundle file removal issues and as such never had to create and cache staging services. Now, I have essentially re-instanciated my pre 10.1 method of caching a stage service, and then moving its bundles into my production services' layer directory structure.  Disappointingly, as of yesterday's testing I re-discovered that in order to completely remove the production cache files, I must stop the ArcServer service on each produciton machine..  In earlier testing, I was somehow I was gettting away with only stopping the production cachce service (apologies to Bob). ... View more

I totally agree with Jeff.  We have always created our spatial views in CommandLine and then modified them as necessary in SSMS since 2006, and since moving to SqlGeometry in 2010.  We have never gotten consistent results using Vinces' method becasue of the behavior diffculties with SQL Geometry Shape column. So, I would say that I don't agree with his 'rarely_used' assessment. ... View more

I have no idea either as ESRI hasn't put up the NIM list yet. David ... View more

Jake has the correct answer, my apologies.  ... View more

Jamal- The short answer is you can't. But you can make the data appear to come from one service if you call the layers in as FeatureLayers in say a JavaScript API client, and then render the buildings identiacally in the applicaiton. David ... View more

Marco- You just need 1 licence of ArcServer Basic, Standard, or Advanced.  ... View more

Agreed.  I completely had to make sure that I had no left over .glock files in my config or missing bundlex files in my directories (at all cache levels).  I did that by tearing down and recreating both the public production and secured private services and caches.  Not insignificant as I have both local (for Mobile, ArcPad), and web mercator basemaps and street framework caches.  Same as you I'm sure. Then I could use the remdir and xcopy method.... ... View more

Yes, once you apply the patch to desktop, you then update all of your SDE instances.  We have like 15 one-way rep pairs going from 5 edit parent sde instances to our 1 production child sde instance . . . no problems.... ... View more

Hi Bob- what your doing will definently work.  I'm taking a slightly diffrerent approach that may be less intensive step-wise but requires duplicate services and a bit more drive space so it may not work for everyone: 1. I created duplicate services and caches on my production server, and secured them. 2. Run my recreate all tiles python scripts on the secured servcies. Becasue these protected services are not under load, recreating all tiles does not fail. At least it hasn't yet 3. I then use windows commands in a bat to remove the prodcution cache directories, and xcopy the protected bundles over. That's it.  In this way, I don't have to worry about locking or exporting caches or restarting services, and everything can still run by the task scheduler.  But again whatever works for your environment, setup, security and all of the contstraints we all face . . . ... View more

Hello- If you apply the: ArcGIS 10.2.2 for (Desktop, Engine, Server) Geodatabase and Feature Service Sync Optimization Patch published on 10-06-2014 to your desktop and Server, you then will be required to updgrade your sde instances via the desktop. Upon upgrade, the Upgrade Status for Database Properties in your ArcCatalog SDE connections will read: 'This 10.2.2 Patch 2290200 geodatabase matches the ArcGIS release you are currently using.' We are also a SQL2008 R2 shop and have encountered no issues with this patch.  Performance seems a little better, syncs seem more stable. ... View more

I apologize Jamal, but I don't think I am of much help.  All I can say is that no one can extract or edit data from my public map services unless I specifically allow it as I outlined above.  David ... View more