AGS log Severe/Warnings missing in Monitor?

[Ravichandran_M_Kaushika]

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.

[JohnGraham2]

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

[Ravichandran_M_Kaushika]

dear John Graham,

good morning.  thank you for the information.

regards

ravi.

[Ravichandran_M_Kaushika]

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:

1. ArcGIS Monitor machine without IIS - name = myArcGISMonitorMachine.  
2. AGS MainServer configured as LB = myArcGISServer00
3. 2 load balancing machines myArcGISServer01 and myArcGISServer02 (both listed as machines on myArcGISServer00/ArcGIS/manager.html site).

Main Question:

1. on IIS log path: example: \\myserver\inetpub\logs\LogFiles\W3SVC1 - is the mention; does that myServer represent myArcGISMonitorMachine, myArcGISServer01, or myArcGISServer02.  I tried to force it on \\myArcGISServer01\inetpub\,,, \after allowing read write to inetpub and it failed.  Which gave an error:System.Exception: An error occurred during log collection: Could not assemble log file list from the specified disk location! Access to the path '\\myArcGISServer01.myDomain.Com\inetpub\logs\LogFiles\W3SVC1' is denied. at ESRI.PS.EIST.SystemLogParser_Plus.CLI.StartHere.Main(String[] args)
2. Where do the logs from myArcGISServer01 failure logs reside on the framework I had mentioned?

thanks for your support

regards

Ravi.

[JohnGraham2]

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

[Ravichandran_M_Kaushika]

John,

good morning. thanks for your quick reply.  should myServer used in the example be one of:

1. myArcGISMonitorMachine,  (does not have IIS)
2. myArcGISServer00 LB for the following severs:,
   1. myArcGISServer01, or 
   2. myArcGISServer02. 

thanks for your support

regards

ravi.

[JohnGraham2]

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