Finding and fixing database level bottlenecks
Performance refers to the way that a system behaves in response to a particular application. It can be measured in terms of system response time and resource utilization. Performance is generally affected by factors such as these factors:
•The resources that are available on your system
•How well those resources are used and shared
An important initial step when there is an unknown bottleneck is to categorize it by basic type. Does it have to do with disk, or maybe a CPU? Memory? Locking or network? ...