Browse > Article
http://dx.doi.org/10.7472/jksii.2016.17.2.01

A method of Securing Mass Storage for SQL Server by Sharing Network Disks - on the Amazon EC2 Windows Environments -  

Kang, Sungwook (School of Computer Science and Engineering, Soongsil University)
Choi, Jungsun (School of Computer Science and Engineering, Soongsil University)
Choi, Jaeyoung (School of Computer Science and Engineering, Soongsil University)
Publication Information
Journal of Internet Computing and Services / v.17, no.2, 2016 , pp. 1-9 More about this Journal
Abstract
Users are provided infrastructure such as CPU, memory, network, and storage as IaaS (Infrastructure as a Service) service on cloud computing environments. However storage instances cannot support the maximum storage capacity that SQL servers can use, because the capacity of instances provided by service providers is usually limited. In this paper, we propose a method of securing mass storage capacity for SQL servers by sharing network disks with limited storage capacity. We confirmed through experiments that it is possible to secure mass storage capacity, which exceeds the maximum storage capacity provided by an instance with Amazon EBS on Amazon EC2 Windows environments, and it is possible to improve the overall performance of the SQL servers by increasing the disk capacity and performance.
Keywords
Cloud Storage; SQL Server; Network disk sharing; Amazon EC2; Amazon EBS;
Citations & Related Records
연도 인용수 순위
  • Reference
1 "Amazon Elastic Compute Cloud(Amazon EC2)," https://aws.amazon.com/ec2/
2 "Amazon Elastic Compute Cloud Storage," http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/Storage.html
3 O.G. Min, H.Y. Kim, and G.H. Nam, "Trends in Technology of Cloud Computing (in Korean)," Electronics and Telecommunications Trends, Vol. 24, No. 4, Aug. 2009.
4 "Amazon Instance Vloume Limits," http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/volume_limits.html
5 "Amazon EBS Volume Types," http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/EBSVolumeTypes.html
6 "SQL Server Database Files and Filegroups," https://msdn.microsoft.com/en-us/library/ms189563.aspx
7 "Maximum Capacity Specifications for SQL Server," https://technet.microsoft.com/en-us/library/ms143432(v= sql.110).aspx
8 HDFS, "http://hadoop.apache.org/core/docs."
9 "Amazon EC2 Instance," http://aws.amazon.com/ec2/instance-types/?nc2=h_ls
10 "Amazon EC2 Instance Configuration," http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/ebs-ec2-config.html
11 "SQL Server Memory Server Configuration Options," https://msdn.microsoft.com/en-us/library/ms178067(v=sql.120).aspx
12 "Description of support for network database files in SQL Server," https://support.microsoft.com/en-us/kb/304261.