Tutorial Gateway

SQL @@TOTAL_READ

by

SQL @@TOTAL_READ is a System Statistical Function, returns the total number of disk reads since SQL server is last started. Remember, this does not include cache reads.

Syntax behind this is @@TOTAL_READ is

@@TOTAL_READ

SQL @@TOTAL_READ Example

Below code snippet will show you the total number of disk reads for this SQL Server.

-- SQL Server @@TOTAL_READ Example
SELECT @@TOTAL_READ AS [Total Number of Reads]

OUTPUT

SQL @@TOTAL_READ Example 1

You can use GETDATE() function along with Total_Read function to see the total number of reads until today.

-- SQL Server @@TOTAL_READ  Example
SELECT @@TOTAL_READ AS [Total Number of Reads],
	GETDATE() AS [As of Today]

OUTPUT

SQL @@TOTAL_READ Example 2

SQL @@TOTAL_READ Example 2

In this example we are using both the Total Reads and Total Writes, along with Today’s date

-- SQL Server @@TOTAL_READ  Example
SELECT @@TOTAL_READ AS [Total Number of Reads],
	 @@TOTAL_WRITE AS [Total Number of Writes],
	 GETDATE() AS [As of Today]

OUTPUT

SQL @@TOTAL_READ Example 3

Placed Under: SQL