SQL I/O test

Hi, I wanted to run some test on the disk system for one of our SQL server, I was wondering if by executing the following command on my DB it tests the disks the files reside and not C drive, or are there  switches required for choosing a disk?

backup database (dbname) to DISK='NUL'

regards,
atorexAsked:
Who is Participating?
 
andyalderConnect With a Mentor Commented:
Is it just the backup speed you're interested in rather than how fast it can access random records? You may be better off using sqlio - http://www.brentozar.com/archive/2008/09/finding-your-san-bottlenecks-with-sqlio/
0
 
jpgobertEnterprise IT Systems ConsultantCommented:
No files should be written if you run a backup as you have the command written.  The whole point of using this, to my knowledge, is to test the server's backup throughput capability (reading from the disks to create the backup) and not writing it out.
0
 
atorexAuthor Commented:
Yes I just want to test the disk read capability my direct question is does the command as I have it give me results on the storage disk where the MDF is located and not C drive?
0
 
jpgobertEnterprise IT Systems ConsultantCommented:
You'll be reading from where ever the MDF file is located so that's where your disk activity should be.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
backup database will only READ from the disk(s) where the database files are.
part of this is to query some information from the master database, but it can be neglectables.

backup database will WRITE to the backup destination disk(s)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.