Questions tagged [azure-sql-database]
Azure SQL Database is a relational database-as-a-service from Microsoft. This tag is for questions about Azure SQL Database, NOT SQL Server hosted in an Azure VM (use azure-vm).
1,028 questions
0
votes
0
answers
30
views
AzureSQL - JDBC - Threads hung over socket read
I have a Java application with an ETL process running with Azure SQL DB and some times the processing just freezes but the app still runs. I did some thread dump analysis and found that during this ...
- 91
-1
votes
1
answer
97
views
Azure SQL DB - High Parallelism Waits
I'm performing a health check on Azure SQL Database after reports of intermittent timeouts from the application. This is my first time dealing with this particualar environment. From diving into query ...
- 491
1
vote
1
answer
127
views
Question on Index Fragmentation and Index Rebuilds
I am currently sitting with an Azure managed SQL-server, with all my table indexes sitting at >99% fragmentation. For some reason this instance was set to use DTU's, it's on a 250 tier. These ...
- 21
4
votes
1
answer
73
views
SQL Server Estimates don't use AVG_RANGE_ROWS for Uniqueidentifer Parameter
I'm trying to debug a very weird query row estimation.
The query is very simple. I have a table OrderItems that contains for each Order (column OrderId) the items of the order.
SELECT count(*)
FROM ...
- 143
2
votes
1
answer
184
views
Reduce Parallelism Without Setting MAXDOP
I am trying to reduce parallelism in my query without explicitly setting MAXDOP. I have been informed that MAXDOP can hinder throughput as the platform grows and query executions increase (happy to be ...
- 165
2
votes
1
answer
73
views
Temporal table return UPDATED.ValidFrom duplicates
Im trying to understand Temporal Tables in SQL Server better, and how I can recreate an issue we have.
Sometimes the time returned from UPDATE is not the same as what is really stored in the table, ...
- 511
6
votes
4
answers
1k
views
Does the new locking optimization make batching unnecessary?
Optimized Locking (2025-05-19) makes it sound like batching would be unnecessary if I were to, for example, try to delete 20 thousand rows from a million row table in one statement (DELETE FROM foo ...
- 2,283
2
votes
1
answer
111
views
How can I determine the state of an Extended Events session (started or stopped) in Azure SQL Database?
How can I determine the state of an Extended Events session (started or stopped) in Azure SQL Database? The DMV sys.dm_xe_database_sessions doesn't have this information, and none of the other sys....
- 2,283
0
votes
1
answer
138
views
Azure SQL Database Backups PITR & LTR
I have so much confusion how Azure SQL database backups PITR & LTR Works. I have observed few things from the backup as follows;
PITR - Earliest Point in Time Retention happening every day. for ...
Abdul Khadar
0
votes
0
answers
68
views
DACPAC deployment hangs at Updating database (start)
We are currently in the middle of creating a proof of concept using DACPACs as our deployment/release method rather than our in-house deployment product. The two databases that I am currently using to ...
- 115
0
votes
1
answer
66
views
Database User properties window error. Azure SQL Managed Instance, AAD Users
I manage a dw that's hosted by Azure, and all Logins on the server (except for a couple service accounts) are Azure Active Directory logins tied to my company's tenant. When granting db_reader access ...
1
vote
1
answer
58
views
Azure SQL failover Group testing
If I set up a failover Group for an Azure SQL Database (not a Managed Instance or SQL Server on VM), is it possible to do a test failover, so there is a copy of the Azure SQL Database available for ...
- 53
0
votes
0
answers
63
views
Slow Azure SQL DB inserts vs updates
I have some code running merge statements on a table and the inserts are running about 4x as slowly as the updates. I suspect this is due to the Azure SQL database needing to repeatedly grow the ...
- 133
0
votes
1
answer
68
views
Azure Db - Port bloking 1433 - Macbook will not connect
It's like this, I have moved my web app Blazor from Windows computer to Mac Pro m4
It's like that every time I try to create access to the database it gives me an error. It's like that I have tried to ...
- 3
0
votes
2
answers
179
views
How to retain user logins & passwords when migrating Azure SQL Server database via BACPAC
I have a production application running on Azure with an Azure SQL Server and a SQL database inside it. In my application, all users are created at the database level with their passwords.
I need to ...
