Latest Contributions by AnthroSys

Environment Product: ArcGIS Monitor Version: 10.7.1.1145 Platform: Windows 2016 Standard Item -> Site-> Collection-> Monitor Service-> Server-> Config-> [Sample Interval] Recommendation Function: Multiple Sample Intervals Reason: Allow Servers to be monitored at Intervals appropriate to operational circumstances Case: Monitor at - shorter intervals during production hours, shorter hours during maintenance hours Example: 1 or 5 minute intervals during production. 15 or 30 or 60 minute intervals during maintenance. Summary Multiple Sample Intervals (at least two) allow monitoring to match operational circumstances and variable SLAs. ... View more

Summary - SQL Server Compatibility Level 130 (from 2012 Compatibility Level 110) resolves slow Data Access Issue - Configuration - Windows 2016, SQL Server 2016 upgraded from SQL Server 2012, ArcGIS Desktop 10.6 - Pre-Condition - The SQL Server 2016 Server used to be SQL Server 2012 Issue Feature class of 10 of thousands of points takes long to load - Load time of 1 and 2 minutes Troubleshoot - Load to New SQL Server 2016 - Effect (Loads in 1 to 2 secs) -- Only difference in settings - SQL Server Compatibility Level  --- Original Server  - 110 --- Test Server - 130 Solution - Change Original Server Compatibility Level from 110 to 130 - Resolved ... View more