?
Solved

Batch Requests per second and Disk IO

Posted on 2014-03-05
2
Medium Priority
?
598 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 2000 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
Windows Server 2003 introduced persistent Volume Shadow Copies and made 2003 a must-do upgrade.  Since then, it's been a must-implement feature for all servers doing any kind of file sharing.
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 …
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

616 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