background image
<< Pinpointing Problems | Improving Response Time >>
<< Pinpointing Problems | Improving Response Time >>

database locking

Monitoring · Breaking Down Transactions
LoadRunner Controller User's Guide (Windows)
Chapter 18, page 288
In
In the following example, the transaction breakdown indicates that most of the
delay to the transaction time was caused by database locking.
In order to improve transaction response time, you should reconfigure the
application or modify its code to prevent database locking. Upgrading the CPU will
be of little use, since CPU performance is not the cause of the problem.
To improve transaction response time caused by network delays, use
LoadRunner's Network Monitor to determine the node causing the delay. For more
information, see Chapter 20,
Network Monitoring
.
To analyze the resource usage on an NT or UNIX machine, use LoadRunner's
Resource monitoring. For more information see Chapter 19,
Resource
Monitoring
.