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(http://blogs.msdn.com/mattm/archive/2008/10/18/calculating-the-size-of-your-lookup-cache.aspx)
  
• Lookup cache modes(http://blogs.msdn.com/mattm/archive/2008/10/18/lookup-cache-modes.aspx)
  
  

• SQL Server 2008