calculating disk IO

How does one calculate disk IO requirements for SQL queries? Then how do I
measure what is being produced by my disk subsystem? Thanks for the info.
Jasonthis article by Ed Whalen says it all.
you may have to register to view but registration is free and only requires
email addy
http://www.perftuning.com/_whitepapers/RAID.pdf
Greg Jackson
PDX, OR|||OK that is nice to calculate the load the disks can handle. Is there away to
calculate how many IOs are being generated by my sql box?
Jason
"pdxJaxon" <GregoryAJackson@.Hotmail.com> wrote in message
news:%23CKbL5PGFHA.3492@.TK2MSFTNGP12.phx.gbl...
> this article by Ed Whalen says it all.
> you may have to register to view but registration is free and only
> requires email addy
> http://www.perftuning.com/_whitepapers/RAID.pdf
> Greg Jackson
> PDX, OR
>|||Hi
Fire up Windows Performance Monitor and collect the statistics.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"JasonMeyer" <jason.meyer@.nospam.isd623.org> wrote in message
news:OKlLFYQGFHA.1044@.TK2MSFTNGP14.phx.gbl...
> OK that is nice to calculate the load the disks can handle. Is there away
to
> calculate how many IOs are being generated by my sql box?
> Jason
> "pdxJaxon" <GregoryAJackson@.Hotmail.com> wrote in message
> news:%23CKbL5PGFHA.3492@.TK2MSFTNGP12.phx.gbl...
>|||Being the noob that I am and trying to learn, but which counter is it?
Thanks.
Jason
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:u2V2OFTGFHA.2736@.TK2MSFTNGP09.phx.gbl...
> Hi
> Fire up Windows Performance Monitor and collect the statistics.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "JasonMeyer" <jason.meyer@.nospam.isd623.org> wrote in message
> news:OKlLFYQGFHA.1044@.TK2MSFTNGP14.phx.gbl...
> to
>|||Hi
Look at the objects Physical Disk and Logical Disk.
Logical disk give you figures for the sum of the drives in a RAID
configuration, whilst physical disk gives you figures for each physical
drive.
Counters:
Disk Read Bytes/sec and Disk Write Bytes/sec
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"JasonMeyer" <jason.meyer@.nospam.isd623.org> wrote in message
news:OS3TOqcGFHA.2620@.tk2msftngp13.phx.gbl...
> Being the noob that I am and trying to learn, but which counter is it?
> Thanks.
> Jason
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:u2V2OFTGFHA.2736@.TK2MSFTNGP09.phx.gbl...
away[vbcol=seagreen]
>