Over a million developers have joined DZone.

New Features for Ops Teams in Payara Server

Operations Teams will be happy to hear that the February 161 release of Payara Server adds Slow SQL Logging and inbuilt Server Healthchecks as new capabilities for managing production workloads!

· Cloud Zone

Build fast, scale big with MongoDB Atlas, a hosted service for the leading NoSQL database on AWS. Try it now! Brought to you in partnership with MongoDB.

When we founded Payara and started development on Payara Server, one of our key goals was to make Payara Server the best application server for production workloads. Operations Teams will be happy to hear that the February 161 release adds Slow SQL Logging and inbuilt Server Healthchecks as new capabilities for managing production workloads!

Slow SQL Logging

With the new Slow SQL Logging feature in Payara Server, you can easily detect when a query to the database exceeds a specific time. This enables you to drill down to the actual line of code impacting production performance enabling rapid triage and fix production performance issues in the database or inefficient SQL code in your Java EE applications.

Slow SQL logging is enabled for a specific data source in the administration console in the advanced properties. The screen shot below shows you the DerbyPool settings.

Image title

When a query exceeds the configured threshold, a WARNING is output into the server log along with a full stack trace of the code that invoked the SQL, allowing rapid identification of the offending code.

Healthcheck Service

In the 161 release, we also have the new Healthcheck Service. Payara Server now periodically checks:

  • Host CPU Usage
  • Host Memory Usage
  • Payara Server’s JVM Garbage Collections
  • Payara Server’s JVM Heap Usage
  • CPU Usage of individual threads

If there is a problem with any of these metrics and they exceed a configurable threshold, then a Warning, Error, or Critical message is logged to the server’s log file, again enabling operations teams to rapidly detect problems or work out what happened after problems have occurred.

With these two new features, we want to make running Payara Server in production easier for Operations Teams. Both of these features are new in the upcoming Payara release due on the 5th of February. Check out the Payara Server here, try these new features, and let us know what you think!

Now it's easier than ever to get started with MongoDB, the database that allows startups and enterprises alike to rapidly build planet-scale apps. Introducing MongoDB Atlas, the official hosted service for the database on AWS. Try it now! Brought to you in partnership with MongoDB.

payara,operations,sql,healthcheck,java ee,glassfish,open source,application server,garbage colection

Published at DZone with permission of Steve Millidge. See the original article here.

Opinions expressed by DZone contributors are their own.

The best of DZone straight to your inbox.

Please provide a valid email address.

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}