https://community.esri.com/t5/developers-questions/why-snapshot-isolation-should-be-turned-on-at/m-p/1205312#M6334 <P>Hi,</P><P>After upgrading ArcGIS to 10.9.1 (server), we noticed that our implementation solving routes start crashing for large input to solve. ESRI.ArcGIS.NetworkAnalyst throws an error about table name '##SDE_Session...' being not valid.</P><P>During investigation I have found out that actual error in SQL Server is that Snapshot Isolation is not turned on at tempdb database. After turning it ON errors are solved. But..</P><P>According to our IT guys doing that could cause performance issues.</P><P>Question: Why it is required to have Snapshot Isolation turned ON at tempdb?</P> Tue, 23 Aug 2022 10:06:49 GMT JuliusDobravolskas 2022-08-23T10:06:49Z https://community.esri.com/t5/developers-questions/why-snapshot-isolation-should-be-turned-on-at/m-p/1205312#M6334 <P>Hi,</P><P>After upgrading ArcGIS to 10.9.1 (server), we noticed that our implementation solving routes start crashing for large input to solve. ESRI.ArcGIS.NetworkAnalyst throws an error about table name '##SDE_Session...' being not valid.</P><P>During investigation I have found out that actual error in SQL Server is that Snapshot Isolation is not turned on at tempdb database. After turning it ON errors are solved. But..</P><P>According to our IT guys doing that could cause performance issues.</P><P>Question: Why it is required to have Snapshot Isolation turned ON at tempdb?</P> Tue, 23 Aug 2022 10:06:49 GMT https://community.esri.com/t5/developers-questions/why-snapshot-isolation-should-be-turned-on-at/m-p/1205312#M6334 JuliusDobravolskas 2022-08-23T10:06:49Z