Solved

Batch Requests per second and Disk IO

Posted on 2014-03-05
2
500 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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

AWS Glacier is Amazons cheapest storage option and is their answer to a ‘Cold’ storage service.  Customers primarily use this service for archival purposes and storage of infrastructure backups.  Its unlimited storage potential and low storage cost …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
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 Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…

786 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