March 7, 2016 at 9:01 pm
Hi,
We use Adam Machanics great proc sp_WhoIsActive fairly frequently and I know his tutorial states all columns are in 8K pages (reads, writes, physical_reads etc.) but our disks are formatted with 64K blocks as per Microsoft's recommendations, so wouldn't a one in the physical_reads column denote 64K was read from disk?
We are looking into this as some transactions have large numbers for physical reads but in order to find out exactly how much was read from disk we need to know the unit this column is reporting in.
Thanks in advance for any pointers on this.
March 7, 2016 at 9:38 pm
SQL Server stores and reads data in 8K pages pages. If you query a single integer column from your single row in a table, you have to read the whole page from disk. The number reported for reads from the DMVs is in the number of pages read.
If you have a query with a tremendous number of reads that you think should happen for the query, look at the query itself for an implicit cast or some similar offense.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply