DBCC SQLPERF(RASTATS)

DBCC SQLPERF(RASTATS) returns the LRU-MRU chain statistics. LRU stands for Last The same information is available via performance monitor counters.

The result set:

Statistic                         Value
-------------------------------- ------------------------
RA Pages Found in Cache           0.0
RA Pages Placed in Cache          0.0
RA Physical IO                    0.0
Used Slots                        0.0

Description of the statistic rows:

Statistic	Description
RA Pages Found in Cache	This counter is always zero
RA Pages Placed in Cache	This counter is always zero
RA Physical IO	This counter is always zero
Used Slots	This counter is always zero

The table structure returned, has the following shape:

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

To populate the table use:

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

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