Batch Requests per second and Disk IO

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?
davesnbAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PadawanDBAOperational DBACommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
davesnbAuthor Commented:
Perfect, thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Storage

From novice to tech pro — start learning today.