Nowadays, most applications use a
database in the back-end, particularly Web-based applications. The
amount of time spent to process the
database queries becomes a critical factor for the overall performance.
The BluePrints article “Optimizing PostgreSQL Application Performance with Solaris Dynamic Tracing” demonstrates, using multiple examples, how DTrace can be used to observe, analyse and fix PostgreSQL performance bottlenecks. The paper shows for example how to analyze and fix slow queries or optimize the buffer cache usage, all that live, without rebooting, recompiling, or even restarting the application. Download this paper and improve your database performance without changing the hardware.
Sun BluePrints articles are free whitepapers, written by engineers, for engineers. Don't miss out, stay up to date and join the Sun BluePrint Community on Facebook or subscribe to the Sun BluePrints Community RSS Feed.