1)Payara Server Can Detect and Log Slow SQL Queries Executed Via a Connection Pool.

The Slow SQL logger monitors all queries executed on the connection pool and if they exceed a configurable execution time in seconds, a warning message is logged into the server log. The warning message (see below) logs the SQL query and the stack trace to the code executing the query. This enables rapid diagnosis, pinpointing the exact lines of code to investigate.

To configure slow SQL logging via the administration console, navigate to the connection pool's Advanced Properties tab and specify the Slow Query Log Threshold time in seconds. A value of -1 disables logging of slow queries.

From within a system shell, we may run the asadmin monitor command to display real-time statistics. The --type parameter specifies which monitoring component should be monitored:



asadmin > monitor -- type = jvm

This command will log real-time data in intervals (every 30 seconds by default). We may redirect the output of the command to a file to archive monitoring information. There are 4 type of statistics we can monitor (arguments to --type parameter):

servlet

httplistener

webmodule

jvm



The command asadmin help monitor will provide detailed information about the monitor command.



Using asadmin, we can also access all the monitoring data by executing the following command:

asadmin > get -- monitor server .*

This command will return all available server and application monitoring data. This might easily be several hundred lines of text. Of course, we can use a more precise filter to limit the amount of data:

asadmin > get -- monitor server . transaction - service .*



Or we may request data only about a specific module, for example:

asadmin > get -- monitor server . transaction - service . committedcount - count

These commands provide exactly the same amount of information that is available through the REST interface. The last command corresponds to the following URL: http://localhost:4848/monitoring/domain/server/transaction-service/committedcount .

3) Payara Server Comes with a General Notification Service Which Includes the Request Tracing Service.

The Request Tracing Service provides tracing facilities for multiple protocols and process communications done by the components of deployed applications.

Because Request Tracing (and other monitoring) services depend on the Notification service to output their data, both the Notification service itself, and at least one notifier, must be enabled for any data to be recorded. If this does not happen, then the data will be discarded.

Below is a sample output from enabling the request tracing service in the admin console:

{ "traceSpans": [ { "operationName": "processContainerRequest", "spanContext": { "spanId": "5148919a-2413-4cbd-af6c-8cb469f8b0ec", "traceId": "e7ad7db6-b626-4995-aa10-e2e6a073033e" }, "startTime": "2018-04-10T11:15:50.018+01:00[Europe/London]", "endTime": "2018-04-10T11:15:50.164+01:00[Europe/London]", "traceDuration": "146000000", "spanTags": [ { "Server": "server" }, { "Domain": "domain1" } ] }, { "operationName": "authenticateJaspic", "spanContext": { "spanId": "374aefba-60ce-4011-98c5-9ade69eeeaeb", "traceId": "e7ad7db6-b626-4995-aa10-e2e6a073033e" }, "startTime": "2018-04-10T11:15:50.018+01:00[Europe/London]", "endTime": "2018-04-10T11:15:50.019+01:00[Europe/London]", "traceDuration": "1000000", "spanTags": [ { "Context": "" }, { "AppContext": "__asadmin " }, { "AuthResult": "true" }, { "Principal": "admin" } ] }, { "operationName": "processServletRequest", "spanContext": { "spanId": "fd66fafe-a741-408c-b99a-cb7a963c07ac", "traceId": "e7ad7db6-b626-4995-aa10-e2e6a073033e" }, "startTime": "2018-04-10T11:15:50.019+01:00[Europe/London]", "endTime": "2018-04-10T11:15:50.164+01:00[Europe/London]", "traceDuration": "145000000", "spanTags": [ { "referer": "[https://localhost:4848/common/index.jsf]" }, { "QueryString": "configName=server-config &b are=true" }, { "host": "[localhost:4848]" }, { "Class": "javax.faces.webapp.FacesServlet" }, { "Method": "GET" }, { "URL": "https://localhost:4848/payaraExtras/requestTracing/requestTracing.jsf" }, { "accept-encoding": "[gzip, deflate, br]" }, { "accept": "[*/*]" } ] } ] } 4) Payara Server Comes With Support Integration. For customers with a support contract, Payara Server comes with a customer support integration which allows customers to raise and manage tickets within the Payara Server administration console. The support page is accessible from the panel on the left of the admin console, just below the configurations. Logging In to Raise and Manage Tickets The Payara Server administration console allows you to log in, view existing tickets, filter tickets to find the one you're looking for, and create tickets and add relevant file attachments if necessary. The console makes it quick and easy to submit a request for support - just fill in the form and hit the submit button.

Full details and instructions for using our customer support feature is available in the technical documentation

5) Payara Server Provides Support for Custom SQL Trace Listeners.