JOURNAL BROWSE
Search
Advanced SearchSearch Tips
A method of Securing Mass Storage for SQL Server by Sharing Network Disks - on the Amazon EC2 Windows Environments -
facebook(new window)  Pirnt(new window) E-mail(new window) Excel Download
 Title & Authors
A method of Securing Mass Storage for SQL Server by Sharing Network Disks - on the Amazon EC2 Windows Environments -
Kang, Sungwook; Choi, Jungsun; Choi, Jaeyoung;
  PDF(new window)
 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;
 Language
Korean
 Cited by
 References
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.