Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Physical reads Expand / Collapse
Author
Message
Posted Wednesday, February 20, 2013 11:26 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, December 1, 2016 2:45 PM
Points: 2,015, Visits: 3,809
I am a little confused about the concept of physical reads:

In Extended event, I add an event, and filter by physical_reads, the definition of it is:
physical_reads (package0.uint64)
The number of physical page reads issued by the batch.
Does this mean to read from hard disk?

Also in Performance monitor, if I select the counter SQL Server: Buffer Manager:Physical reads/sec

The description is : Number of physical database page reads issued.
Does this also mean to read from physical disk or read from Buffer manager?

Thanks
Post #1422226
Posted Wednesday, February 20, 2013 2:36 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 21, 2016 11:57 AM
Points: 120, Visits: 421
Physical Reads= data pages read from hard drive
Logical Reads= data pages read from buffer pool (data catch)


Pooyan
Post #1422310
Posted Wednesday, February 20, 2013 2:48 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, December 1, 2016 2:45 PM
Points: 2,015, Visits: 3,809
Thanks, how about the counter:

SQL Server: Buffer Manager:Physical reads/sec

Does this mean per second physical read from hard disk or buffer manager?

Thanks
Post #1422318
Posted Wednesday, February 20, 2013 2:52 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 21, 2016 11:57 AM
Points: 120, Visits: 421
from Hard Drive

Pooyan
Post #1422323
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse