Contents

1 산정공식

2 Example

3 참고자료

4 적용 버전

• 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
    
    

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
    
    

• Calculating the size of your Lookup cache
  
• Lookup cache modes
  
  

• SQL Server 2008