SQL IO stats

Run the following to trace on SQL IO statistics

select @@servername as servername,
avg(cast(io_stall_read_ms/(1.0+num_of_reads) as numeric(10,1))) as avg_read_stall_ms,
avg(cast(io_stall_write_ms/(1.0+num_of_writes) as numeric(10,1)))as avg_write_stall_ms,
avg(cast((io_stall_read_ms+io_stall_write_ms)/(1.0+num_of_reads + num_of_writes) as numeric(10,1)))as avg_io_stall_ms
from sys.dm_io_virtual_file_stats(null,null)