Azure SQL Database
An Azure relational database service.
5,561 questions
0 answers
what is the best way to see all SQL queries in performance insight for azure MySQL?
I have enabled all logs to capture any SQL, but I am not seeing it on the Performance Insights dashboard for SQL queries that take longer than 10 seconds. any help?
asked 2024-09-03T15:44:36.1966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 0%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
Robert Antwi
0
Reputation points
asked 2024-09-03T15:44:36.1966667+00:00
Robert Antwi
0
Reputation points
0 answers
Problem in auto-migration from Mysql Single Server to Flexible
I had an auto-migration scheduled for this morning 03/09/2024 at 6.00 (Italy Time) but the migration was automatically deferred for two days at 05/09/2024 without any explanation about the issue. I have only one doubt, in overview section, of my service,…
asked 2024-09-03T09:47:19.65+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 56.00000000000001%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Stefano Bianchi
0
Reputation points
asked 2024-09-03T09:47:19.65+00:00
Stefano Bianchi
0
Reputation points
1 answer
Getting Internal error while migrating single server to flex mysql server
Getting InternalServerError while running a flex server migration in poc env az mysql flexible-server import create --data-source-type 'mysql_single' --data-source 'server' --resource-group 'poc-infra-rg' --name 'flexserv-01' --key…
asked 2024-06-10T11:21:03.08+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 28.999999999999996%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVA%3C/text%3E%3C/svg%3E)
Varadarajan, Anandji
5
Reputation points
commented 2024-09-02T09:29:59.6633333+00:00
Varadarajan, Anandji
5
Reputation points
1 answer
Azure MySQL event scheduler Issue
I'm using the Azure Database for MySQL service. After a maintenance event on Azure, MySQL restarted. After the restart, the event_scheduler was turned OFF, and the MySQL events we had registered are now in a "DISABLED ON SLAVE" state, which is…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 85%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
1 answer
Connection time out issue after selecting recommended drive option
Hi Team, Currently I can see below notification in Azure data factory portal. Your pipeline is currently utilizing legacy drivers. To avoid any unexpected behavior, please migrate to the latest driver version at your earliest convenience. Click I have…
asked 2024-08-27T09:48:32.7766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 9%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Sharad Gawade
20
Reputation points
commented 2024-08-30T16:49:22.1833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 8%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Smaran Thoomu
14,140
Reputation points Microsoft Vendor
1 answer
Azure SQL Database vs Azure Database for MySQL
"I'm working on a project We're considering using either Azure SQL Database or Azure Database for MySQL for the relational data. I've noticed that Azure SQL Database tends to be more expensive. Can someone explain the main differences between Azure…
asked 2024-08-27T22:27:41.3766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 91%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELB%3C/text%3E%3C/svg%3E)
Likitha Bommasani
0
Reputation points
commented 2024-08-30T06:24:18.6233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
ShaktiSingh-MSFT
14,811
Reputation points
0 answers
Is Azure Support Always This Ineffective?
We've experienced an extremely frustrating situation with Azure Support and would like to know if others have faced similar issues. Here's a brief summary of our ordeal: 1. Production Downtime: On June 18th, we discovered that our CRM was down.…
asked 2024-07-03T15:09:20.5366667+00:00
Alberto B
0
Reputation points
commented 2024-08-29T18:00:40.2+00:00
Oury Ba-MSFT
18,521
Reputation points Microsoft Employee
0 answers
Azure mySql auto-migration from single to flexible server issue
I am attempting to select the Private DNS zone for a private link associated with a MySQL single server instance scheduled for auto-migration. When doing so, I received a green checkmark indicating that the private endpoint was ready to migrate. Upon…
asked 2024-08-12T16:31:28.36+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 69%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJK%3C/text%3E%3C/svg%3E)
Josh Killion
0
Reputation points
commented 2024-08-29T13:46:43.05+00:00
Josh Killion
0
Reputation points
2 answers
Im losing Azure credits for using Azure MySQL database without exceeding the limits
Hi, I recently setup an Azure MySQL database and it said that it is free to use up to a certain amount like: compute: Free upto 750 hours storage: Free upto 32 GB And as u can see in the below image, my usage limit hasn't exceeded at all. But for some…
asked 2024-07-26T09:24:59.4033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 42%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Siddhesh Sreedar
45
Reputation points
commented 2024-08-29T06:19:48.11+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 69%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sai Raghunadh M
75
Reputation points Microsoft Vendor
1 answer
How to Connect Azure MySQL server in Azure Machine Learning Studio
In Azure machine learning studio I am trying to connect an azure mysql server as a datastore. The azure mysql server was created by a colleague and I have the credentials to connect properly. However, after entering the credentials and creating a…
asked 2021-10-29T19:46:24.63+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 80%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMC%3C/text%3E%3C/svg%3E)
Malcolm Cavin
1
Reputation point
commented 2024-08-29T01:52:56.4733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 33%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETN%3C/text%3E%3C/svg%3E)
Tú Nguyễn
130
Reputation points
0 answers
how to fix connect timeout while copiying from mysql to azure sql using AZURE DATA FACTORY
I have this error while deploying the task of copiying 5 tables from mysql to azure sql on datafactory Operation on target ForEach_qx9 failed: Activity failed because an inner activity failed; Inner activity name: Copy_qx9, Error:…
asked 2024-08-20T10:06:29+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 34%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Arturo Beltran
0
Reputation points
commented 2024-08-28T15:29:08.7+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
NIKHILANETHIKUNTA
1,350
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
restore azure mysql flexible server failed
I tried to restore my MySQL flexible server but it keep failed. The error message said: " { "status": "Failed", "error": { "code": "ProvisioningDisabled", "message":…
asked 2024-08-22T13:26:16.0966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 89%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZZ%3C/text%3E%3C/svg%3E)
Zhong Zhou
20
Reputation points
accepted 2024-08-27T18:55:53.45+00:00
Zhong Zhou
20
Reputation points
1 answer
Support of Group Replication for Flexible Server for Azure MySQL Database
Hey guys. Does Azure Database for MySQL - Flexible Server support a mechanism of "Group Replication" as described in the documentation - https://dev.mysql.com/doc/refman/8.4/en/group-replication.html
asked 2024-08-23T19:45:12.06+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 32%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAW%3C/text%3E%3C/svg%3E)
Andrej Weigandt
0
Reputation points
commented 2024-08-27T16:20:16.36+00:00
Oury Ba-MSFT
18,521
Reputation points Microsoft Employee
1 answer
Has Azure database for MySQL changed its IO percentage counting?
We have Azure Database for MySQL flexible server service running as the database for a WordPress site. We have some periodic sync tasks that fetch data from our backend server using WP All Import and it saves the data to this MySQL database. We have also…
asked 2024-08-27T06:41:54.16+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(249.60000000000002, 15%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Harto
5
Reputation points
answered 2024-08-27T08:38:42.58+00:00
ShaktiSingh-MSFT
14,811
Reputation points
0 answers
Registro de Auditoria Servidor Flexible MYSQL.
Servidor Flexible MYSQL dejo de almacenar registros en Cuenta de almacenamiento si causa aparente. cómo puedo solucionar esto?
asked 2024-08-20T21:41:19.37+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 5%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Miguel Angel Jimenez Gonzalez
0
Reputation points
commented 2024-08-23T17:38:51.58+00:00
Oury Ba-MSFT
18,521
Reputation points Microsoft Employee
0 answers
Azure Database for MySQL In-Place Auto Migration Failure: Migration timeout in step: wait until replication lag below threshold
Hi, We have scheduled an in-place auto migration for Azure Database for MySQL in order to migrate from a single server to a flexible server. It was scheduled to migrate on August 16th, 2024 (1:00 a.m. P.S.T.–8:00 a.m. P.S.T.). However, we got a…
asked 2024-08-19T17:57:46.9+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 99%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
SKori
0
Reputation points
commented 2024-08-21T22:39:26.7366667+00:00
Oury Ba-MSFT
18,521
Reputation points Microsoft Employee
2 answers
ADF copy activity is failed due to the source side error
Failure happened on 'Source' side. ErrorCode=SqlOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed with the following error: 'Divide by zero error…
asked 2022-12-22T12:11:15.107+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 64%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Ramanjaneyulu, Maram Venkata
6
Reputation points
commented 2024-08-21T11:59:45.85+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 1%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Anjali Ghosh
0
Reputation points Microsoft Employee
0 answers
MySQL Single Server auto-migration issue / status after EOL / cancelation of auto-migration
Hello, I've tried to set up the auto-migration of two Azure Databse for MySQL instances and provided the additional info (private DNS zone, VNet access, removal of locks) - faced the same issue as this Question:…
asked 2024-08-20T13:18:09.13+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 88%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Artur Kraus
0
Reputation points
commented 2024-08-21T08:54:10.9366667+00:00
Artur Kraus
0
Reputation points
1 answer
String Type does not handle special characters "(", ")", "&", "="
I am loading a csv file with fields Speciality and Webpage URL. Datatype for both of these is set to string Few Examples: Speciality Nephrology (NEP) Internal Medicine (IM) Nephrology (NEP) Dermatology (D) Webpage…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 89%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 61%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Internal Error trying to restore from backup mysql flexible server
Hello, I am experiencing an issue while attempting to restore a MySQL Flexible Server using the Azure web portal. The restoration process fails and I receive the following error message: { "status": "Failed", …
asked 2024-07-31T23:52:38.52+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 4%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDD%3C/text%3E%3C/svg%3E)
Douglas Delefrati
20
Reputation points
accepted 2024-08-18T20:48:52.88+00:00
Douglas Delefrati
20
Reputation points