@@TOTAL_READ
SQL Server 2000
Returns the number of disk reads (not cache reads) by Microsoft® SQL Server™ since last started.
Syntax
@@TOTAL_READ
Return Types
integer
Remarks
To display a report containing several SQL Server statistics, including read and write activity, run sp_monitor.
Examples
This example shows the total number of disk read and writes as of the current date and time.
SELECT @@TOTAL_READ AS 'Reads', @@TOTAL_WRITE AS 'Writes', GETDATE() AS 'As of'
Here is the result set:
Reads Writes As of
--------- ----------- ------------------------------
978 124 1998-04-21 22:14:22.37
