SQL Server Synchronous and Asynchronous reads

Question

Post reply

SQL Server Synchronous and Asynchronous reads

BLOB EATER

SSChampion

Points: 14609
More actions
July 6, 2011 at 4:35 am

#254006

Can someone explain to me ( or point me to an article ) that explains the difference between
SQL Server Synchronous and Asynchronous reads - sorry i cant find any material when checking BOL etc - unless i have been a complete fool and missed it !

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

These are the two key whitepapers

SQL Server I/O Basics (SQL Server 2000) http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlIObasics.mspx

SQL Server I/O Basics, Chapter 2 (SQL Server 2005) http://www.microsoft.com/technet/prodtechnol/sql/2005/iobasics.mspx

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

BLOB EATER SSChampion Points: 14609 More actions · Answer 2

thank you - that will be my bed time reading. 😀