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?

[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.

John GobertEnterprise 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
John GobertEnterprise 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
andyalderSaggar maker's framemakerCommented:
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

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
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
Microsoft SQL Server 2008

From novice to tech pro — start learning today.