DBAs are focused on getting the highest queries per second. They will use measures such as average response times. Is this always the best approach? Consider this scenario: A high traffic volume database server – launched with capacity to absorb high queries per second, yet users start to complain some queries are randomly taking longer. The deviation from one request to another is growing and the database server response variance is growing. At the same time , the average response times are still acceptable, but there are some responses taking longer. In this case DBAs need to focus on the...
Read more →