InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 16:22:10 GMT20http://www.sqlservercentral.com/Forums/Topic1404093-391-1.aspxLooks right. Bear in mind those are logical reads, not physical, and if a page is read twice is it counted twice.Tue, 08 Jan 2013 06:08:59 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1404093-391-1.aspx[quote][b]GilaMonster (1/8/2013)[/b][hr]Logical reads - pages read.[/quote]Ok - so this is correct:621024 (Reads) * 8192 (page size) = 5,087,428,608 bytes ?Tue, 08 Jan 2013 05:32:37 GMTWandraghttp://www.sqlservercentral.com/Forums/Topic1404093-391-1.aspxLogical reads - pages read.Tue, 08 Jan 2013 05:11:31 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1404093-391-1.aspxQuestion: The number of reads recorded in a trace file, is that the number of logical PAGE reads (meaning a full 8k read).OR is it a number of logical read operations done, and a logical read can maybe be a single record/column value?The second option makes a bit more sense when calculating the numbers out a bit.But I've read some more articles that is not really clear on this. Some "suggests" that it's page reads, others refer to read operations...ThxTue, 08 Jan 2013 04:50:44 GMTWandraghttp://www.sqlservercentral.com/Forums/Topic1404093-391-1.aspxNever mind...Looking at this article helped: (Some previous articles misguided me on the values in this column...)http://www.sql-server-performance.com/2010/logical-reads/Tue, 08 Jan 2013 03:39:50 GMTWandraghttp://www.sqlservercentral.com/Forums/Topic1404093-391-1.aspxHi,I'm playing around with SQL traces, and trying to understand what exactly it's returning.For now, I'm looking at the Reads column, which is the number of logical page reads.My question is, can one determine the amount of bytes/MB that the query reads per day from the database?Looking at the following data:TraceEvent - RPC:CompletedReads - 621024I've tried this:621024 (Reads) * 8192 (page size) = 5,087,428,608 byteswhich seems a bit way to much....Looking at the total amount of reads, it looks as if I'm reading the database in size a couple times...Or is my understanding of the number of Reads not correct?The same goes with the Writes column - which is the number of physical writes.Can one calculate the data size read/write using the traces?Thanks.Tue, 08 Jan 2013 03:22:23 GMTWandrag