#title SSIS 조회변환 Cache Sizing
[[TableOfContents]]

==== 산정공식 ====
 * 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}}}

==== 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

쩝.. 잘 안맞는다..
==== 참고자료 ====
 * [http://blogs.msdn.com/mattm/archive/2008/10/18/calculating-the-size-of-your-lookup-cache.aspx Calculating the size of your Lookup cache]
 * [http://blogs.msdn.com/mattm/archive/2008/10/18/lookup-cache-modes.aspx Lookup cache modes]

==== 적용 버전 ====
 * SQL Server 2008