Monitoring perfromance of xMII v11.5

[Former Member]

I am working to define some performance monitoring standards for our xMII servers. I did see some SAP notes that this is improved in v12 by using Netweaver CCMS, but with all that is involved with migrating I don’t think that it is likely we will pursue this in the near future. I am wondering if anyone can provide any direction or recommendations for monitoring performance of xMII v11.5? I did find some general information from Microsoft on performance counters for IIS, but I was wondering if there is anything specific from an xMII perspective? Any feedback would be appreciated.

[jcgood25 · Accepted solution]

Rob,

With 11.5, anything IIS performance monitoring related would be best guided from Microsoft's website, but as far as xMII goes your basic options are to monitor the General Log (links in the Log Management section of the Menu.jsp) for application related errors, and the System Stats Log for active sessions, Java Memory logging, and Data Server query volumes. There are other log entries to look at, but from a general 'health' of the system these two will give you the most pertinent details related to application problems or performance related concerns.

Monitoring these logs obviously requires a bit of manual intervention and supervision, whereas Venkat can direct you on the automated performance monitoring hooks.

Regards,

Jeremy

[Former Member]

Would sql queries executed in BLS transactions be logged as part of this user as well?

[Former Member]

We see a number of username "localadmin" entries in the cmssysstats log files, but no such user exists in the system. These seem to correspond with other usage in the system and these are not being counted as part of the active user statistics, which seems to indicate that it is something system generated.

Can anyone ellaborate on where these come from?

[jcgood25]

These entries are most likely being caused by http://localhost requests from someone working directly on the server itself or through remote desktop.

Regards,

Jeremy

[salvatore_castro]

Robert,

You are correct, the localadmin user is used by xMII for background operations...such as runnnig a transaction from the scheduler. It will not appear in the user list since it's not a true user which can be modified. However if you login to xMII from the local machine http://localhost/Lighthammer you will be logged in under this account which can also generate usage statistics.

Hope this helps.

Sam

[Former Member]

I have setup an application to take the data from the System Stats log and put it into PI for analysis and trending, but have some questions about what the data actually shows.

Is anyone aware of existing documentation that explains the different entries. For instance, "is the active users just a point in time entry or does it look over the entire interval to determine the number of active users?", "are the data server entries cummulative over the interval or averages?", "what are the units for time to run?"

[jcgood25]

BTW - interesting use of your process historian

The intervals in the stats log depend upon the particular item itself, hourly, etc.

Active users should be essentially a current snapshot of who's logged in (similar to the html table you see when you run the Active Sessions web page) and unique users lets you differentiate between redundant logins.

System memory stats are similar - just an active snapshot of the present state of affairs.

The Data Server stats are more usage based and incremental, meaning that if a given data server is not accessed in the log interval it will not be mentioned. The same is true for user to data source requests and rows of data requested. This usage data allows you to see usage patterns and potentially look for users requesting out of the ordinary volumes of data that could lead to data server stress and/or server memory and cpu burden. The in state memory holders for these log entries are cleared after the log entry is created, and the counting/capturing starts over until the next interval.

Regards,

Jeremy

[Former Member]

Hi Guys,

I am responsible for SAP xMII 11.5 integration with Introscope.

Reply back with your requirements.

Regards

Venkat

[Former Member]

At this point we are trying to see what can be monitored before formalizing our requirments. At a minimum, we will want to monitor user sessions and durations, query execution times, BLS execution times.

[salvatore_castro]

Robert,

There is a real-time monitor page built into xMII under System Management -> System Administration. You have to have this page open for it to collect but it will tell you the runtime information of your system. This combined with the built in Windows Performance Monitor will tell you everything you need.

Sam

[jcgood25]

...which is why I recommended the logs, since the system memory related stats (and others) are logged periodically

[Former Member]

Venkat,

Can you please send me a cut sheet on what is available through your xMII agent?

[Former Member]

Hi Robert,

Please email me at venkat.mahalingam@sap.com, and I will send it across.

I would prefer not to share this document in SDN.

Regards

Venkat

[sufw]

Hi Robert,

I know that CA Introscope has a monitoring agent for xMII 11.5 which runs inside the JVM on the xMII server and can do realtime performance monitoring and alerting, but I haven't tried this (yet)...

Sascha