SQL Profiler: Read/Write units

Question

i'm running a select query in Query Analyzer. While running SQL Profiler i see that the query took 2,027 reads:

EventClass:    SQL:BatchCompleted
TextData:      SELECT Transactions....
CPU:           422
Reads:         2027
Writes:        0
Duration:      466

i ran the query with the SET STATISTICS IO ON option, and i get nowhere close to two thousand reads:

Table                Scan Count  Logical Reads  Physical Reads  ReadAhead Reads
===================  ==========  =============  ==============  ===============
LCDs                          2              4               0                0
LCTs                          2              4               0                0
FintracTransactions           4             20               2                0
FintracTransacti...           0              0               0                0
Users                         1              2               0                0
MALs                          0              0               0                0
Patrons                       0              0               0                0
Shifts                        1              2               0                0
Cages                         1              1               0                0
Windows                       1              3               0                0
Logins                        1              3               0                0
Sessions                      1              6               0                0
Transactions                  1              7               1                0

Which if i do my math right, there is a total of 52 reads; not 2,027.

So i assume Reads in SQL Profiler is an arbitrary metric. Does anyone know the conversion of

SQL Server Profiler Reads

to

SET STATISTICS IO ON Reads

?

Sauce

See also

• SQL Profiler CPU / duration unit
• Query Analyzer VS. Query Profiler Reads, Writes, and Duration Discrepencies