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.
133 questions
0
votes
0
answers
35
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
vote
1
answer
94
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
100
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
61
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
84
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
114
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
59
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
57
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
257
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
451
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
831
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
497
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
161
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
10
votes
3
answers
2k
views
How do I drop a database which has brackets in its name?
I have a database which has brackets in its name. (Don't ask! :-\ )
It shows in SSMS but not in Azure because it was canceled while creating. It does not show in the database listing in Azure. It ...
- 369
0
votes
1
answer
40
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,...
- 101