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 work loads. Operations Teams will be happy to hear that the February 161 release adds Slow SQL Logging and in-built 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 of production performance issues in the database or inefficient SQL code in your Java EE applications.
Slow SQL logging is enabled for a specific datasource in the administration console in the advanced properties. The screen shot below shows you the DerbyPool settings.
(click to enlarge)
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.
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 18.104.22.168 release due on the 5th of February. Download Payara Server, try these new features and let us know what you think!