Query Cost, Page Reads, Query Execution

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Query Cost, Page Reads, Query Execution

Author

Topic

wkm1925
Posting Yak Master

207 Posts

Posted - 2012-09-19 : 08:03:08

Hi,

I've info as following,

I need to know,
Scan Count
1. What's the meaning of Scan Count?
2. If the number of Scan Count is bigger, it's good or not?

Logical Reads
1. What's the meaning of Logical Reads?
2. If the number of Logical Reads is bigger, it's good or not?

Physical Reads
1. What's the meaning of Physical Reads?
2. If the number of Physical Reads is bigger, it's good or not?

Read-ahead reads
1. What's the meaning of Read-ahead reads?
2. If the number of Read-ahead reads is bigger, it's good or not?

Lob logical reads/physical reads/read-ahead reads
1. What's the meaning of Lob logical reads/physical reads/read-ahead reads?

Please help

chadmat
The Chadinator

1974 Posts

Posted - 2012-09-19 : 14:31:25

http://msdn.microsoft.com/en-us/library/ms184361.aspx

-Chad