Updating Service Tiers in Azure SQL Database

-

Azure SQL Web and Business databases are being deprecated and retired September 2015 so it's time to start planning to upgrade existing Web or Business databases to the Basic, Standard, or Premium service tiers.

Upgrading a Web or Business database to a new service tier involves the following steps:

  1. Determine service tier based on feature capability
  2. Determine an acceptable performance level based on historical resource usage
  3. Why does existing performance for my Web or Business database map to the higher Premium levels?
  4. Tuning your workload to fit a lower performance level
  5. Upgrade to the new service tier/performance level
  6. Monitor the upgrade to the new service tier/performance level
  7. Monitor the database after the upgrade

In this post I will discuss about the point 2 : “Determine an acceptable performance level based on historical resource usage”

 

How to view the recommended service tier in the new Azure Management Portal

New Management Portal

  1. Log on to the new management portal and navigate to a server containing a Web or Business database.
  2. Go to browse all, Then SQL Servers
  3. Select the server you want to upgrade
  4. Click the Latest Update part in the server blade.

image

5. Click Upgrade this server.

The Upgrade this server blade now shows a list of Web or Business databases on the server along with the recommended service tier.

image

How to view DTU consumption in the Management Portal

Log on to the management portal and navigate to an existing Web or Business database.

  1. Click the MONITOR tab.
  2. Click ADD METRICS.
  3. Select DTU percentage and click the checkmark at bottom to confirm.

image

Hope this helps.

Comments

Post a Comment

Popular posts from this blog

Responsive Web Design

-
Image
  What it is A web application developed based on the responsive web design concept will adopt the layout of the application based on the screen size and orientation. As the user switches from their laptop to iPad, the website should automatically switch to accommodate for resolution, image size and scripting abilities. In other words, the website should have the technology to automatically respond to the user’s preferences. This would eliminate the need for a different design and development phase for each new gadget on the market. When designing a web in responsive manner same HTML content will be maintained, but it will be viewed in different layouts when user switches among different browser sizes. In that way website can server the users by changing the layout of the content so user can view it in more user friendly manner, without too many scrolling. How the layout changes will be discussed under topic Design patterns   Pros Increasing your reach to tablet and ...
Read more

Contract First Development in WCF 4.5

-
Image
WCF 4.5 supports contract first development. Means it allows to create all the data contract classes can be auto generated using the WSDL. one of the advantage in using the is if we start developing the service from the data contracts & then generating the WSDL we might end up in creating from data contracts with .net specific data types. But when using contract first development as WSDL is xml based only xml based data types are allowed to create so no .net specific contract will be created. This feature can be very useful when WSDL file is produced through design phase either by a solution architect or through mutual parties that agree on a contract prior to development and build phases.  When this is the case, either the contract can be created for a future service implementation or contracts can be created so that developers can begin coding for the client side of an interface prior to the endpoint being available. The contract-first tool is integrated into Visual Studio 2...
Read more

Affine Cipher in C#

-
Image
  The affine cipher is a type of monoalphabetic substitution cipher , wherein each letter in an alphabet is mapped to its numeric equivalent, encrypted using a simple mathematical function, and converted back to a letter. The formula used means that each letter encrypts to one other letter, and back again, meaning the cipher is essentially a standard substitution cipher with a rule governing which letter goes to which. As such, it has the weaknesses of all substitution ciphers. Each letter is enciphered with the function , where is the magnitude of the shift. For more information on affine cipher visit here Following code is written in c# which has the affine cipher algorithm   public static string AffineEncrypt( string plainText, int a, int b) {      string cipherText = "" ;        // Put Plain Text (all capitals) into Character Array      char [] chars = plainText.ToUpper().ToCharArray();        // Compute e(x) = (ax + b)(mod m) ...
Read more