Wait-Time Analysis

What Does Wait-Time Analysis Mean?

Wait-time analysis is a form of database performance tuning that focuses on reducing wait times for operations as much as possible. Wait-time analysis looks at the time it takes for a database to complete operations. With wait-time analysis, database administrators can see which operations are taking the most time and make appropriate adjustments.

Advertisements

Techopedia Explains Wait-Time Analysis

Wait-time analysis is an approach to database administration that looks at how much time the database spends actually completing operations as opposed to resource optimization. With more websites becoming database-driven, reducing wait times can improve loading times for pages.

Microsoft, SAP and IBM’s SQL products all include wait-time analysis tools, referred to as “Wait Types” or “Wait Events.” These can track input/output operations, buffer operations and waiting on locks to be released. Database administrators can then make optimization decisions based on the bottlenecks they find with wait-time analysis.

Advertisements

Related Terms

Latest Computer Science Terms

Related Reading

Margaret Rouse

Margaret Rouse is an award-winning technical writer and teacher known for her ability to explain complex technical subjects to a non-technical, business audience. Over the past twenty years her explanations have appeared on TechTarget websites and she's been cited as an authority in articles by the New York Times, Time Magazine, USA Today, ZDNet, PC Magazine and Discovery Magazine.Margaret's idea of a fun day is helping IT and business professionals learn to speak each other’s highly specialized languages. If you have a suggestion for a new definition or how to improve a technical explanation, please email Margaret or contact her…