none
请问SQLSERVER的事务日志的log block checksum资料在哪里找 RRS feed

  • 问题

  • 看了mysql的事务日志结构文档,了解到mysql的log block有checksum,我记得SQLSERVER也是一样,每个log block也是有checksum的之前看过一篇文章,可是没有保存下来,不知道各位大侠有相关的文章或者资料

    2014年1月16日 12:18

答案

  • What is a log block?

    The smallest unit of data storage in SQL Server is a page which is 8 kb in size. SQL Server manages space as Extents, which are made of eight contiguous pages. When it comes to Transaction Log, the fundamental unit of IO is a log block. The size of the log block is *NOT* fixed and it varies from 512 bytes to 60 kb. Virtual log files known as VLFs are made up of log blocks. And the Transaction Log is made up many VLFs, which are variable in size. For more details on the log block, refer Paul’s  post listed below.

    来源:http://sankarreddy.com/tag/checksum/


    Please Mark As Answer if it is helpful.

    2014年1月16日 12:52

全部回复

  • What is a log block?

    The smallest unit of data storage in SQL Server is a page which is 8 kb in size. SQL Server manages space as Extents, which are made of eight contiguous pages. When it comes to Transaction Log, the fundamental unit of IO is a log block. The size of the log block is *NOT* fixed and it varies from 512 bytes to 60 kb. Virtual log files known as VLFs are made up of log blocks. And the Transaction Log is made up many VLFs, which are variable in size. For more details on the log block, refer Paul’s  post listed below.

    来源:http://sankarreddy.com/tag/checksum/


    Please Mark As Answer if it is helpful.

    2014年1月16日 12:52
  • 这麽快,我先看看
    2014年1月16日 13:01