BLOG
|
@Hi @AndrewSakowicz , I ran a report from ArcSOCOptimizer (source_code-20230530.1) on ArcGIS Monitor 2023.2. I also exported a report from ArcGIS Server 10.9.1 statistics on MaxInstnaceUsed in 30 days. I compared the two results and the MaxInstanceUsed are not the same in ArcSOCOptimizer and ArcGIS Server Statistics: ArsSOCOptimizer reports for past 30 days for NBGas_Landbase service: max instance used = 15 ArcGIS Server statistics report for 30 days for NBGas_Landbase service: max instance used = 5 Question: how does ArcSOC Optimizer collects the Max Instanced Used compared to ArcGIS Server Statistics? When should I use ArcSOC Optimizer and ArcGIS Server Statistics ? Many thanks ! Anthea
... View more
01-24-2024
11:54 AM
|
0
|
0
|
661
|
POST
|
Hi All, Have downloaded the ArcGIS Monitor 2023.3 and applied this upgrade. For this release, it states supporting SQL Server components. I tried to connect to Azure SQL Database using instance name ppp-xxxx-gissavy.database.windows.net:1433, ppp-xxxx-gissavy.database.windows.net, internal IP Address of this instance and these tests gave this error : cannot process request for specified agent. I tested connecting using SQL Server Management Studio and it works (using ppp-xxxx-gissavy.database.windows.net). Question: does this release support Azure SQL Database? Thank you Anthtea
... View more
12-21-2023
07:07 AM
|
0
|
2
|
865
|
POST
|
Hello, What are some of the best practices in customizing alerts on certain mapservices that are problematic (slow performance, lots of critical alerts in ArcGIS Monitor 2023 Collection dashboard) ? Out of the box, each components by default collects Averages, Std Deviation, Min and Max but do not include Aggregreates at 75%, 90% 95% etc.. Also which of the metric name(s) above to modify to produce a meaningful Aggregate at 95% ? Thank you!
... View more
11-07-2023
02:50 PM
|
0
|
1
|
250
|
POST
|
Hello there! We are using ArcGIS Enterprise 10.9.1 with Azure SQL Database. The defrag % output from Egdb compare to Azure SQL Database query shows different values. Wondering what could be the reason the values are different for the same table? For example in the perf_FragmentedIndex tab in the export.xlsx file after a run: Egdb perf_FragmentedIndex report shows 99.26% defrag: database_name owner indexed_object_name table_type index_name avg_fragmentation_in_percent in_row_reserved_page_count WATER xx WATERJUNCTIONOBJECT User Table UUID_51 99.25765543 3290 Azure defrag query shows 5.79% defrag: schema_name object_name index_name index_type avg_fragmentation_in_percent avg_page_space_used_in_percent page_count alloc_unit_type_desc xx WATERJUNCTIONOBJECT UUID_51 NONCLUSTERED 5.79854208084824 96.4498393872004 3018 IN_ROW_DATA SELECT OBJECT_SCHEMA_NAME(ips.object_id) AS schema_name, OBJECT_NAME(ips.object_id) AS object_name, i.name AS index_name, i.type_desc AS index_type, ips.avg_fragmentation_in_percent, ips.avg_page_space_used_in_percent, ips.page_count, ips.alloc_unit_type_desc FROM sys.dm_db_index_physical_stats(DB_ID(), default, default, default, 'SAMPLED') AS ips INNER JOIN sys.indexes AS i ON ips.object_id = i.object_id AND ips.index_id = i.index_id ORDER BY page_count DESC; Thank you !
... View more
09-28-2023
11:35 AM
|
1
|
0
|
270
|
POST
|
I was able to use a custom script to run the exe and then send the file afterwards in Email.
... View more
09-25-2023
02:32 PM
|
0
|
0
|
238
|
POST
|
Hello, We are using ArcGIS Monitor 2023.2. We have downloaded the ExcelReport and it ran good. Is there a way the ExcelReport can send an Email with the attached output file? Thank you Anthea
... View more
09-22-2023
12:02 PM
|
0
|
1
|
324
|
POST
|
Hello Good Day, We have 1000 ArcGIS Pro Single Use licenses that will be authorized on approximately 500 Virtual Desktops and users laptops. There is a process we have where we re-install ArcGIS Pro twice a year with newer versions on Virtual Desktops and users laptops. Is there a way to recover Pro Single Use licenses each time with newer Pro versions with a script instead of manually recovering each single use licenses in My ESRI ? Thank you Anthea
... View more
09-12-2023
07:05 AM
|
0
|
0
|
236
|
POST
|
@JamesBratton take the ID in the log and login to Postgres DB and query the observers table to find component_id related to the ID. Then query the components table with the component_id in question : Sample: SELECT * FROM public.components where id = 3562021
... View more
08-30-2023
08:29 AM
|
1
|
0
|
968
|
POST
|
Hi @MarceloMarques thanks you so much for the helpful information above ! The above Query was from Prod and we have ArcGIS ServerUN patch 3 applied. It does not look like the patch is resolving the MAXDOP issue for us. Will log a ticket with Support. Anthea
... View more
08-30-2023
06:14 AM
|
1
|
1
|
661
|
POST
|
Hello, We are using Azure SQL Database with ArcGIS Enterprise 10.9.1. In Azure Portal, we noted in the Database Performance Overview, there are some long running queries. Picked one of the long running queries and here is the SQL: (@P1 varbinary(max),@P2 datetime2(7),@P3 varbinary(max))select SHAPE, SUBNETWORKNAME, OBJECTID,XXX_NETWORK.UNADMIN.ELECTRICSUBNETLINE.GDB_GEOMATTR_DATA from UNADMIN.ELECTRICSUBNETLINE WITH (FORCESEEK INDEX(R50_pk)) WHERE UNADMIN.ELECTRICSUBNETLINE.GDB_ARCHIVE_OID IN (SELECT GDB_ARCHIVE_OID FROM (SELECT GDB_ARCHIVE_OID,SHAPE,ROW_NUMBER() OVER(PARTITION BY OBJECTID ORDER BY GDB_FROM_DATE DESC) rn_, GDB_IS_DELETE FROM UNADMIN.ELECTRICSUBNETLINE WHERE OBJECTID IN (SELECT OBJECTID FROM UNADMIN.ELECTRICSUBNETLINE WITH (INDEX(S20_idx)) WHERE ELECTRICSUBNETLINE.SHAPE.Filter(@P1) = 1 ) AND GDB_BRANCH_ID = 0 AND GDB_FROM_DATE <= @P2 ) br__ WHERE br__.rn_ = 1 AND br__.GDB_IS_DELETE = 0 AND br__.SHAPE.Filter(@P3) = 1) OPTION (RECOMPILE, MAXDOP 1) By default Azure SQL Database is set to use MAXDOP 8. The Query above is recompiled with MAXDOP = 1. The above Query is coming from ArcGIS Pro usingbranch versioning via REST service. Questions: Is MAXDOP = 1 the best setting for overall performance for all transactions? Where is the Query hint with Recompile option injected from? In ArcGIS Pro? In REST API? or in a stored procedure in ArcSDE? Thank you! Anthea
... View more
08-29-2023
01:42 PM
|
0
|
3
|
1220
|
POST
|
@GeoJosh oh boy not sure why I missed that expand icon in the Log. I got it now thanks !
... View more
08-25-2023
01:10 PM
|
0
|
0
|
993
|
POST
|
Hi @GeoJosh the log did not indicate which component is not available. I tried to change the Log setting to verbose and there is not much information. Is there a way I can check? Thanks!
... View more
08-24-2023
08:38 AM
|
0
|
2
|
1005
|
POST
|
Hello, We are running Monitor 2023.2. I checked the Logs in Monitor and saw there were pages of Severe level entries filling up quickly. What causes the Monitor this error and how to fix this ? Thank you! Anthea
... View more
08-23-2023
11:04 AM
|
0
|
7
|
1081
|
POST
|
@GeoJosh thanks for letting me know. I upgraded to ArcGIS Monitor 2023.2 and it works good now.
... View more
07-31-2023
02:07 PM
|
0
|
0
|
454
|
Title | Kudos | Posted |
---|---|---|
1 | 09-28-2023 11:35 AM | |
1 | 08-30-2023 08:29 AM | |
1 | 08-30-2023 06:14 AM |
Online Status |
Offline
|
Date Last Visited |
Thursday
|