SQL @@TOTAL_READ is a System Statistical Function, returns the total number of disk reads since the last time the SQL server started. Remember, this does not include cache reads. The syntax of the @@TOTAL_READ is
@@TOTAL_READ
SQL @@TOTAL_READ Example
The below code snippet shows 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
You can use the 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
@@TOTAL_READ Example 2
In this Sql Server @@total_read 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