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,033 questions
2
votes
0
answers
48
views
Restoring Azure SQL MI Backup with CDC to SQL Server 2022 Breaks CDC Metadata
I restore a database with Change Data Capture (CDC) enabled from Azure SQL Managed Instance to SQL Server 2022 Developer Edition.
On restoring, I get this error:
Could not update metadata that ...
- 21
0
votes
2
answers
103
views
VECTOR type fails with “Unknown object type” in DiskANN quickstart
I ran the DiskANN sample script:
<https://github.com/Azure-Samples/azure-sql-db-vector-search/blob/main/DiskANN/diskann-quickstart-azure-sql.sql>
-- Step 3: Create a vector index on the ...
- 113
0
votes
1
answer
52
views
Azure SQL Database - Read Scale-Out - Read Replica Query Store
We are using Azure SQL Server where our database has Read Scale-Out enabled. The documentation claims that Query Store is not available on Read-Only Replicas.
However when I connect to the Read ...
- 103
0
votes
1
answer
57
views
Azure SQL Managed Instance - Manual Backup and restore of database
We got a database hosted on Azure SQL Managed Instance.
Got an application change planned soon and as part of implementation plan, we need to manually take a backup of database on Azure SQL Managed ...
- 1
0
votes
1
answer
62
views
When querying for recently run queries, can I group them by some connection identifier?
Looking at the two methods illustrated here and here to retrieve the most recently run queries in a certain timeframe (and their parameters), is there a way to group or link queries by the connection ...
- 145
0
votes
1
answer
104
views
How can I find the source (hostname, etc.) of one Azure SQL Database query using Extended Events without having to capture every statement?
I want to do this, but there doesn't seem to be a supported way to do it. What is a version that would work?
CREATE EVENT SESSION [MySession] ON DATABASE
ADD EVENT sqlserver.sql_statement_completed(
...
- 2,295
0
votes
0
answers
58
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
183
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
199
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
99
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
214
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
123
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, ...
- 521
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,295
2
votes
1
answer
138
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,295
0
votes
1
answer
228
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