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
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
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
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, ...
0
votes
1
answer
256
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
0
votes
0
answers
827
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
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
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
2
votes
2
answers
640
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 ...
- 369
1
vote
1
answer
138
views
Why can't I create more than 1 geo replica for my primary database?
I have a primary database in the Premium service level.
I am trying to create a second geo replica to a different region. The primary is in the East Coast, The first replica is in South Central, and ...
- 369
0
votes
2
answers
836
views
What happens to my read-replica database in failover mode?
I have a few basic questions about Azure failover. I am new to failover. I've been reading the literature and I'm ready to give this a shot. Before I take the plunge, I'd like to have a better ...
- 369
2
votes
1
answer
728
views
Why there is huge gap between allocated and used size in a database
I want to find total used and remaining space for each database in Azure SQL MI.
For that, from an example, when I right click on a database and select properties I see following example output, where ...
- 147
5
votes
2
answers
628
views
How can I delete extended event files from within Managed Instance?
Simplifying a few details, I have a recurring process on SQL Server 2019 which runs every 10 minutes and does the following:
Reads data from extended event file targets using sys....
- 33.2k
0
votes
2
answers
477
views
How automate backup and restore in Azure SQL Managed Instance?
I'm the DBA of one Azure SQL Managed Instance and one of our clients asked us if is possible automate a backup and restore in order to have a copy of one of the database before one of our ETL procces ...
- 21
0
votes
0
answers
32
views
Huge storage increase when executing a alter table query in Managed Instance Database
I have a table which consist of more than 2 million records in a azure managed instance database. When I'm trying to add columns to the table using alter command, storage space is increasing ...
3
votes
2
answers
608
views
How do I resolve this python runtime error in Azure SQL Managed Instances?
We recently setup a new managed instance through the program that allows you to try it for free. When trying to run the following code from Microsoft's documentation:
EXECUTE ...
- 33.2k
0
votes
1
answer
177
views
Looking for best option(s) to have near real-time data synced from SQL Managed Instance to another SQL Managed Instance
I have two SQL Managed Instances
1 - Primary Production
2 - Reporting / Analytic workloads
Besides traditional SQL replication (transactional) what is the best way to get data in near real-time from ...
- 11
3
votes
1
answer
812
views
How to get Email Alerts for Errors severity 17-25 on SQL Managed Instance?
Discovered that In Azure SQL Managed Instance, there's no Alerts feature under SQL Server Agent.
According to documentation, Alerts feature for SQL Agent is not yet ready for MI. Hopefully it will be ...
- 6,225
0
votes
2
answers
465
views
In SQL Server, if I have two otherwise identical stored procedures with different names, will they use the same execution plan?
Azure SQL Managed Instance. Here is the scenario. I have a stored procedure that produces a count of rows that match some criteria. But, depending on the Customer that is chosen, the statistics can be ...
- 291
1
vote
1
answer
178
views
Can I develop a Dashboard Report for Data Allocated vs Max Storage for my Azure Database?
I have an Azure SQL Server Database - Managed Instance I'd like to monitor. Here is the widget that Azure shows me on the database summary page. I'd like to put this widget, or at least the ...
- 369
0
votes
1
answer
207
views
Azure SQL Backup Restore
How long will it take to restore 40GB full backup in Azure SQL database, Azure SQL Managed Instance?
- 31
0
votes
1
answer
152
views
Do I need a clustered index on a table with only few columns?
Table:
Address (
AddressID bigint,
Street VARCHAR(150),
City VARCHAR(200),
State CHAR(2),
State VARCHAR(5)
)
Table size: 5GB, 60 million rows.
AdressID is sequential.
Remark: 95-98% of ...
- 525
3
votes
2
answers
535
views
How to gather Index usage information
Following query correctly outputs number of seeks, scans, etc. I have question on understanding some rows in the output. In some output rows of the query, the index name is shown as NULL and the ...
- 525
1
vote
1
answer
885
views
SQL Server to Managed Instance - New managed instance link feature
I have been looking at the managed instance link feature.
Specifically, using the DAG feature to replicate a database on SQL Server 2019 Enterprise Edition, to SQL Managed Instance.
I have hit a wall.
...
- 11
0
votes
1
answer
110
views
Why don't I get Index Seek for my non-clustered index
Version: Microsoft SQL Azure (RTM) - 12.0.2000.8 (Azure Managed Instance)
I'm working with a table (ActivityAttributes) that has ~190Mn rows. I've created an Index as below.
CREATE NONCLUSTERED ...
- 1