8

MSDN describes the various logical / physical read and write columns in dm_exec_query_stats as:

Number of physical reads performed the last time the plan was executed.

Those columns are all 64 bit ints (bigint), so obviously larger numbers represent more reads / writes.

But what are the units of this column? Database pages? Kilobytes? Just an arbitrary number?

Example: for a reasonably expensive query in my database dm_exec_query_stats.total_logical_reads = 40412.

40412 of what?

9

Reads and writes are expressed in terms of "the number 8K pages." It should be documented better on the page you reference, but you can piece this together from other areas of the documentation, e.g. from Reading Pages:

A logical read occurs every time the Database Engine requests a page from the buffer cache. If the page is not currently in the buffer cache, a physical read first copies the page from disk into the cache.

And from Understanding Pages and Extents:

In SQL Server, the page size is 8 KB.

  • Thanks Aaron, I had a suspicion it would be pages. I marked your answer as correct because of your references. – ligos Aug 22 '12 at 23:59
2

Number of pages read and written.

For the most part everything is reported in pages, unless something else is specified.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.