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.
377
questions
0
votes
1
answer
30
views
Azure memory management
This is probably an Azure question but i can't get a sensible response from MS.
Did anything change on Azure's memory management for MariaDB and MySQL in the last few months?
I'd been running 5 ...
1
vote
1
answer
62
views
Move SQL Server database files to Azure storage account container
I'm trying to move SQL Server database files into an Azure storage account container. Creating or restoring databases in container storage works flawlessly, but moving fails.
First, I create a ...
- 11
0
votes
3
answers
84
views
How to add the extension pg_squeeze to shared_preload_libraries in Azure Postgres?
I am trying to enable pg_squeeze on a Azure Postgres instance. I have successfully enabled it in the azure extensions. However, when I go to add it to the shared_preload_libraries I get the following ...
- 332
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 ...
- 339
0
votes
1
answer
48
views
Azure MS SQL Always On Availibity Group Setup Issue
I have 2 VMs on azure where MS SQL server is configured with always on high availability, one VM is acting as primary and other one is secondary. On top of that, there is domain controller VM which is ...
0
votes
0
answers
47
views
Advice on how to script out existing Azure (logical) SQL Server logins and mapped database users (with permissions/group memberships)
Context: We have an Azure (logical) SQL server with a number of logins. Each login has been assigned specific permissions and is mapped as a user for databases hosted on the Azure (logical) SQL server....
0
votes
1
answer
25
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,...
0
votes
0
answers
43
views
SQLAgent high number of handles
We have an Azure VM with SQL Server (SQL Server on Azure Virtual Machines).
When investigating small disconnections from our signalR service running on that server we have seen that SQLAGENT.EXE has ...
- 299
0
votes
0
answers
21
views
Azure Database for MySQL replication using GTID's
I have been testing the Azure Database for MySQL. I need to set up a replica in Azure with the Source database being on prem here.
So far I have got a basic replica set up and running, but I need it ...
- 2,166
0
votes
0
answers
35
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 ...
- 31
1
vote
0
answers
36
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 ...
- 111
0
votes
0
answers
54
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'...
- 1
1
vote
1
answer
53
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 ...
- 21
0
votes
0
answers
32
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 ...
- 355
0
votes
0
answers
109
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 ...
- 101
1
vote
0
answers
49
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 ...
- 111
0
votes
1
answer
133
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 ...
- 101
0
votes
1
answer
58
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 ...
- 21
0
votes
1
answer
105
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-...
- 219
0
votes
0
answers
231
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:
...
- 61
2
votes
1
answer
89
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. ...
- 19
0
votes
0
answers
24
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 ...
James Lee
1
vote
1
answer
72
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 ...
- 21
0
votes
0
answers
28
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 ...
0
votes
1
answer
84
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 ...
user285493
0
votes
0
answers
112
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.
...
- 101
0
votes
1
answer
59
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 ...
- 47
1
vote
0
answers
60
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 ...
- 11
0
votes
0
answers
139
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,...
- 143
0
votes
0
answers
171
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 ...
user1930027
0
votes
0
answers
45
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'
...
- 1
1
vote
1
answer
468
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 ...
- 111
0
votes
0
answers
206
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:...
- 1
0
votes
0
answers
73
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 ...
- 101
0
votes
0
answers
16
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 ...
1
vote
1
answer
213
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 ...
- 2,163
0
votes
1
answer
206
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 ...
- 1
0
votes
1
answer
196
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?
- 3,451
0
votes
2
answers
119
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 ...
0
votes
1
answer
65
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, ...
0
votes
0
answers
50
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....
- 47
1
vote
0
answers
21
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 ...
- 11
1
vote
0
answers
31
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 ...
- 111
1
vote
1
answer
108
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 ...
- 339
0
votes
0
answers
135
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/...
-1
votes
1
answer
81
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 ...
- 1,619
-1
votes
1
answer
388
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 ...
- 1,619
0
votes
1
answer
457
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)...
- 11
1
vote
3
answers
841
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 ...
- 1,619
0
votes
1
answer
219
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/...
- 55