SQL Azure (16) Create a PAAs SQL Azure V12 Database

Source: Internet
Author: User

Windows Azure Platform Family of articles Catalog

This article describes the domestic azure China by the century connected operation

The latest Azure PaaS SQL Database (SQL Azure) has been officially launched in China, here is a brief introduction of the author.

SQL Azure V12 is an up-to-date service for SQL Azure that provides a connection string for user SQL Server, using the PAAs SQL Azure service directly without the need to manage the underlying operating system of the database server.

Compared to traditional SQL Server Virtual machine, the Azure PaaS SQL database differs from the following:

Compare content SQL VMS SQL Azure
Maintaining the operating system Need Don't need
Service levels Iaas Paas
Database service Type

Server level

Instance level

Database level

Server level

Database level

Maximum service level

D14 (16CORE/112GB)

P6

compatibility with traditional SQL Server

Good

Medium

Expansion capabilities

Scale-up

Scale-out

Highly Available

Users to implement their own

99.99% SLA

The concept of a DTU is presented in SQL Azure, as follows:

技术分享

The DTU is a unit that measures the performance of a database. It measures the parameters of CPU, memory, reads, and writes. When Dtus increases, performance, capacity increases simultaneously

For more information on DTU, please refer to:

Https://azure.microsoft.com/zh-cn/documentation/articles/sql-database-service-tiers/?rnd=1

Note: For SQL Azure V12, there are three different service levels available:

-Basic, the largest database capacity is 2GB

-Stadard, the largest database capacity is 250GB

-Premium, maximum database capacity is 500GB (P11 is 1TB)


Note that, as shown, Azure SQL database also limits the

-Maximum concurrent requests (max concurrent requests)

-Maximum concurrent logins (max Concurrrent logins)

-Maximum sessions (max session)

In some scenarios, there are many requests sent to Azure PaaS SQL Database at the same time, you will encounter max concurrent requests, Maxconcurrrent logins,Max The bottleneck of the session. This time we need

1. Reduce concurrent concurrency

2. Batch Batch Operations

Otherwise, a database 500 error occurs.

Let's give you a quick introduction to how to create Azure SQL Database V12.

1. We click on the data Service->sql database--Custom Create

2.(1) Name, enter database name

(2) Service layer, select the PAAs SQL database server layer we need, such as Basic,standard, Premium

(3) Performance level, choose the level of performance we need, there are different DTU performance indicators

After the 3.SQL Azure database is set up, we can set up the database information

Note Select to enable the most recent SQL database V12

4. Note that in step 3 above, we created a new PAAs Azure SQL Server server.

PaaS SQL Datasbase server defaults to 15000 DTU, please do not save too many SQL database under the same server, to prevent the lack of DTU.

5. Once created, we can also set up IP firewall rules.

SQL Azure (16) Create a PAAs SQL Azure V12 Database

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.