SSD 用在資料庫檔,SAS HD 用在交易紀錄檔

看到 SQL MVP 的 e-mail 討論最近 HP 在 TPC-C 發佈的 SQL 2005 交易紀錄

http://www.tpc.org/results/FDR/TPCC/HP_ProLiant_DL580G7_2.26GHz_fdr_100830_Energy_v2.pdf

The database data was housed on 256 SSD drives at 120GB, two 72GB drives for the operating system, two 146GB drives for additional operating system space, 48 drives at 300GB for database log and 80 drives at 300 GB for backup and 60 day space. There were 8 x LSI 9200-16e controllers connected to 16 x D2700 storage boxes with 16 x 120GB SSD drives each for database data and 5 x 300GB drives each for backup, 48 x 300GB drives on one MSA P2000 G3 controller connected to 1 D2700 storage box for database log, and 2 x 72GB drives plus 2 x 146GB drives on the SMART P410i controller for the operating system. Section 1.2 of this report details the distribution of database tables across all disks.

MVP 們討論的重點是 SSD 用在資料庫檔,SAS HD 用在交易紀錄檔。因為 SSD 的隨機讀出效率高,大量多次寫入效率不穩且易損毀(隨機寫入更慘)。其技術原因可參考如下

http://en.wikipedia.org/wiki/Write_amplification

這份 HP 的報告有趣的地方是沒說 Tempdb 放在什麼樣格式的硬碟,是否也用一組 SSD 放 DB File 而 SAS HD 放 TLog,但因 Tempdb 是大量讀寫,是否比較適合全放在 SAS HD?

發表迴響

在下方填入你的資料或按右方圖示以社群網站登入:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / 變更 )

Twitter picture

You are commenting using your Twitter account. Log Out / 變更 )

Facebook照片

You are commenting using your Facebook account. Log Out / 變更 )

Google+ photo

You are commenting using your Google+ account. Log Out / 變更 )

連結到 %s

%d 位部落客按了讚: