- Get a JVM thread dump (see Getting Java VM Dumps ) and examine it to see if there are many threads waiting for a response from the database (see Analyzing Java VM Dumps ).
- Check the CPU utilization and disk I/O utilization of your database server.
- Check the network bandwidth between the App server and the database server.
Saturday, April 4, 2009
How to locate Performance Bottlenecks for Database?
Checking for Database Bottlenecks: If your site has low CPU utilization at maximum throughput, check whether the database is limiting performance.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment