Nakul Vachhrajani (8/10/2016)
Koen Verbeeck (8/10/2016)
Nakul Vachhrajani (8/9/2016)
Thank-you for the question! Made me revisit the documentation and refresh the concepts (Good!)
Which documentation? I couldn't find any 🙂
Here you go: "Writing Pages" - https://technet.microsoft.com/en-us/library/aa337560(v=sql.105).aspx
The documentation is for SQL 2008 R2. Since I was unable to find anything after that untill I hit SQL 2016, I assumed that no changes were made in these versions.
I accidentally came out of this documentation https://technet.microsoft.com/cs-cz/library/cc966500.aspx ,
in which it stated: "For example, during the checkpoint process up to sixteen 8-KB pages can be flushed with a single WriteFileGather invocation.""
The only current and accurate documentation is listed in the link to today's QotD:
It says here: "SQL Server 7.0 through SQL Server 2008 gathered 16 dirty pages, whenever possible, should page id
and flushed them in a single write. SQL Server 2012 and newer versions gather 32 dirty pages, whenever possible.
For SQL 2016 that value has been increased to 128 pages."
This is a substantial change compared to SQL 2008, SQL 2012 and SQL 2014.
I remain with best regards G. V.