Skip to main content

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.

Filter by
Sorted by
Tagged with
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,...
MyNameHere's user avatar
0 votes
1 answer
139 views

Azure SQL Managed Instance: 1. excessive initial compile times leading to app timeouts and 2. partition maintenance: long-running, bloats data file

We are having a couple of issues preventing us from going live with an on-prem SQL 2016 Std Ed to Azure SQL Managed Instance Business Critical tier re-platform, and I was wondering if anyone had ...
Mike Petrak's user avatar
0 votes
2 answers
74 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 ...
Yossi Geretz's user avatar
0 votes
1 answer
20 views

Do the vCores in my Read-Replica process the synchronization activity?

My initial understanding of my read-replica is that it would be less busy than the primary. After all, the primary is processing all the reads, inserts, updates and deletes which are supporting my ...
Yossi Geretz's user avatar
1 vote
1 answer
39 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 ...
Yossi Geretz's user avatar
0 votes
1 answer
19 views

Can I create a Geo Replica of a Named Replica?

For clarity, we have two databases on a server in a given region. One database is the primary for the read/write workload, and one is a replica for the read-only workload. I'm trying to set up a ...
Yossi Geretz's user avatar
0 votes
1 answer
57 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 ...
Yossi Geretz's user avatar
0 votes
1 answer
91 views

SSMS Won't Show Databases in the Explorer Tree for a Specific SQL Server Account

When logging in as a specific SQL Server user, I was unable to view all the databases in the SSMS Explorer tree. Originally, I thought this was a SQL Server user account problem. I examined the Login ...
Yossi Geretz's user avatar
2 votes
1 answer
209 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 ...
alper's user avatar
  • 147
1 vote
1 answer
22 views

I'm having trouble copying database users from one Azure SQL Server to another. The EXECUTE permission was denied

I'm trying to use the instructions here - https://learn.microsoft.com/en-US/troubleshoot/sql/database-engine/security/transfer-logins-passwords-between-instances to copy logins between the server ...
Yossi Geretz's user avatar
0 votes
0 answers
25 views

Brightgauge agent cannot connect to Azure Sql Managed Instance - TLS Handshake failed

For our Brightgauge agent (third party plugin) that is installed on a local VM, it is getting the following error when we try to configure it to connect to Azure Sql Managed Instance: TLS Handshake ...
Greg's user avatar
  • 574
5 votes
2 answers
215 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....
Joe Obbish's user avatar
  • 32.5k
0 votes
1 answer
118 views

Is there a version of System.Data.SqlClient that does not support Encryption for Connections?

I am looking at IIS server that hosts tens of applications. Some of them are pretty old. All of them are using connection strings that are stored in machine.config in C:\Windows\Microsoft.NET\...
Aleksey Vitsko's user avatar
0 votes
1 answer
150 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 ...
SakZepelin's user avatar
0 votes
0 answers
21 views

Local SQL to Managed Cloud SQL via ADF. Copy Data throughput fell off a cliff

I have an on-site mini PC acting as a data extraction and replication SQL server that copies data nightly from the ERP production database that's running some legacy linux architecture. The copying is ...
funkyman50's user avatar
0 votes
0 answers
33 views

Is Microsoft SQL Managed Instance maximum backup file size still limited to 195 GB?

Is this 195 GB maximum strip size still accurate? https://learn.microsoft.com/en-us/sql/t-sql/statements/backup-transact-sql?view=azuresqldb-mi-current#limitations-for-sql-managed-instance. Microsoft ...
Rosdi Kasim's user avatar
0 votes
0 answers
26 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 ...
SLN Perera's user avatar
1 vote
0 answers
90 views

Permissions for setting a baseline for SQL vulnerability assessment rule

I'm getting a SQL vulnerability error discovered by Microsoft Defender for Cloud. The error points to the following Vulnerability Assessment rule. But when I try to set a baseline (recommended by this ...
nam's user avatar
  • 301
3 votes
2 answers
270 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 ...
Joe Obbish's user avatar
  • 32.5k
1 vote
0 answers
333 views

Azure SQL Managed Instance Gives 'target principal name is incorrect' when using DNS alias

We have a Azure SQL Managed Instance setup. All connects okay, using SQL Authentication using SSMS using it's internal hostname (e.g mysvr.database.windows.net). We have a DNS alias configured, and ...
Jayden's user avatar
  • 141
0 votes
1 answer
77 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 ...
Cody's user avatar
  • 11
0 votes
0 answers
103 views

How to check with TSQL if I'm connected to an Azure Managed Instance in a Failover Group?

How can I check with TSQL if I am connected to an Azure Managed Instance that's in a Failover Group? For Always-On we can use this: SELECT SERVERPROPERTY('IsHadrEnabled') But in the case of Azure ...
Mike's user avatar
  • 658
0 votes
0 answers
109 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 ...
Aleksey Vitsko's user avatar
0 votes
0 answers
67 views

link feature - Azure SQL Managed Instance multiple databases

Is it possible to replicate two databases in the same DAG to an Azure MI? Or is it possible to configure two DAG (single db) pointing to the same Azure SQL MI? https://learn.microsoft.com/en-us/azure/...
MBuschi's user avatar
  • 4,625
0 votes
0 answers
29 views

Using CDC on Read only Secondary Managed instance

We are planning to migrate our on-premises database to Azure Managed instance. Is it possible to use Read Only secondary of the managed instance for CDC.
Anoop Agarwal's user avatar
0 votes
2 answers
229 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 ...
CB_Ron's user avatar
  • 291
0 votes
0 answers
109 views

Error while using linked server in job. The login is from an untrusted domain and cannot be used with Integrated authentication

In SQL managed instance, I have a job. In job procedure, it is using linked server which is also a SQL managed instance. With test login I can read the data using Linked server. I have created the job ...
Narendra's user avatar
1 vote
1 answer
88 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 ...
Yossi Geretz's user avatar
0 votes
1 answer
70 views

How can I copy a database in Azure SQL Server to Azure SQL Managed Instance in different Azure Subscription

I created an Azure SQL managed instance using terraform in Azure Subscription A. I am trying to copy the databases in an existing Azure SQL Server in Subscription B to the SQL Managed Instances I ...
achustle's user avatar
0 votes
1 answer
143 views

Azure SQL Backup Restore

How long will it take to restore 40GB full backup in Azure SQL database, Azure SQL Managed Instance?
SOUser's user avatar
  • 21
0 votes
2 answers
386 views

What is the quickest and most efficient way to remove an in-memory filegroup from a large SQL Server 2019 database?

I have a database with an in-memory filegroup that I want to remove (I won't go into many details why, but I want to move the database to another place without this filegroup). I'm trying to move the ...
dcop7's user avatar
  • 29
0 votes
1 answer
93 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 ...
nam's user avatar
  • 301
1 vote
2 answers
91 views

How to interpret the stats of index usage? [closed]

Question: How do we interpret the stats shown in the diagram below? The stats seem to indicate bad index designing, how can it be improved. I realize this a sort of broad question since it depends on ...
nam's user avatar
  • 301
3 votes
2 answers
452 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 ...
nam's user avatar
  • 301
1 vote
1 answer
64 views

Why permission error when using T-SQL but not when using SSMS

When trying to run the following to create a Server Role, I get permission error shown below. But I can successfully create the same role using SSMS. Question: Why? CREATE SERVER ROLE TestRole ...
nam's user avatar
  • 301
1 vote
1 answer
266 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. ...
ILikeToast's user avatar
0 votes
0 answers
576 views

How to move Azure SQL managed instance cross tenants?

How to move Azure SQL managed instance cross tenants? I have some critical DBs hosted by Tenant_A's SQL MI A which need to be moved to Tenant_B's SQL MI B. They are all TDE encrypted by CMK. Is there ...
DBALUKE HUANG's user avatar
0 votes
1 answer
73 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 ...
Amila's user avatar
  • 1
0 votes
1 answer
511 views

Log shipping from SQL Server Managed Instance to a database on a Virtual Machine, is it possible?

We are looking into Managed Instances as a step forward from Availability Groups on Azure VMs. One of the features we are using now is log shipping from AG primary to an instance that is not a member ...
TheNixon's user avatar
  • 361
0 votes
1 answer
262 views

Minimal permissions to read performance of indexes in SQL server

What minimal permissions can be assigned to a database user so that user can read performance of indexes on tables/views in that database? I am using latest version of SQL Server and Azure SQL Managed ...
nam's user avatar
  • 301
0 votes
1 answer
266 views

is it a good idea to replace azure sql MI replication with CDC and ADF or Azure Function?

The company I work for put everything on azure and we use sql server replication to move data from one big collection db server (a azure sql MI) to our other database servers (say 20 in total). Every ...
jerry xu's user avatar
0 votes
1 answer
2k views

How to set Password Expiration Date in SQL Server

As shown in the screenshot below, we don't see an option to set password expiration date. Question: How can we set a password expiration date of an existing login using SSMS or t-sql. We are using ...
nam's user avatar
  • 301
0 votes
1 answer
301 views

Enabling transparent data encryption on Azure Managed Database

Databases on Azure Managed Instance are encrypted by default. And these dbs have Service-managed Transparent data encryption (TDE). One of our database is a restored database from a .bak file, and ...
nam's user avatar
  • 301
3 votes
2 answers
2k views

Unable to open database properties window in SSMS

I am using Azure SQL MI. Using SSMS, I backed up an SQL db to an Azure container. After that I am unable to open the Properties windows of that database using SSMS. When I right click on the database ...
nam's user avatar
  • 301
0 votes
1 answer
291 views

Migrate SQL Server 2012 databases on premises to Azure SQL

I have SQL Server 2012 databases on premises and I would like to migrate these to Azure SQL However the Application Vendor has not certified their Application on Azure SQL but the following versions ...
Ashok's user avatar
  • 1
0 votes
1 answer
600 views

Azure SQL Vulnerability assessment error

In our SQL Managed Instance database, we created a user-defined database role and added 20 users to it. Now, during scanning by Microsoft Defender for Cloud, we are getting the following error/warning:...
nam's user avatar
  • 301
0 votes
1 answer
357 views

How to interpret output of query store in sql server

I ran the following query shown in the image below. I understand the left pane of the query store below that says query (with id 1962) took about 151000 ms to run. Question: But I don't understand the ...
nam's user avatar
  • 301
0 votes
2 answers
379 views

SQL database is taking up 1.5 TB but only using about 1 TB

SQL Server is almost 98% full. Its one database is taking up 1.5 TB but only using about 1 TB. Can we get any of that space back, if so, how? We are using Azure SQL Managed Instance. File Growth ...
nam's user avatar
  • 301
0 votes
1 answer
3k views

GRANT ALTER to role vs. GRANT ALTER ON SCHEMA

Suppose you create a user defined database role as follows: CREATE ROLE TestRole AUTHORIZATION dbo Question: Which of the following two permissions are more restrictive? Or, do the both statements ...
nam's user avatar
  • 301
2 votes
1 answer
970 views

How to add Azure AD user to a Database role

Question: What may be a cause of the error shown below. The user running the code below is a member of db_securityadmin database role: ALTER SERVER ROLE db_ddladmin ADD MEMBER [myDomainName.com\Juan] ...
nam's user avatar
  • 301