Solved

Batch Requests per second and Disk IO

Posted on 2014-03-05
2
494 Views
Last Modified: 2014-03-05
Hello EE,

What is the relationship between Batch requests and disk io ? I understand the two metrics separately, however, if the disks become latent or there is disk queueing , does this affect batch requsts/sec . Or is the batch requests just a sheer number of the amount of work requested to do, independent of hardware?
0
Comment
Question by:davesnb
2 Comments
 
LVL 10

Accepted Solution

by:
PadawanDBA earned 500 total points
ID: 39906808
batch requests are how many batches/sql statements are executing at a given moment.  In most cases, you correlate this to system resources.  As you have more batch requests, you have more strain on the hardware.  Generally speaking, when you have a lot of batch requests coming in, you should see CPU start increasing and, depending on the profile of the statements and the data they access, potentially disk io.  The name of the game is increasing the amount of batch requests/sec you can achieve at pegged resource utilization.  Another way to look at it is to maintain the same batch requests/sec with decreased resource utilization.

There isn't going to necessarily be a hard and fast correlation between disk io and batch requests, however.  For example, the majority of the pages that are needed could already be in memory and so you'd be looking at very little disk activity (unless there are updates/inserts/deletes, in which case you would see disk activity when the lazy writer flushes the dirty pages to disk).  Or you could have the exact opposite where none of the data is in memory and needs to be moved there first, which would result in higher disk pressure.  Disk queues are just never good and you could indeed see them if your required IOPs for your data access needs exceed what your storage can handle.  They will make batches take longer to complete execution (again, dependent on whether or not they require disk access for the desired pages).

In most cases I use batches/sec merely to see if there's a justifiable increase in system resource utilization.  Generally speaking, as batches/sec increase, so does resource utilization (including disk io).
0
 

Author Closing Comment

by:davesnb
ID: 39906835
Perfect, thanks
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Why run Active Fulls in Backups 19 109
EMC RecoveryPoint journal 1 89
OpenVMS Training 1 28
create insert script based on records in a table 4 14
I previously wrote an article addressing the use of UBCD4WIN and SARDU. All are great, but I have always been an advocate of SARDU. Recently it was suggested that I go back and take a look at Easy2Boot in comparison.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This video teaches viewers how to encrypt an external drive that requires a password to read and edit the drive. All tasks are done in Disk Utility. Plug in the external drive you wish to encrypt: Make sure all previous data on the drive has been …
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now