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).
999
questions
2
votes
2
answers
93
views
Automatic index creation - too many
When we have the auto tuning set to ON for index creation, the Azure SQL Hyperscale db has created about 10 indexes for some of our large tables. In analyzing the indexes, some of them differ only in ...
-1
votes
1
answer
15
views
Not able to configure DataSync in azure sql
Trying to configure DataSync for Azure sql db with on premises SQLServer DB. Got this error.The sync database specified (sqlserver1\sql-syncmeta-prod-east-001) does not match the existing sync ...
2
votes
1
answer
82
views
Query Store Plan Forcing is Failing with OPTIMIZATION_REPLAY_FAILED
I am trying to use Query Store to force a particular plan in an Azure SQL DB database, and it's not obeying me! I've checked in sys.query_store_plan, and it has a column which describes the reason for ...
-1
votes
1
answer
67
views
How do I measure the SQL Database responsiveness
I am load testing my web app which is Azure App Server + Azure SQL Database.
I am looking at the the Azure data dashboard metrics as we load test it and most measures (DTU percentage, CPU percentage, ...
8
votes
3
answers
887
views
View doesn't recognise a change to an underlying table when an existing column is dropped and replaced with one with the same name but as computed
My understanding here is that when a View is created, the definition is stored in metadata sys.tables. i.e. sys.views.
Also, that if you use SELECT * FROM it will store the exact column names e.g. ...
1
vote
0
answers
51
views
Spatial index performance
I need help to improve query performance of a spatial query.
I have the following query:
DECLARE @Longitude float,@Latitude float
SET @Longitude = -79.46278668733325
SET @Latitude = 43.70410072435495
...
0
votes
1
answer
34
views
Database Engine Tuning Advisor in Azure
We have several performance issues, which I think could be mitigated by proper indices, better queries or even partitioning as some tables have over 1B records.
I was hoping to use Database Engine ...
2
votes
1
answer
144
views
sp_BlitzIndex run against an Azure SQL database
I've added this SP to my database and it returns useful results. The part I'm not sure about is the usage numbers. I'm new to Azure SQL but I'm told by the old hands that the server never gets ...
0
votes
0
answers
11
views
Getting Deadlock in Azure SQL Server and Victim query in Microsoft Internal Query
I am getting Deadlock in Azure SQL Server
There is only 1 Victim query which "Looks like" Microsoft Internal query.
The other Query is Alter Column Statement
ALTER TABLE [SomeSchemaName].[...
8
votes
2
answers
575
views
%%LOCKRES%% - SQL Server - Row identifier causing Deadlocks - possible bug
Recently I came across an issue where I am facing deadlocks in SQL Server databases (19.2.56.2) due to the internal hashing mechanism of the Row identifier virtual column - %%LOCKRES%%
On analysis I ...
0
votes
1
answer
21
views
How to better organize customer identifiers?
I've come in to managing a microsoft sql azure (12.0) server and need a little help with a table. I've worked as a data analyst for several years so understand some basic ideas with server management,...
0
votes
1
answer
38
views
View on a history table - question how implement a view on history table
question about creating a view with history table.
I've got a table that i moved old rows to history table,
now i would like to delete the data from the main table.
Main table : Currency....
4
votes
1
answer
248
views
Granting SELECT...INTO permissions
I've created a new schema, archive, and am able to create, read, update and delete tables within it.
I have an EXTERNAL_USER who I'm trying to give permissions to so that they can carry out select.....
0
votes
2
answers
78
views
How can I monitor query performance on my Azure read-replica database?
I'm looking at Query Performance Insight for my read-replica database. But the information it shows are the performance stats from the primary database. How can I get the performance stats for the ...
-2
votes
1
answer
195
views
CXSYNC_PORT & "Long running low CPU"
I have a simple query like select * from MyTable where MyTableID=@p1where sp_BlitzCache warns me about "Long Running with Low CPU". The table has a clustered index on MyTableID, which is a ...