How To Stop Azure SQL Database

In this Azure tutorial, we will discuss How To Stop Azure SQL Database. Along with this, we will also discuss a few other topics as below

• How to Create Azure Database for MySQL using Azure portal
• How To Stop Azure SQL Database for MySQL Server Using Azure Portal
• How To Stop Azure SQL Database for MySQL Using Azure CLI
• How To Start Azure SQL Database for MySQL Using Azure Portal
• How To Start Azure SQL Database for MySQL Using Azure CLI
• Azure SQL Database Serverless
• How To Create an Azure SQL Database In Serverless Tier
• Query the Serverless Tier Azure SQL database.

How To Stop Azure SQL Database

Well, here we will discuss the steps to stop/start the Azure Database for MySQL using Azure portal. But before that, we will discuss How to Create Azure Database for MySQL using Azure portal.

• How To Change User Id And Password For Azure SQL Server Database
• How To Deploy SQL Database To Azure
• What Is Azure SQL Database Edge

How to Create Azure Database for MySQL using Azure portal

You can easily create an Azure database for MySQL in Azure portal by following the below information.

• Log in to the Azure Portal (https://portal.azure.com/)
• Search for Azure Database for MySQL and then click on the search result Azure Database for MySQL servers.

• On the Azure Database for MySQL servers page, click on the + Create button or you can also click on the Azure Database for MySQL server button to Create the Azure Database for MySQL server.

• Now, you can click on the Single server or Flexible server (Preview) option based on your requirement. Click on the Create button. Now for time being, I am choosing the Single server option.

On the Create MySQL server window, provide the below details

• Subscription: You need to provide a valid subscription to create the MySQL server.
• Resource group: Either you can select an existing Resource group or if you don’t have any existing resource group, you can click on the Create new link to create a new Resource group.
• Server name: Provide a unique name for your Server.
• Data source: You need to select the Data source based on your need.
• Location: Select the location for your Azure Database for MySQL server.
• Version: You can select the latest version.
• Compute + storage: You can select the storage option based on your need. Click on the Configure server link to select the appropriate storage option based on your need.
• Admin Username: Provide the Admin username for the Administrator account.
• Password: You need to provide the password for the Administrator account.
• Confirm Password: Provide the password for the confirmation.

Finally, click on the Review + create button.

• Click on the Create button to create the Azure Database for MySQL.

• Once you will click on the Create button, it will take a few seconds and then it will show you that your deployment is complete. Click on the Go to resource button to navigate to the Azure Database for MySQL that you have created.

This is how to create Azure Database for MySQL using Azure portal. Now let’s discuss how to stop Azure SQL Database.

How To Stop Azure SQL Database for MySQL Server Using Azure Portal

Well, the time to discuss the steps to stop Azure SQL Database. Follow the steps to stop the Azure SQL database for MySQL using Azure Portal.

1. Log in to the Azure Portal (https://portal.azure.com/).
2. Once, you have logged in to the Azure Portal, search for Azure Database for MySQL, and click on the search result “Azure Database for MySQL servers” as shown below.

3. On the Azure Database for MySQL servers page, you will see the lists of Azure Database for MySQL servers that you have created before. Click on the specific server that you want to stop. Make sure to choose the correct one as you are going to stop the server.

4. Now, On the Azure Database for MySQL server page, on the Overview tab, click on the Stop button to stop the Azure Database for My SQL server.

5. Click on the Yes button to confirm stopping the server as highlighted below.

6. It might take a few seconds and will show you Successfully stopped the MySQL server as shown below.

How To Stop Azure SQL Database for MySQL Using Azure CLI

Well, we can also stop the Azure SQL Database for MySQL using Azure CLI by following the below instruction.

• Log in to the Azure Portal (https://portal.azure.com/).
• Once you have logged in to the Azure Portal, click on the Cloud Shell button from the top right as highlighted below.

• Now, You can use the below script to stop the Azure SQL Database for MySQL using Azure CLI.

az mysql server stop --name <Your server-name> -g <Your resource-group-name>

Example:

az mysql server stop --name demotestdb12 -g Demo123

Here, demotestdb12 is the name of my Azure SQL Database for MySQL server name and Demo123 is the name of the resource group. Make sure to change the server and resource group name based on yours.

How To Start Azure SQL Database for MySQL Using Azure Portal

Same way, you can also able to start Azure SQL Database for MySQL using the Azure Portal by following the below quick steps.

1. Log in to the Azure Portal (https://portal.azure.com/).
2. Now, search for Azure Database for MySQL, and click on the search result “Azure Database for MySQL servers” as shown below.

3. On the Azure Database for MySQL servers page, you will see the lists of Azure Database for MySQL servers that you have created before. Click on the specific server that you want to start.

4. Now, On the Azure Database for MySQL server page, on the Overview tab, click on the Start button to start the Azure Database for My SQL server.

5. On the Start server pop-up, click on the Yes button for the confirmation to start the Azure Database for My SQL server.

6. Well, it will take a few seconds and will show you a message that Successfully started the MySQL Server as shown below.

How To Start Azure SQL Database for MySQL Using Azure CLI

Well, you can use the below quick steps to start Azure SQL Database for My SQL server by using Azure CLI. You can follow the below instruction.

• Log in to the Azure Portal (https://portal.azure.com/).
• Once you have logged in to the Azure Portal, click on the Cloud Shell button from the top right as highlighted below.

• Now, You can use the below script to start the Azure SQL Database for MySQL using Azure CLI.

az mysql server start --name <Your server-name> -g <Your resource-group-name>

Example:

az mysql server start --name demotestdb12 -g Demo123

Here, demotestdb12 is the name of my Azure SQL Database for MySQL server name and Demo123 is the name of the resource group. Make sure to change the server and resource group name based on yours.

This is How to stop/start the Azure Database for MySQL using Azure Portal and How to stop/start the Azure Database for MySQL using Azure CLI.

Azure SQL Database Serverless

Earlier we had a question i.e How to Stop SQL Azure DB when not in use. It is needed because there is no point in paying for the Azure SQL Database when you are not actually using it. Now Azure SQL Database Serverless is the answer to the question How to Stop SQL Azure DB when not in use.

Serverless is nothing but a compute tier that is especially for single databases that helps you to bill only for the amount of compute used per second, scales the resources based on the demand and the most important point is, when your database is inactive, it pauses the databases and during that time, you will only get billed for the storage and not for the compute.

The database resumes automatically with the next log in or if anyone performs any activity in the database.

Cost Calculation for a Serverless Database

1. The first and important point to note down here is, when the database is paused, you just need to pay for the Storage and during that time you no need to pay any amount for the compute.
2. In the case of the Serverless Database, the total cost is the addition of the Storage Cost and the Compute Cost.
3. Remember that, the cost calculation for the Compute is based on a few factors like if you have used the compute resources within the minimum and maximum limit, then the cost is based on the vCore and memory that you have actually used. Whereas, if you have used the compute resources below minimum and more than maximum, then the cost is based on the min vCores and min memory you have used.
4. Coming to the storage cost, it is as usual, based on the storage you are using, you need to pay for that.

Best suits Scenarios for serverless compute

There are certain scenarios, where the serverless compute best suits. Those are as below

• Single databases that are not continuous or steady
• Single database without usage history
• Single databases that are inactive for more time, etc.

Key Features Of Serverless Tier

There are few key features that are available in case of serverless tier. Those are as below

Autoscaling Capability

It automatically scales the compute resources based on the workload or demand that intern improves the performance.

Best Memory Management

In case of serverless database, the memory recovers frequently that helps to control the cost. Manages the memory properly with the help of Cache reclamation and Cache hydration.

Auto-pausing

Auto-pausing is another very important feature of serverless database. If it will find the number of sessions = 0 and the CPU usage = 0 for the user workload that is running in the user pool. This is mainly helps you to control the cost.

Auto-resuming

It resumes the database automatically in few scenarios like, on the next login, in order to modify the threat detection settings, to view the auditing records, To add, edit, view sensitivity levels, To add, edit, delete, view data masking rules, To view, modify query store settings, To view or apply performance recommendations, In case of auto-indexing, To export a database, To add the new database tags, etc.

These are a few key features of serverless tier database.

How To Create an Azure SQL Database In Serverless Tier

If you want to save the cost for your Azure SQL database, then it’s quite important to know How to Create a new database in the serverless compute tier. Follow the below steps to create an Azure SQL Database using serverless tier.

1. Navigate to the Azure Portal
2. On the Select SQL deployment option window, On the How do you plan to use the service? section, Choose the Resource type as Single database for the SQL databases and then click on the Create button to create a single Azure SQL database.

3. On the Create SQL Database window, Provide the below details

• Subscription: Choose a valid Azure subscription that you want to use to create the Azure SQL database.
• Resource group: Select an existing resource group if you have it already or, if you have not yet created a resource group, you can click on the Create new link to create a new resource group.
• Database name: Provide an unique name for your Azure SQL database.
• Server: You need to select a valid server or if you don’t have a server created as of now, you can click on the Create new link to create a new server.

Once you will click on the Create new link, provide an unique number for the server, Server admin login, Password, Confirm password and provide the Location for the server. Finally click on the Ok button.

• Want to use SQL elastic Pool?: You can select No here. or, you can also Choose Yes or No option based on your requirement.

• Compute + Storage: This option is quite important. Make sure to click on the Configure database link and On the Configure window, select the Serverless option and then click on the Apply button.

4. Now, click on the Next : Networking > button to navigate to the Networking tab. Select the below details

• Connectivity method: Select the Public endpoint option here.
• Allow Azure services and resources to access this server: Select No for this option.
• Add current client IP address: Select the Yes option here.

5. Now, click on the Next : Additional settings > button to navigate to the Additional settings tab.

6. On the additional settings window, select the below options

1. Use existing data: Select the Sample option here.
2. Enable Azure Defender for SQL: You can select the Start free trial option or you can select the Not now option based on your need.

7. Then click on the Review + Create button.

8. Finally, click on the Create button on the next window.

9. It will take a few seconds and then it will show the Deployment is complete as shown below. Click on the Go to resource button to navigate to the Azure SQL database that we have just created.

Query the Serverless Tier Azure SQL database

Now the Serverless Tier Azure SQL database has been created successfully. Now the time to run a query and see if everything is working as expected.

We can use the Query editor (preview) window to run our SQL query. Follow the below steps to query the serverless tier Azure SQL database.

1. Log in to the Azure Portal (https://portal.azure.com/).
2. Search for the SQL Databases and then click on the search result SQL Databases.

3. Now, you can able to see the list of databases you have. Click on the serverless tier Azure SQL database that you have created above.

4. Now, click on the Query editor (preview) link from the left navigation on the SQL database window. On the SQL server authentication section, provide the Login and Password and then click on the Ok button.

5. Now you can able to see the query window. Paste the below query in the query window and then click on the Run button.

CREATE TABLE Employee (
    EmployeeID int,
    LastName varchar(255),
    FirstName varchar(255),
    Address varchar(255),
    City varchar(255)
);

Now, after running the query you can able to see the query has been executed successfully and the Employee table has been created as highlighted below.

Azure SQL Database Is An Example Of What Type Of Service?

Azure SQL Database is an excellent platform as a service (PaaS) database service from Microsoft. This is basically a fully managed service from Microsoft. The interesting part here is, Microsoft takes care of everything including patching, upgrading, backups, and monitoring the performance, etc. No need for the user to take any headache to manage this stuff.

Azure SQL Database IP Address

Well, you can follow below steps to view the IP Address that your system is using to connect to Azure.

1. You can log in to the Azure Portal (https://portal.azure.com/).
2. As a next tab, Navigate to the server where your database is hosted then go to the Configure tab.
3. Then if you will look at the Allowed IP Address section, you can see the current Client IP Address is being displayed there. Now, To allow the computer to access the server, you can select the Add for Allowed IP Addresses.

How is Azure SQL database auditing configured?

You can find an excellent tutorial on How is Azure SQL database auditing configured. Check out now.

You may also like following the below articles

• How To Deploy SQL Database To Azure
• Create Azure Function using Visual Studio Code and PowerShell
• The Server Was Not Found Or Was Not Accessible
• How To Host A Website On Azure
• How to create an Azure SQL database

Wrapping Up

In this article, we have discussed How To Stop Azure SQL Database, How to Create Azure Database for MySQL using Azure portal, How To Stop Azure SQL Database for MySQL Server Using Azure Portal and Along with this, we have also discussed, How To Stop Azure SQL Database for MySQL Using Azure CLI, How To Start Azure SQL Database for MySQL Using Azure Portal, How To Start Azure SQL Database for MySQL Using Azure CLI, Azure SQL Database Is An Example Of What Type Of Service?, Azure SQL Database IP Address, How is Azure SQL database auditing configured?, Azure SQL Database Serverless, How To Create an Azure SQL Database In Serverless Tier, Query the Serverless Tier Azure SQL database. Hope you have enjoyed this article !!!