Contents

1 一螻旧
2 Example
3 谿瑚襭
4


1 一螻旧 #

  • Full cache
    • Examlple: select ProductKey, ProductName from Products
    • Full cache = (TotalRowSize + 20 + (4 * ColumnCount)) * RowCount
  • Partial cache
    • Example: select * from Products
    • Partial cache = (TotalRowSize + 36 + (4 * ColumnCount)) * RowCount

2 Example #

select ProductKey, ProductName 
from [Products]
  • ProductKey int, 4Byte
  • ProductName nvarchar(25), 52Byte(25*2+2)
  • Row Count = 1000000
  • Cache Size
    • Cache Size Of Partial Cache Mode = 95MB = ((4 + 52) + 36 + (4 * 2)) * 1000000 / 1024 / 1024
    • Cache Size Of Full Cache Mode = 80MB = ((4 + 52) + 20 + (4 * 2)) * 1000000 / 1024 / 1024

讒.. 襷..

3 谿瑚襭 #

4 #

  • SQL Server 2008