Questions tagged [azure-sql-managed-instance]
SQL Server Managed instance, a deployment option of Azure SQL Database providing compatibility with the latest SQL Server on-premises Database Engine with PaaS features and capabilities.
135 questions
0
votes
0
answers
32
views
Sqlpackage.exe is dropping default constraints and computed columns [duplicate]
I'm deploying database schema-only (no data) changes to our Azure Sql Managed Instance via Azure DevOps task SqlAzureDacpacDeployment@1, and for some tables it is always dropping and re-creating ...
- 582
-1
votes
0
answers
15
views
Is application intent supported for Azure sql db and Azure sql managed instance?
Azure sql db doesn't support listener. Whereas Azure sql managed instance supports listener.
Azure sql db geo replication diagram is shown below. Why is application intent shown when Azure sql db ...
- 3,568
1
vote
1
answer
44
views
Azure SQL MI - SQL agent job failure notification does not show correct host name
I have Azure SQL MI - SQL agent job notification setup to send an email whenever SQL agent job fails. However, I noticed that job failure email notification does not show correct host name within ...
- 171
1
vote
1
answer
61
views
execute job only on primary replica ( R/W) of Azure SQL MI failover groups
I am trying to setup SQL agent job that will only execute if it is primary replica of Azure SQL MI of failover groups.
I am trying to get primary replica using sys.dm_hadr_database_replica_states ...
- 171
1
vote
2
answers
30
views
Multi subnet failover for Azure PaaS failover groups
should the multisubnetfailover=True parameter be added to connection strings to Azure failover groups?
- 53
0
votes
0
answers
47
views
SSIS execute sql task fails with "parameter name is not recognized" against Azure SQL MI database but works fine against on-prem database,
I have on-prem SSIS package with execute SQL task. Execute SQL task has been runnning without any issue with following parameter mapping when executing against on-prem SQL 2019 database.
On-prem ...
- 171
0
votes
1
answer
64
views
Unable to connect to Azure SQL MI from on-prem SSIS package
I am trying to connect to Azure SQL MI from on-prem SSIS package. However, I am unable to connect even with MS Oledb driver 18.
I did udl connection test to Azure SQL MI from on-prem ssis server with ...
- 171
0
votes
0
answers
36
views
Issues converting an XEL (Extended events file) to XML with the help of PowerShell in Azure automation Runbook
I need some advice to convert the XEL file to XML. I am executing a PowerShell script in Azure Automation runbook in Azure portal to store the XEL file from BLOB storage to my local machine, ...
1
vote
0
answers
40
views
Query Performance Issue in oracle to Azure SQL Server migration
I am working on SQL Query which runs in oracle for 2 sec but in Azure SQL server running for 45 mins from hibernate Java. upon investigations here are details, finding and steps taken
Query Have 45 ...
0
votes
1
answer
219
views
Performance issue when using an inequality in the WHERE clause
I have the following code on a SQL Server Azure Managed Instance and the performance is pretty terrible.
INSERT INTO #CU WITH (TABLOCKX) (LA_ID, CU_ID)
SELECT la.LA_ID,
c2.CU_ID
FROM #la la
...
- 24.3k
3
votes
1
answer
323
views
sp_blitzlock returns blank data in SQL Managed instance
I have a SQL Managed Instance in Azure with some blocking/deadlocking going on. This DB was on-premise and had all the scripts installed, so I uninstalled them and then installed the Azure specific ...
0
votes
0
answers
51
views
Azure SQL Managed Instance and Microsoft Entra ID authentication with Transactional Replication
I am setting up transactional replication with an Azure SQL MI as my pub/dist, and Azure SQL Database as my sub. I've got everything working using sql authentication, but when I try to configure it ...
- 582
0
votes
0
answers
567
views
OLE DB provider "MSOLEDBSQL" for linked server "Logging" returned message "The parameter is incorrect"
Our problem:
We have multiple clients, each with their own database.
We are logging changes from certain tables to a central database called Central.
The logging process requires SELECT, INSERT, ...
- 24.3k
0
votes
1
answer
364
views
Need to read the SQL server error logs from SQL Server Managed Instance and alert from Azure portal
We have simulated some error logs within our SQL Server Managed Instance. The SQL Server error logs are within the Management folder. I have a simple requirement wherein I am stuck streaming these ...
0
votes
0
answers
121
views
Azure Managed Instance - Issue with NotifyLogPoolMgr Shrinking Logpool Under Memory Pressure in Database
I'm encountering an issue with our database where the NotifyLogPoolMgr is shrinking the log pool under memory pressure. The specific message in the logs is as follows:
NotifyLogPoolMgr in DB: 5 ...
- 1