Questions tagged [azure-vm]

For questions about databases hosted on a Microsoft Azure Virtual Machine. It is NOT for Azure SQL Database (use azure-sql-database). Please add an additional tag to specify the database product e.g. SQL Server, Oracle, MySQL or MongoDB.

Filter by
Sorted by
Tagged with
0
votes
1answer
32 views

Azure VM backup best practice

I have a customer who has just lifted-n-shifted their 1TB SQL Server 2008 R2 production, and QA servers (2 servers) to Azure IaaS from a small cloud provider. What is the best practice for backups? I ...
1
vote
0answers
25 views

Data migration assistant showing breaking changes/ behaviour changes for SQL 2019 but not for Azure SQL Managed instance

I am trying to assess the potential issues while migrating a SQL Server 2012 on-prem database to Azure, with SQL on Azure VM and Azure SQL Managed instance as targets. For SQL on Azure VM, DMA is ...
4
votes
1answer
141 views

Does Azure VM backup also backup SQL DBs?

I'm trying to disentangle our backup strategy, and also troubleshoot the overnight backup of the Azure VM and of the SQL DBs to local storage on the Azure VM, via an agent job and maintenance plan. ...
1
vote
1answer
95 views

On premise vs Azure SQL server performance

This is moved from the programming site: Part of performance testing in azure, I have a query that creates 400 transactions, each transaction running an update on a table. Running this query on the ...
0
votes
0answers
28 views

Azure SQL Server two-node Workgroup Availability Group

I have two SQL Server VMs in Azure. They are not on a domain, they are in an Azure DMZ to remain secure. We currently are utilising SQL Mirroring for DR & patching purposes. However due to the ...
1
vote
0answers
20 views

Azure VM SQL Server Automated Backup doing log backups only

We have an Azure VM running our own copy of SQL Server 2019, and we have just configured the Automated Backup functionality. I have it configured like this: Everything seems to be fine, except for ...
0
votes
1answer
24 views

Windows clustering in Azure VM (Windows 2012 R2)

I am going through this document to build a SQL Server Always On cluster. I read through this page to understand why we need a load balancer in Azure for the listener to work. That brings me to this ...
0
votes
2answers
75 views

Database corruption on VM shutdown

We moved a SQL Server database to a virtual machine in Azure. Since the database only contains historical data and does not have transactions anymore we want to turn off and turn on the VM on a ...
0
votes
0answers
606 views

PostgreSQL 'server closed the connection unexpectedly' when using the hostname (Azure VM)

I have a Postgres instance running on an Azure VM, which is inside an Azure Virtual Network, and the VM has a hostname. Connecting with PostgreSQL using the IP address works, but when I try to ...
0
votes
1answer
114 views

Why Azure site recovery may not meet RPO?

While Azure Site Recovery may meet RTO, it may not meet RPO since it is not accounting for where data is inside SQL Server. I am looking for an example for what it means by "is not accounting ...
0
votes
0answers
72 views

Azure Data Factory pipeline accessing MariaDB

I have MariaDB running in a virtual machine in Azure. I need to move data from a file (in Azure storage) to a table in MariaDB using Azure Data Factory (ADF). There's no connector in ADF to write to ...
0
votes
0answers
13 views

SQL Azure VM Usecase for each backup type

It seems that within the Virtual Machine category in Azure the solutions for backups become increasingly complex when compared to the PaaS options. What is the use case for each backup solution, and ...
1
vote
2answers
50 views

How to size SQL Server VM so that it is comparable to bare metal primary SQL server?

Are there any guidelines for sizing a new Windows SQL Server VM in Azure so that it matches performance of the on-prem / bare-metal primary SQL server?
0
votes
1answer
33 views

Can I downscale/upscale my MySQL server automatically?

Is this doable? Since we know the peak times of our platform we are planning to downscale our DB after peak hours then upgrade the specs before the start of peak hours, how can we do this? Like how is ...
1
vote
1answer
1k views

Azure Virtual Machine - local temp storage (D: drive) - how much IOPS it can handle?

Virtual machine size DS3 (under older generation sizes) Azure Portal (when deploying VM) shows that DS3 supports up to 16 data disks / up to 12800 IOPS - thats fine, But what I am interested in is it'...
1
vote
2answers
99 views

SQL Procedure Cache getting wiped out every 60 seconds

I have an Azure VM running SQL 2017, deployed around August 2020. Not yet taking a production load. Several databases restored, but no users active yet. Running sp_Blitz I was getting this: "The ...
0
votes
1answer
16 views

Can we configure local and azure servers in a WSFC for Always On Availability Group? [closed]

Can we configure a local server and an azure server as a two node cluster for Always on Availability Group? Thanks!
1
vote
0answers
31 views

Choose Right Azure SQL [closed]

I'm new to Azure and now trying to migrate the On-premises SQL databases on azure. I have chosen VM SQL for migration because I just want to lift and shift architecture and need to restore backup file ...
0
votes
1answer
47 views

Migrate database to Azure

I have a 600GB database that I must transfer from an on-premises machine to an on Azure VM machine (IaaS) I would like to use the dbatools copy-database tool for this for this I will have to know what ...
0
votes
2answers
79 views

Backup Restore, CPU usage and Extended Events

I'm working on measuring the performance impact of Backups on CPU. I would like to capture all the backup operations and CPU usage. I'm running a weekly full backup, daily diff, and 15 min log backup. ...
1
vote
1answer
138 views

How to start Neo4j on Azure

I'm running Neo4j v4.x on an Azure VM (Linux Ubunto 16.04). Everything was running fine until my project required a resizing for more storage. This seemingly went well as I proceeded to load data, but ...
2
votes
2answers
351 views

SQL Server on azure virtual machines default instance

We have two ways of provisioning SQL Server on an Azure virtual machine, one is creating the VM and then upload the binaries of SQL server and do the installation manually, the second one is using SQL ...
0
votes
1answer
45 views

Windows Server 2019 non-owner node cannot see Cluster Name or IP

I am trying to build a SQL Server AlwaysOn Availability Group with 2 nodes in Azure. I have created 2 SQL Server VMs and Managed to create a Cluster with both Nodes as members of that cluster.  I ...
1
vote
1answer
146 views

SQL Fast database restore with Azure Virtual Machine instant recovery snapshot and SQL in Azure VM?

I have a large database. If I want to restore to a point in time using a full back up, it takes around 4 hours + time taken for transaction log restores. I also have VM image instant restore ...
2
votes
1answer
367 views

Is it possible to Increase storage performance in azure vm using disk striping?

Given the following Azure VM: E8s_v3 (8 cpu, 64 GB RAM, 12800 IOPS, 192 MBps) I added 2 SSD Premium drives, one for data (1024 GBs / 200 MBps / Host Caching enabled read-only) and one for Logs (256 ...
8
votes
1answer
441 views

Azure IaaS VM - Use D:\ Drive for tempdb - NTFS Formatting 64k

This was a question I was battling with earlier today and eventually figured out an answer. Wouldn't mind something better, but wanted to provide this to whomever also needed. First, on an Azure VM ...
0
votes
2answers
711 views

Database mail in Azure VM with SQL Server installed on it

We migrated 4 servers with SQL Server instances to Azure VM around 2-3 months ago. We configured "database mail" the same way we did for the on-prem servers. Mail worked fine immediately. All of a ...
2
votes
2answers
1k views

Is DB mail supported on SQL Server hosted on Azure VM (IaaS)?

Is DB mail present in SQL Server hosted on Azure VM (IaaS)? If DB mail is not supported, then what are the features available?
4
votes
1answer
505 views

Always On Primary Replica On Prem, Secondary Replica On Azure

We want to create an Always On Availability group where the primary replica will be On-premises and the secondary replica will be on an Azure VM. I have researched and I know it's possible to do this, ...
2
votes
2answers
209 views

Availability Group - Deleting old backup files

I'm using Azure VMs with a SQL Server Availability Group, and Ola Hallengren' scripts. Backups are working without issues, however I've noticed that old backup files are not being removed from the ...
2
votes
2answers
448 views

Azure blob storage container vs VM managed disk for SQL on Azure VM database files

Are there benefits specific to SQL Server on Azure VM when using the SQL Server Data Files in Windows Azure feature? Aka using Azure blob storage container for database files versus an Azure VM data ...
0
votes
0answers
28 views

Azure VM Security

With the move to Azure Cloud things are moving fast! I have a question based on Azure VM with a shared SQL Server containing multiple instances. For example if a Azure VM has 5 instances on there ...
0
votes
2answers
450 views

Background Index Creation on SQL Server

I have no maintenance plans yet I see indexes being created in the background (low spid). I have no idea what indexes are being created or why. Using Standard SQL Server 2017 - a VM on Azure with SQL ...
0
votes
1answer
3k views

Azure VM disk expansion online

Can we expand the disks in Azure VM without stopping the VM itself. (online) We are looking for an online method to expand the disk which we are not able to crack. We have certain apps moving to IAAS ...
0
votes
0answers
89 views

Performance difference between on-prem SQL Server and SQL Server running on Azure(IaaS)

We are comparing the performance of an on-prem SQL Server and SQL Server running on Azure VM. The Azure VM is created by Azure Site Recovery(ASR). For the testing purpose, we have executed following ...
2
votes
0answers
34 views

Multiple Location AlwaysOn and Azure SQL Server [closed]

AS with the majority of projects, the original scope may not be a viable option. We were using Azure Data Sync and transaction replication to keep the 4 site databases in sync. However, the customer ...
2
votes
1answer
129 views

What are the potential issues after data or log disk failure?

Scenario: A client recently had an issue with an Azure VM where the (non-OS) 'premium' storage disks were erroneous removed without warning by Microsoft. This is the virtual equivalent to the hard ...
4
votes
2answers
149 views

SQL Server CPU Issues

We've inherited some SQL server 2014 databases, they are running on Azure IaaS. We're getting complaints about performance and trying to get a grip on it. We're starting to look at CPU performance, ...
0
votes
1answer
286 views

Transaction Replication on Azure MI servers

I'm struggling to verify whether an Azure Managed Instance of SQL Server can both subscribe to Transactional Replication, and Publish, at the same time - I've been googling like a demon and ...
2
votes
0answers
189 views

Detecting disk throttling on Azure VM

Is it possible to monitor disk IO usage on an Azure VM or in SQL Management to detect whether disks are being throttled? How would you do it? Background: I'm looking for a way to raise an alert when ...
2
votes
2answers
1k views

Storage pool configuration for SQL Server

We are in the middle of building a new SQL Server 2017 always-on cluster in Azure VM. The data disk layout of VM are as follows TempDb : 2 Azure Disk Read Cache TempDBLog : 1 ...
0
votes
0answers
361 views

SQL listener connection fluctuates between primary and Secondary

We have SQL Server 2017 + CU11 Always On set up with one primary and a secondary replica. Suddenly we started facing issues where SQL Server AG listener connection started fluctuating between primary ...
1
vote
0answers
319 views

SQL Server in Azure VM + Azure AD + SSIS - how to authenticate?

Our configuration: Windows Server 2016 VM in Azure, running SQL Server (same as on-prem version) Azure Active Directory with users etc. Local Windows 10 PCs are joined to the AAD domain SQL Server ...
1
vote
0answers
144 views

CPU Power Saving Setting for Azure VM

I'm seeing from Perfmon that %C2 Time is being primarily used instead of %C1 Time in our Azure VM that is used for SQL Server. Normally if the host was on something like VMWare, I could get the Admins ...
1
vote
0answers
34 views

Can I remove some of our disk allocation?

I've started work for a new company who are using Azure for their SQL Databases. As one of my first tasks, they've asked me if they have too much storage (expensive storage), and would like to remove ...
2
votes
1answer
698 views

When trying to connect to an external postgres database using pgAdmin, I get an error [closed]

I get the following error when trying to connect: "FATAL: no pg_hba.conf entry for host "", user "postgres", database "postgres", SSL off" The db is installed on an Ubuntu machine in Azure. I have ...
1
vote
3answers
2k views

Azure PaaS Vs IaaS [closed]

I've be been tasked with deciding between iaas and paas for our upcoming product. I have gone through most of the documentation out there but unfortunately lacks any practical real-life experience ...
2
votes
1answer
727 views

Backup to Azure Blob Failing with Hallengren Framework

We are running IAAS VMs in Azure using SQL Server 2016 SP1 CU2. We are backing up to blob storage using a URL, and the errors received are shown below and described in the MS Connect URL provided. ...
1
vote
2answers
643 views

How to create shared folder between my on-premise Windows Server and Azure VM Server?

I'm trying to migrate my on-premise SQL Server to Azure VM using 'Microsoft Data Migration Assistant'. But it is asking for shared folder to be accessed by both source and target. How to achieve this?
0
votes
0answers
112 views

Near real time writable copy of production database

I have a production database (SQL server 2016) which is hosted on an Azure VM. We have set up a log shipping (every 15 mins) onto another Azure VM which is a read replica and would act as a DR system. ...