January 12, 2016

Amazon RDS

Amazon RDS
Amazon Relational Database Service (Amazon RDS) is a web service that makes it easier to set up, operate, and scale a relational database in the cloud.

Amazon RDS Components
The basic building block of Amazon RDS is the DB instance. Each DB instance runs a DB engine. The computation and memory capacity of a DB instance is determined by its DB instance class. E.g. db.m4.large | db.m4.xlarge | db.m4.2xlarge | db.m4.4xlarge | db.m4.10xlarge.

Amazon RDS Options
Amazon RDS makes tools available through option groups. Currently, option groups are available for Oracle, Microsoft SQL Server, and MySQL 5.6 DB instances. 

How You Are Charged for Amazon RDS
You are billed according to the following criteria.
·         Instance class – Pricing is based on the class (e.g., micro, small, large, xlarge) of the DB instance consumed.
·         Running time – You are billed by the instance-hour, which is equivalent to a single instance running for an hour.
·         Storage – The storage capacity that you have provisioned to your DB instance is billed per GB per month
·         IOPS – Total number of storage I/O requests that you have made in a billing cycle.
·         Backup storage – Backup storage is the storage that is associated with automated database backups and any active database snapshots that you have.. Backup storage is free only for active DB instances.
·         Data transfer –Internet data transfer in and out of your DB instance.

Microsoft SQL Server on Amazon RDS

Amazon RDS currently supports Multi-AZ deployments for SQL Server using SQL Server Mirroring as a high-availability, failover solution.
Amazon RDS supports access to databases on a DB instance using any standard SQL client application such as Microsoft SQL Server Management Studio.
Amazon RDS does not allow direct host access to a DB instance via Telnet, Secure Shell (SSH), or Windows Remote Desktop Connection. 

Amazon RDS - SQL Server 2008 R2 features
·         Core database engine features
·         SQL Server development tools:
o    Visual Studio integration
o    IntelliSense
·         SQL Server management tools:
o    SQL Server Management Studio (SMS)
o    sqlcmd
o    SQL Server Profiler (client side traces; workaround available for server side)
o    SQL Server Migration Assistant (SSMA)
o    Database Engine Tuning Advisor
o    SQL Server Agent
·         Safe CLR
·         Full-text search (except semantic search)
·         SSL
·         Transparent Data Encryption (Enterprise Edition only)
·         Spatial and location features
·         Service Broker (note that Service Broker Endpoints are not supported)
·         Change Tracking
·         Database Mirroring
·         The ability to use an Amazon RDS SQL DB instance as a data source for Reporting, Analysis, and Integration Services

Currently, Amazon RDS offers two licensing options for SQL Server, License Included and License Mobility (Bring Your Own License).
License Included pricing is inclusive of software license, underlying hardware resources, and Amazon RDS management capabilities. In this model, the license is held by AWS and is included in the price of the DB instance.
Microsoft’s License Mobility program allows Microsoft customers to easily move current on-premises Microsoft Server application workloads to Amazon Web Services (AWS), without any additional Microsoft software license fees. 

Databases cannot be renamed.
Amazon RDS does not currently support increasing storage on a SQL Server DB Instance.

No comments: