Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 29, 2014 3:18 PM
Points: 1,773, Visits: 3,207
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: Yesterday @ 2:54 AM
Points: 115, Visits: 398
Physical Reads= data pages read from hard drive
Logical Reads= data pages read from buffer pool (data catch)


Cheers ,
Pooyan D
________________________________________________
Microsoft Certified Technology Specialist : SQL Server 2008
Post #1422310
Posted Wednesday, February 20, 2013 2:48 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 29, 2014 3:18 PM
Points: 1,773, Visits: 3,207
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: Yesterday @ 2:54 AM
Points: 115, Visits: 398
from Hard Drive

Cheers ,
Pooyan D
________________________________________________
Microsoft Certified Technology Specialist : SQL Server 2008
Post #1422323
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse