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!
{{cta(‘f53ec10a-12d5-483b-b089-2d4cdab10448’)}}
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.
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 4.1.1.161 release due on the 5th of February. Download Payara Server, try these new features and let us know what you think!
How to Run and Scale AI Java Applications in Production: An Overview for Developers with no Machine Learning Expertise
Organizations are increasingly interested in adopting artificial intelligence (AI) and generative AI (GenAI) to improve operations and offer next-generation […]
3 minutes
Community
Dominika Tasarz
30 Sep 2025
The Payara Monthly Catch -September 2025
Welcome aboard the September issue of The Monthly Catch! With summer holidays wrapping up, the Java world is back […]
4 minutes
Uncategorized
Dominika Tasarz
25 Sep 2025
Leading the Way: Payara Platform Community 7 Beta Now Fully Jakarta EE 11 Certified
We’re excited to announce that Payara Platform Community 7 Beta application server is now fully certified as Jakarta EE 11 […]
Slow SQL logging is a great idea to detect performance bottlenecks in production environments! Cool idead! 🙂