臺灣博碩士論文加值系統

本研究旨在找出如何管控 I 公司集團內部網域持續成長分佈的 SQL Server。找出 公司內已存在的 SQL Server，並實際訪談各單位資料庫服務的使用實況，整理並分類 各資料庫的用途、大小、使用效能等後。找出資料庫服務整合的門檻。計劃並執行最 佳化配置，將資料庫伺服器虛擬化、集中化或是降低版本為免費版。經過專案研究， 評估整併的成果後。發現可有效管控 SQL Server 數量持續成長的問題，也順勢將企業 架構，成功升級為私有雲。讓原有實體機故障修復及安裝的時數大為降低，提升 SLA 達 99.9%。公司伺服器資產靈活化，管理更透明且便利。
經過本研究的關鍵管理機制，可導正並解決 I 公司當前在資料庫服務分散造成的 問題:1.無法得知資料庫的建置及軟體未經授權的不當使用;2.資料庫系統授權數量統 計不易;3.建立一致的資料庫建置的管理規則，提升內部應用的系統的合理使用率。 如:資料庫版本及系統使用資源掃瞄監控。協助資料庫管理者進行有效軟體授權及資 源的管理。如:將實體機虛擬化，變更為較低的資料庫資源配置、軟體授權費用，甚 至降為免費的資料庫軟體版本(Express)。移除建置多年且近一年無交易的資料服務。
本研究專案經實行結果證明，私有雲能有效的將應用系統虛擬化，且能滿足原有 的服務，集中化伺服器及資料庫的管理，配合節能減碳的伺服器配置，縮減了咨意擴 張的軟體授權，免除 I 公司即將付出的龐大軟體授權成本，有效配置機房空間。企業 私有雲讓管理者能更容易統一監控更高密度的眾多虛擬機器系統的狀態，日常的系統 補丁更容易管控，將 I 公司的資料庫使用及對應的伺服器建置導入正軌。此為本研究 專案建立的機制之可行性與必要性。

The purpose of this research is to manage company Is proliferation of scattered SQL Servers for the use of internal applications, by locating companys SQL Server; interviewing organizational units on the their usage; classifying database servers based on its use, size, and usability; finding the threshold for database service integration; planning and implementing optimal configurations; virtualize, centralize, and downgrading database servers to a more cost-efficient or free version. After consolidation and assessment of the result, this study finds that the proliferation of SQL Server can be effectively controlled by upgrading enterprise architecture to private cloud. This greatly reduces the number of installations and repairs of the physical machine, and increases SLA to 99.9%. The companys server assets are flexible and management is more transparent and convenient.
This studys key management mechanism can increase the organic utilization rate by resolving the problems caused by database service proliferation: 1) inability to know the setup of the database software and any unauthorized use thereof, 2) difficulty in counting number of licenses, and 3) inconsistent database management rules. These mechanisms includes database version and resource usage scan monitoring; assisting database managers in effective software licensing and resource management; virtualizing physical machines to lower resource configurations; downgrading to versions with lower licensing fees or no fees (Express); and removing old database services without any transactions for the past year.
iii
Through implementation of key management mechanisms, this study proves that private cloud can effectively virtualize the application system, while providing the same level of service. The consolidation of server and database management lends itself to energy saving and carbon-reducing configuration and the effective allocation of server rooms. The reduction uncontrolled growth of licenses which eliminates a large cost that company I have to bear otherwise. The enterprise private cloud allows managers to more easily and uniformly monitor the status of multiple virtual machines at higher density. Rectifying company Is database and its corresponding server makes routine system patches easier to manage. This research establishes this mechanism and builds a case for its necessity and feasibility.

目錄
中文摘要 ... ii
英文摘要 ... iii
誌謝 ...v
目錄 ...vi
表目錄 ... vii
圖目錄 ... viii
第一章 緒論 ... 1
1.1 研究動機 ...1
1.2 研究目的 ...3
1.3 研究流程 ...3
1.4 研究架構 ...5
第二章 文獻探討 ... 6
2.1 企業私有雲 ...6
2.2 何謂虛擬化及雲端服務 ...8
2.3 何謂整併及虛擬化 ...8
2.4 整併及虛擬化前的分析作業與流程探討 ...9
2.5 整併及虛擬化的關鍵成功因素 ...11
第三章 主機虛擬化及整併的關鍵機制分析 ... 13
3.1 資料庫伺服器大量且分散的原因 ... 13
3.2 軟體授權使用數量的統計 ... 13
3.3 資料庫伺服器使用狀況研判 .... 13
3.4 依據效能記錄進行使用者訪談 ... 16
3.5 一致化資料庫伺服器的建置機制 ... 20
3.6 主機伺服器虛擬化及集中後的私有雲服務滿意度 ...22
第四章 主機虛擬化及整併執行前後的差異 ... 24
4.1 主機虛擬化及整併前 ... 24
4.2 主機虛擬化及整併後 ... 25
4.3 主機虛擬化及整併後的效益指標 ... 28
第五章 結論 ... 30
5.1 最適化主機服務效能 ... 30
5.2 軟體授權與成本管控 ... 30
5.3 私有雲服務建立管理高度 ... 30

1. Varalakshmi Perumal and Sankari Subbiah, Power-conservative server consolidation based resource management in cloud, in International Journal of Network Management. 2014, Wiley Subscription Services, Inc. p. 415-432.
2. Dusit Niyato, Optimization-Based Virtual Machine Manager for Private Cloud Computing. IEEE Third International Conference, 2011: p. 99-106.
3. Daniel W. Yoas and Greg Simco, Using Long-Term Prediction for Web Service Network Traffic Loads. 2014 11th International Conference on Information Technology: New Generations, 2014: p. 21-26.
4. Roozbeh Matloobi and Albert Y. Zomaya, Managing Performance Degradation of Collocated Virtual Machines in Private Cloud. 2016, IEEE. p. 128-135.
5. Weimin Ding, Benjabin Ghansah, and Yanyan Wu, Research on the Virtualization Technology in Cloud Computing Environment. International Journal of Engineering Research in Africa, 2016. 21: p. 191-196.
6. Sivadon Chaisiri, Bu-Sung. Lee and Dusit Niyato, Robust cloud resource provisioning for cloud computing environments. 2010, IEEE. p. 1-8.
7. Sivadon Chaisiri, Bu-Sung Lee and Dusit Niyato, Optimal virtual machine placement across multiple cloud providers. 2009, IEEE. p. 103-110.
8. Sivadon Chaisiri, Bu-Sung Lee and Dusit Niyato, Optimization of resource provisioning cost in cloud computing. IEEE Transactions on Services Computing, 2012. 5(2): p. 164- 177.
9. Markus Winter, Unlocking the Potential of Consolidation -- the Move to Infrastructure Clouds. International Conference on Cloud Computing & Virtualization, 2010: p. 94-99.
10. Denny Cherry, 7 Considerations for Server Consolidations. SQL Server Pro, 2012.
14(11): p. 36-42.
11. Allan Hirt, SQL Server consolidation: are you ready? 2007, Penton Media, Inc., Penton
Business Media, Inc. and their subsidiaries. p. 35-39.
12. Jeff James, Views from the field: expert advice on virtualizing SQL Server: tips for
planning and managing your virtual database environment. 2009, Penton Media, Inc.,
Penton Business Media, Inc. and their subsidiaries. p. 41-43.
13. Rick Heiges, The Essential Guide to SOLVING SERVER SPRAWL. SQL Server
Magazine, 2006. 8(10): p. 48-49.
14. Michael Otey, M., Wait before you consolidate, in SQL Server Magazine. 2007, Penton
Media, Inc., Penton Business Media, Inc. and their subsidiaries. p. 5-6.
15. Michael Otey, SQL Server 2008 R2 Appliances. SQL Server Magazine, 2011. 13(9): p.
40-41.
16. Michael Otey, SQL Server virtualization FAQs. 2007, Penton Media, Inc., Penton Business Media, Inc. and their subsidiaries. p. 48-49.
17. Michael K. Campbell, Working Around the Licensing Limitations in the SQL Server Standard Edition. SQL Server Pro, 2013. 15(3): p. 56-59.
18. Blair Greenwood, Product News for SQL Server Pros. 2013, Penton Media, Inc. p. 65- 68.
19. Ross Mistry, SQL Server in a Microsoft Private Cloud: Answers to four commonly asked questions. SQL Server Pro, 2012. 14(3): p. 21-24.
20. Danilo Feroce and Margaret Boeneke, Overview of Microsoft Private Cloud with Dell EqualLogic Storage Arrays. A Dell EqualLogic Technical White Paper, 2014: p. 1-20.
21. Sung Hsueh, Antony Zhong, and Madhan Arumugam, SQL Server Consolidation Guidance. SQL Server Technical Article, 2009: p. 1-18.
22. T. M. Nam, N. H. Thanh, H. T. Hieu, N. T. Manh, N. V. Huynh and H. D. Tuan, Joint network embedding and server consolidation for energy–efficient dynamic data center virtualization. Computer Networks, 2017. 125: p. 76-89.
23. Chuan-Fu Chuang and Shiuann-Shuoh Chen,, To Implement Server Virtualization and Consolidation Using 2P-Cloud Architecture. 淡 江 理 工 學 刊 / Journal of Applied Science and Engineering, 2017(1): p. 121-130.