mravichandran

AGS log Severe/Warnings missing in Monitor?

Discussion created by mravichandran on Apr 22, 2019
Latest reply on May 10, 2019 by jgraham-esristaff

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.

SEVEREApr 22, 2019, 11:15:41 AMError: 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.

Outcomes