DBCC SQLPERF(IOSTATS)

DBCC SQLPERF(IOSTATS) is not returning any valuable information, the counters will always be zero!

The result set:

Statistic                         Value
-------------------------------- ------------------------
Reads Outstanding                 0.0
Writes Outstanding                0.0

Description of the statistic rows:

Statistic	Description
Reads Outstanding	This counter is always zero
Writes Outstanding	This counter is always zero

The table structure returned, has the following shape:

create table #iostats
(
[Statistic] nvarchar(32) not null,
[Value] float not null
)

To populate the table use:

insert into #iostats exec('dbcc sqlperf(iostats) with tableresults, no_infomsgs')
select * from #iostats

NOTE: DBCC SQLPERF(IOSTATS, CLEAR) is a NOP.