Azure SQL Database

2 answers

Azure Billing related issue

Earlier, I was paying approximately ₹560 per month for Azure SQL Database, which was for a single database running on a basic DTU tier. Last month, I created one additional SQL database in the same Azure tenant. Since Azure charges SQL Database costs per…

asked

EEHA 0

edited an answer

Siva shunmugam Nadessin 5,280 Microsoft External Staff Moderator

2 answers

Intermittent Azure SQL Database Connection Failures on Azure App Service (.NET 8 Linux Containers)

We are experiencing intermittent SQL connection failures from our .NET 8 applications running in Linux containers on Azure App Service, using both: mcr.microsoft.com/dotnet/aspnet:8.0-alpine-3.18-amd64 mcr.microsoft.com/dotnet/aspnet:8.0 (Debian 12…

asked

Nanthakumar S 0

answered

Manoj Kumar Boyini 6,040 Microsoft External Staff Moderator

1 answer

Azure SQL performance issue

I have a dev db with dtu model s3 tier and I also have the uat db with dtu model s7 tier data size is ~similar but the sproc runs with more time in uat than dev one thing I have observed is it takes lot of time to load TOP 100 (20 secs) than TOP 1000 (2…

asked

Hemanth Kumar Kotha 0

commented

Hemanth Kumar Kotha 0

2 answers

Az SQL DB performance issues

Query latency differs across environments (Dev vs UAT) – same stored procedure, different performance I’m facing a performance issue where the same stored procedure and identical query logic behave differently across environments. Problem…

asked

Hemanth Kumar Kotha 0

commented

Hemanth Kumar Kotha 0

1 answer

Can't upgrade to mysql8 linked with wordpress

Hi - I'm trying to upgrade mySQL5.7 to 8.0 and when I chose to validate it comes up with the following errors belo.. For the first one, I did change my defauly char set in the database to be utf8mb4 in the parameter settings, and I did change…

asked

Carrubbers 0

answered

Manoj Kumar Boyini 6,040 Microsoft External Staff Moderator

2 answers

Azure SQL Server General Purpose DB migration to Hyperscale stuck in the first step

Hello I started a small DB migration (~10GB) from General Purpose to Hyperscale before actually upgrading our production DB (~700GB). The problem is that even the small DB is now stuck in this process. I noticed the migration wizard is also buggy (it…

asked

ebahr 0

commented

Erland Sommarskog 132K MVP Volunteer Moderator

4 answers

How much disk space is needed for a Transaction Log (T‑Log) backup for a 1.91 TB database?

Recently, we changed some SQL databases on VM EETAZ1-BHL-ERPL from Simple to Full Recovery Model. Following this, we triggered a full database backup. We have a SQL backup policy configured where transaction logs are backed up every 15 minutes. However,…

asked

Raju Kothapally 10

commented

Manoj Kumar Boyini 6,040 Microsoft External Staff Moderator

2 answers

New-AzSqlInstance skuname bug?

Hello, I have som trouble with the New-AzSqlInstance cmdlet. I want to provision a Managed Instance with Business Critical - Premium-series - Memory Optimized, but it's always set to General Purpose. I use following SKU -Sku @{ Name =…

asked

Julie 140

commented

Manoj Kumar Boyini 6,040 Microsoft External Staff Moderator

1 answer

Users facing issue with archived data retrieval issue on Azure database

Users facing issue with archived data retrieval issue on Azure database, It's taking very long time to retrieve data.

asked

Ramesh Banoth 0

commented

Manoj Kumar Boyini 6,040 Microsoft External Staff Moderator

1 answer

Intermittent Error during Azure App Service to Azure SQL login

Hi Support, We are intermittently observing connection failures when our Azure App Service connects to Azure SQL Database. The connection is successfully established at the TCP level, but fails during the login / TLS handshake phase, resulting in the…

asked

Engineer1 90

answered

Manoj Kumar Boyini 6,040 Microsoft External Staff Moderator

0 answers

How to migrate from Azure SQL Database to Azure SQL Managed Instance

We have a around 100 databases in Azure SQL database on one logical sql server in one elastic pool. The database range from ~5GB to 400GB in size. We want to migrate all databases to Azure SQL Managed Instance due to reasons like better cross-database…

asked

Georg Sieber 5

commented

Pilladi Padma Sai Manisha 3,370 Microsoft External Staff Moderator

1 answer

when I am trying to build distributed availability group in azure portal, I am not able to select size as it's not coming any one that is available in zone1, though I have not mentioned zone1

when I am trying to build distributed availability group in azure portal, I am not able to select size as it's not coming any one option that is available in zone1, though I have not mentioned zone1 anywhere while setting up the high availability

asked

Mandal, Jayita (Cognizant) 0

commented

Pilladi Padma Sai Manisha 3,370 Microsoft External Staff Moderator

1 answer

Unable to connect to my Azure database - Your refresh token has expired

HI team, I am trying to connect to my Azure database using Sql server management studio and is receiving the error. Your refresh token has expired. Can you please help me how to get around this. Error message logs: TITLE: Microsoft SQL Server Management…

asked

Vidhi Jamar 0

commented

Pilladi Padma Sai Manisha 3,370 Microsoft External Staff Moderator

1 answer

How does Azure SQL Managed Instance work with Private Endpoint?

I am using Azure SQL Managed Instance with Private Endpoint enabled, and we would like clarification on the networking requirement. Even when connecting through Private Endpoint, Microsoft documentation and troubleshooting guidance indicate that network…

asked

Julie 140

accepted

Julie 140

2 answers

Agent message code 21118. Failed to connect to Azure Storage '\\filestorage.file.core.windows.net\replshare' with OS error: 67.

We are trying to mount Aure file storage account file share with SQL Managed instance and getting below error: -XCancelEventHandle Global\Distribution-{999CD062-8A3C-4697-9A2A-B241BB5852ED} 2026-01-15 08:28:21.258 Startup Delay: 2800…

asked

Devulacheruvu Venkatesh 0

commented

VRISHABHANATH PATIL 5,175 Microsoft External Staff Moderator

3 answers

Can't register disconnected SQL Server instance

I'm new to azure and I'm trying to create a database for my ASP.NET website. I am having trouble in creating it as I get an error. The error plainly states: "SQL Server registration for ESU" with a line below it that says "Failed to…

asked

Wes Stout 40

accepted

Wes Stout 40

2 answers

Azure Elastic Jobs dynamic enumeration includes databases from wrong elastic pool

I'm experiencing an issue with Azure Elastic Jobs where the dynamic enumeration feature is incorrectly including databases from the wrong elastic pool. Setup: - Two elastic pools: "PoolA" and "PoolB" - Target group using…

asked

Deyvid Todorov 10

answered

Deyvid Todorov 10

2 answers

Get-AzMaintenancePublicConfiguration timeout

Hello, I have some problems with Get-AzMaintenancePublicConfiguration. Sometimes it works perfectly fine, but often it times out. Do you have any advice? Code: $MaintenanceConfiguration = "SQL_NorwayEast_MI_2" $MaintenanceConfig =…

asked

Julie 140

commented

Julie Gabriella Nicolaisen 0

3 answers