Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [azure]

Microsoft Azure is a Platform as a Service and Infrastructure as a Service cloud computing platform. Use this tag for database administration questions involving Azure. General server help can be obtained at Super User or Server Fault.

Filter by
Sorted by
Tagged with
0 votes
0 answers
9 views

Connect to a Private SQL Always On Availability group listener with Azure App

We have a fairly standard Azure Webapp - connecting via public IP to a database server which is a VM hosted in Azure. NSG rules etc limit the traffic between the two. The VM hosting the database is ...
RPD's user avatar
  • 1
1 vote
0 answers
11 views

Azure SQL Migration extension don't support MFA authentication

I'm trying to migrate an on-prem Sql Server database to Azure SQL Database. I'm using Azure Data Studio with Azure SQL Migration extension. My problem is that Azure SQL Database is configured by dba's ...
Valmir Cinquini's user avatar
0 votes
0 answers
17 views

Azure MySQL and AWS RDS insert performance difference

We had to move our infra from AWS to Azure (reasons irrelevant) and I've set up a same spec DB instance on Azure, even a tier larger (2c/8g on AWS and 2c/16g on Azure, both memory optimized). What I'...
pyr0hu's user avatar
  • 1
1 vote
1 answer
35 views

How to choose hardware for MYSQL Server in Azure - Flexible Server

I have a MYSQL Flexible Server in Azure with the following hardware configuration: MYSQL 8.0 Compute Tier: Business Critical - 16 vCores Size: E16ds_v4 Storage: 269 GB AutoScale IOPS RAM: 128 GB I ...
SakZepelin's user avatar
0 votes
0 answers
11 views

Usage of SparkMetric_CL, SparkListenerEvent_CL and SparkLoggingEvent_CL

I am wondering If can retrieve any information from Azure Log Analytics custom tables (already set) for Azure Databricks. Would like to retrieve information about query and data performance for SQL ...
adam.g's user avatar
  • 355
0 votes
0 answers
16 views

Using Entra authentication with a group as the admin fails

I'm trying to connect to an Azure Sql Server resource using Entra authentication only (not mixed). I have an Entra group for my project with the team members who can function as admins on the sql ...
Brad's user avatar
  • 101
1 vote
0 answers
24 views

Slow inserts into Azure PostgresSQL database

I have a simple table on what is basically a completely fresh database: create table import_test_uuid ( id integer not null generated by default as identity primary key, guid uuid ); I am ...
mohamedmoussa's user avatar
0 votes
1 answer
24 views

Mariadb Galera can't start second node

EDIT: the both server was in Azure I tried to install Galera replication on two server. On my first server the "bootstrap" node will correctly start. When i try to start the second node with ...
Inazo's user avatar
  • 101
0 votes
1 answer
39 views

Divide by Zero error in Materialized Views in Azure Synapse Dedicated SQL Pool

I have a materialized view in Azure synapse Analytics dedicated sql pool which has a calculate column X / denominator. When I select the view select * from myview it does not give me divide by zero ...
SOUser's user avatar
  • 21
0 votes
1 answer
40 views

How to connect in case Azure Cosmos DB default force use TLS/SSL?

My case: Client: Windows 10 x64. pgAdmin 4 version 8.4 (latest). Server: Cloud Azure Cosmos DB for PostgreSQL burstable, version 16. My connection string will be likes this jdbc:postgresql://c-...
Vy Do's user avatar
  • 209
0 votes
0 answers
117 views

How can I improve low IOPS performance for an Azure SQL Database Hyperscale elastic pool?

I'm doing performance testing a series of data migration scripts which mainly consist of large INSERTs (sometimes 100M-200M records) with often complex SELECTs with a lot of hash joins. Configuration: ...
Andrew G's user avatar
1 vote
2 answers
51 views

Getting "PAGEIOLATCH_SH" on a Named Replica of a HyperScale Database in Azure?

I have a monitoring query that populates a dashboard. It was created to monitor the transactions that occur on the primary replica. To avoid overloading the Primary Replica, I created a Named Replica. ...
Heliot's user avatar
  • 9
0 votes
0 answers
12 views

Microsoft SQL Data Sync 2.0 Agent not listing any databases since server move

I have SQL Data Sync set up to keep a few databases installed in a remote data centre synchronised to an Azure SQL dB used for BI reporting. Recently the physical SQL server on the data centre side ...
user avatar
1 vote
1 answer
62 views

Increment a field in runtime for Synapse SQL dedicated SQL Pool

I have a task to increment the expected flag column by looking in to existing values. I solved this using while loop and I can get the expected value updated using while loop in Azure synapse-Sql ...
SOUser's user avatar
  • 21
0 votes
0 answers
25 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
0 votes
1 answer
39 views

SQL Server TDE with Keyvault - how often does it need to contact keyvault?

I have set up two SQL server VMs in Azure with Availabilitiy groups and transparent data encryption with the key residing in keyvault. I thought that the SQL server would only have to reach out to ...
user avatar
0 votes
0 answers
88 views

Database disappear from Failover Group

I run an Azure subscription with a main SQL Server in West Europe and a georeplicated SQL Server in North Europe with a failover group. In these servers I have two elastic pools with the same name. ...
Paolo Crociati's user avatar
0 votes
1 answer
37 views

performance - Alter table from NVARCHAR(MAX) to NVARHCHAR(4000) - HADR_THROTTLE_LOG_RATE_MISMATCHE -

I'm Altering some tables with a lot of NVARCHAR(MAX) column to NVARCHAR(4000) in Azure sql environment. I've already upscaled the database to 3000 DTU, and executed the script to alter. I see that ...
dexon's user avatar
  • 47
1 vote
0 answers
39 views

MongoDB: Queries running 3x slow on Azure Serverless Mongodb compared to MongoDb Atlas Free Tier server

I have a database in MongoDB Atlas using the free tier package. I recently transferred my data to Azure Serverless CosmosDB for MongoDB using mongoexport. After the data transfer, I've noticed that ...
Veli Eroglu's user avatar
0 votes
0 answers
75 views

How to get the Azure SQL maximum database limit?

We are 3rd party for the customer, and we implement the web application on the top of their ERP data. They migrated to Azure SQL (cloud) about 4 years ago. Currently, they observe performance problems,...
pepr's user avatar
  • 143
0 votes
0 answers
114 views

Mounting mysql /var/lib/mysql on Azure File Share

With Azure Container Apps, I'm trying to mount mysql on Azure file share, and the container shows running status but as soon as I enable ingress on TCP 3306, the container fails. InnoDB ...
user avatar
0 votes
0 answers
33 views

Trying to speed up production build using Gradle with Azure Devops

https://docs.microsoft.com/azure/devops/pipelines/ecosystems/android pool: vmImage: 'macos-latest steps: -task: Bash@3 - displayName: Check for skippable builds inputs: targetType: 'inline' ...
DarraghM's user avatar
1 vote
1 answer
275 views

Azure SQL Database Elastic Pool Resource Limit Exceeded - How to Resolve?

I'm encountering an issue with my Azure SQL Database where I'm receiving the following error: System.Data.Entity.Core.EntityCommandExecutionException: An error occurred while executing the command ...
Jef's user avatar
  • 111
0 votes
0 answers
151 views

Failed to connect to Azure SQL Database using ODBC Driver 17 with Authentication=ActiveDirectoryMsi

I was trying to connect the Azure Container Instance to my Azure SQL Database using Azure Active DIrectory User Managed Identity. But I can't establish a connection using ODBC Driver 17. Error Message:...
xbai15's user avatar
  • 1
0 votes
0 answers
57 views

Whitelist Azure Databricks SQL Warehouse access to selected tables

Is there an option to allow a service principal (SP) that accesses Azure Databricks SQL Warehouse using a personal access token (PAT) to restrict access only to selecting data from present tables and ...
Talos's user avatar
  • 101
0 votes
0 answers
15 views

Need to build MySQL replication with TSL cert between onPremises server as Master and Azure flex server as Slave

I have a requirement Need to build MySQL replication with TSL cert between onPremises server as Master and Azure flex server as Slave . On Master & slave host ssl is enabled . also i have followed ...
Uday Raj Gupta's user avatar
1 vote
1 answer
144 views

Download certificate from Key Vault w/ private key for use in SQL Server (TDE) via powershell

I need to download an x509 Certificate from Azure Key Vault and import it in SQL Server to use for TDE. Note: I'm not referring to EKM providers/ASYMMETRIC KEYs, where SQL accesses key vault to pull ...
StrayCatDBA's user avatar
  • 2,088
0 votes
1 answer
143 views

Configuring SQL Server 2019 Always ON between 2 Azure reqions

I have SQL Server on Azure VM which I want to replicate across a separate region. I will only be using 2 servers, each in a separate region. I have the following questions as I need to clear all ...
dennis's user avatar
  • 1
0 votes
1 answer
133 views

What is the benefit of multiple subnet (FCI/AG) in a virtualized setup?

In a virtualized setup, for example on-prem VMware based virtualized setup or Azure based VMs, what exactly is the benefit of placing the SQL FCI or AG nodes in separate subnet?
variable's user avatar
  • 3,634
0 votes
2 answers
75 views

Azure Disk performance optimizaton in SQL VM

We are using Azure SQL VM and we have multiple data files of multiple databases stored on same drive (let's say Drive E: of size 3 TB) which is created from 4 * 512 GB disks + 4 * 256 GB disks. I was ...
Bishal Basyal's user avatar
0 votes
1 answer
49 views

How to add information about two same named databases on different hosts in PgBouncer config file?

I want to add details for databases in a config file of pgbouncer. I have two same database names but their hosts are different, as there is no information about server endpoints in the config file, ...
Pratiksha Ratnaparkhi's user avatar
0 votes
0 answers
24 views

Move data between DBaaS with Azure pipeline

I need to move data from tst DBaaS to acc DBaaS, DBaaS are not connected as azure resource or something like that. Im trying to select some data from DBaaS A and insert it in DBaaS B using Linux Agent....
user avatar
0 votes
0 answers
44 views

Azure Hybrid Benefit-Self-Installed SQL Server on Azure VM

The Microsoft documentation says if you self-install SQL Server on Azure VM, you need to manually register with the SQL IaaS Agent Extension and activate Azure Hybrid Benefit. https://learn.microsoft....
steve's user avatar
  • 47
1 vote
0 answers
20 views

New WS install win11 Pro and O365: Connection to DB fails due to change in ownership from SQL to Azure. Is it a Permissions issue?

Security System: Unable to connect to Local Database Template. Error Message: The remote computer that you are trying to connect to requires Network Level Authentication (NLA), but your Windows domain ...
Dragonfly's user avatar
1 vote
0 answers
282 views

[error]Script failed with error: Error: Unable to locate executable file: 'powershell'. Please verify either the file path exists or the file

Functionality: Copy Data to Azure PostgreSQL Server through CI/CD Pipelines I have the SQL Script file of local PostgreSQL DB in the Azure DevOps Repository: Using Classic Editor, I have added few ...
user avatar
0 votes
0 answers
44 views

MariaDB in Azure Converted to Read-only mode

We have a MariaDB instance in Azure following the specs General Purpose, 2 vCore(s) Auto Scale in Size No Read-Replicas Previously It was in 10GB, after adding a couple of queries, the storage ...
user avatar
1 vote
0 answers
28 views

REINDEX not using all available resources, running forever

I have an Azure Database for Postgresql Single server instance, which is running PostgreSQL v11. In it, I have a table responsible for gathering the metrics regarding user logins. The table definition ...
Marcel's user avatar
  • 111
1 vote
1 answer
79 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
0 answers
96 views

Enable Azure SQL DAC (Dedicated Admin Connection)

This page claims that you can connect to Azure SQL with a Dedicated Admin Connection (DAC but not Data-tier Application): https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/...
Simon Norton's user avatar
-1 votes
1 answer
62 views

Azure SQL Database :: SHRINKDATABASE increase the unallocated space

I'm trying to squeeze as much Azure SQL Databases as possible in order to make them fir inside a SQL Elastic Pool. I'm using this query that allows me to compare the unallocated space before and after ...
Francesco Mantovani's user avatar
-1 votes
1 answer
334 views

SQL Elastic Pools: "The semaphore timeout period has expired" while REBUILD index

I'm shrinking databases that are already on a SQL Elastic Pool. The goal is to fit as much as possible databases in a unique Elastic Pool. In order to do so I've stubble upon a blog that suggest to ...
Francesco Mantovani's user avatar
0 votes
1 answer
367 views

How should I handle index maintenance on partitioned tables in Azure SQL DB?

let's start saying that i have no experience with partitioned tables and i'm not quite sure how to handle index maintenance (periodically Rebuild / Reorganize, if needed, to reduce index fragmentation)...
Grasba's user avatar
  • 11
1 vote
3 answers
583 views

How to shrink databases and claim more storage

I have created a SQL elastic pool but I have no more storage: I run DBCC SHRINKDATABASE (N'db1') on every single database to claim space following this guide: Reduce Azure SQL Database Size but it ...
Francesco Mantovani's user avatar
0 votes
1 answer
129 views

Configuring a DNN listener for an availability group fails

I am running into problem when creating DNN listener on Azure VM. I am runnign the script provided in Microsoft article: https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/...
VitalicJJ's user avatar
0 votes
0 answers
81 views

Azure Elastic Job running a stored procedure says it completes but is faster than in SSMS

I've set up an Azure Elastic Job to run a Stats Update on several Azure SQL Shards. When I run this SP on the shards from SSMS some are quick and some take over an hour. When I run the Elastic Job it ...
Chris Ward's user avatar
1 vote
0 answers
66 views

OPEN SYMMETRIC KEY from AKV takes too long randomly

This post is similar to another question listed here. Encrypting data by OPEN SYMMETRIC KEY by ASYMMETRIC KEY created with Azure provider in SQL server takes more than 2 min We are also facing the ...
Imtiyaz Thange's user avatar
0 votes
1 answer
105 views

How to archive a on-premise sql server database to azure

We have an on-premise database of about eight terabytes that we are trying to archive to Azure. How can we go about it? This archive needs to be accessible because we might need to pull data from it ...
user avatar
0 votes
0 answers
562 views

SQL*Net message from client too important

It is not easy to describe my problem but I will try. We noticed a slow processing problem with the database when migrating an application from a current VM named VM1 (RedHat 7.9, Java 8, Tomcat, ...
user avatar
0 votes
2 answers
783 views

Import data from on-premise SQL Server to Azure SQL

I need to copy data from an on-premise SQL Server to Azure SQL Server (on existing database). I've tried through a .bacpac file (no good, it create a new database) and with SQL Server Management ...
user avatar
1 vote
1 answer
104 views

Azure VM Drive size configuration for MS-SQL

I have run into a scenario for a production server where I was recommended to create a separate drive for each one of the bigger clients (based on database sizes) whereas all other smaller clients can ...
Bishal Basyal's user avatar

1
2 3 4 5
8