dear Readers,
thank you for taking the time to help me out.
we have setup a test AGS monitor inside our firewall. AGS monitor is very quick to point out infrastructure issues.
Map and feature server services were published from SQL Server layer/ spatial table w attributes with upwards of 5 million records to 'trigger' meesages on ArcGIS Monitor software.
This error was present on ArcGIS server hosting the feature and map server services.
SEVERE | Apr 22, 2019, 11:15:41 AM | Error: Underlying DBMS error [[Microsoft][SQL Server Native Client 11.0][SQL Server]The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users. Ask the database administrator to check the lock and memory configuration for this instance, or to check for long-running transactions.] [MyDBName.dbo.VW_LayerName_SHAPE_P_***]. | cpDelMe/myServiceName.MapServer |
When we consumed these services in ArcGIS pro it started behaving inconsistently when the feature server was selected for visibility and panning. Panning and Zooming created the above error messages.
ArcGIS monitor did not record any service errors but pointed out that more than 85% of the processor resources have been used and only than 1GB was available at the server's disposal. There were many instances of the above error messages when there was a server request to the database.
How to get these messsages to show up on ArcGIS Monitor? We could not locate the config documents to pipe the information to ArcGIS Monitor.
thanks for your help.
regards
ravi Kaushika.
Hi Ravi,
Sounds like ArcGIS Monitor is already alerting on a system level resource bottleneck where SQL Server is running. To get more details from the logs in ArcGIS Monitor, I suggest using the System Log Parser extensions for IIS and ArcGIS Server.
Best Regards,
John
dear John Graham,
good morning. thank you for the information.
regards
ravi.
dear John Graham,
good afternoon. We have the following setup - main reason why I am explaining this is because we are unable to configure IIS log.
We have the following setup:
Main Question:
thanks for your support
regards
Ravi.
Hi Ravi,
myServer is the machine where IIS is running and writing the log. On that machine there should be a folder: inetpub\logs\LogFiles\W3SVC1
with existing log files.
Best Regards,
John
John,
good morning. thanks for your quick reply. should myServer used in the example be one of:
thanks for your support
regards
ravi.
Hi Ravi,
If the Web Adaptor for IIS was installed on myArcGISServer01, IIS is running there and should have a log folder \\myArcGISServer01\inetpub\logs\LogFiles\W3SVC1
If the Web Adaptor for IIS was also installed on myArcGISServer02, IIS is also running there and should have a log folder \\myArcGISServer02\inetpub\logs\LogFiles\W3SVC1
After you find the folder, make it a Shared folder in Windows so the other machine running ArcGIS Monitor can access it from \\myArcGISServer01\inetpub\logs\LogFiles\W3SVC1
Hope it helps,
John