Database writes still 8K or is it now 64K?

Question

Post reply

Database writes still 8K or is it now 64K?

rbarrera

Mr or Mrs. 500

Points: 575
More actions
October 20, 2010 at 7:36 am

#241894

Is SQL 2008 R2 using the same 8K random writes for data or is it now in 64K chunks? Thanks

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

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

hallidayd SSCrazy Points: 2490 More actions · Answer 1

hallidayd

SSCrazy

Points: 2490

October 20, 2010 at 8:13 am

#1239711

Yup, 8k for everything.

rbarrera Mr or Mrs. 500 Points: 575 More actions · Answer 2

rbarrera

Mr or Mrs. 500

Points: 575

October 20, 2010 at 8:17 am

#1239713

Thanks

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

Errr... it's far from that simple... Never really has been.

Pages are 8k, that's unchanged. Writes, well, maybe take a read through this:

http://technet.microsoft.com/en-gb/library/cc966500.aspx, especially the section on scatter-gather IO.

This is also interesting: http://technet.microsoft.com/en-gb/library/cc917726.aspx

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