_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
FrontPage › SSIS譟壱覲CacheSizing

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

讒.. 襷..

4 #

  • SQL Server 2008
蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2018-04-13 23:12:53

殊 煙隈 螻旧 朱 企. 螻旧 願屋 螻旧 螳讌 螻 螻旧 蠏瑚 願屋朱 瑚 覿 覓語願鍵 覓語企. 磯殊 磯Μ れ朱 企蟆 襷 . 螻 覓語 豢覲旧 覦り. (蟾蟯 リ啓 螳 蠖譴)