Here's your query

SELECT TOP 5

qt.text AS 'SQL',

qstats.total_physical_reads AS 'Total Physical Reads',

qstats.total_physical_reads/qstats.execution_count AS 'Average Physical Reads',

qstats.execution_count AS 'Execution Count',

qstats.total_worker_time/qstats.execution_count AS 'Average Worker Time',

qstats.total_worker_time AS 'Total Worker Time',

DATEDIFF(Hour, qstats.creation_time, GetDate()) AS 'AgeInCache In Hours',

db_name(qt.dbid) AS 'Database Name'

FROM sys.dm_exec_query_stats AS qstats

CROSS APPLY sys.dm_exec_sql_text(qstats.sql_handle) AS qt

WHERE qt.dbid = db_id() -- Filter by current database

ORDER BY qstats.total_physical_reads DESC

Here's Glenn Berry's [/url]

-- Cached SP's By Physical Reads (SQL 2005) Physical reads relate to read I/O pressure (Query 30) (SP Physical Reads)

SELECT TOP(25)

qt.[text] AS [SP Name],

qs.total_physical_reads,

total_logical_reads,

qs.max_logical_reads,

total_logical_reads/qs.execution_count AS [AvgLogicalReads],

qs.execution_count AS [Execution Count],

qs.execution_count/DATEDIFF(Second, qs.creation_time, GETDATE()) AS [Calls/Second],

qs.total_worker_time/qs.execution_count AS [AvgWorkerTime],

qs.total_worker_time AS [TotalWorkerTime],

qs.total_elapsed_time/qs.execution_count AS [AvgElapsedTime],

DATEDIFF(Minute, qs.creation_time, GETDATE()) AS [Age in Cache]

FROM sys.dm_exec_query_stats AS qs WITH (NOLOCK)

CROSS APPLY sys.dm_exec_sql_text(qs.[sql_handle]) AS qt

WHERE qt.[dbid] = DB_ID() -- Filter by current database

AND qs.total_physical_reads > 0

ORDER BY qs.total_physical_reads DESC OPTION (RECOMPILE);

Imitation is the sincerest form of flattery.