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
1 answer
75 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,541
0 votes
2 answers
59 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
1 vote
2 answers
74 views

When can we downsize Azure Virtual machine for SQL Server?

For now our production SQL Server is Standard_D96ds_v5 Azure VM machine. We got request to check if we can downsize server to Standard_D48ds_v5. What measures will take into consideration to have ...
adam.g's user avatar
  • 335
0 votes
0 answers
36 views

How to use the same Azure SQL VM in two different Load Balancers

I have already configured always on availability group between VM1 and VM2 azure machines. Internal Load Balancer was created for these two VMs and mapped to AG Listener. VM2 is used for read workload ...
Rauf Asadov's user avatar
  • 1,253
1 vote
1 answer
277 views

Combination of multiple instances and AG listeners - connecting to AG listener sends me to different instance

The environment in question consists of AD domain and 2 AZ SQL VMs. The SQL server version is SQL 2022 Standard - CU 2. There are currently three DB instances on each AZ SQL VM and databases in those ...
Sranda's user avatar
  • 350
1 vote
1 answer
86 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
0 votes
0 answers
150 views

Trying to increase disk with GPT for SQL Server data, do we need to configure anything to SQL Server Application

I am not a DBA, but SQL Developer. Our company has a Azure VM that has a very active SQL Server 2008. Currently, a disk drive (H:\ drive) that holds SQL data is getting full (up to 2 TB, possibly due ...
Java's user avatar
  • 223
0 votes
1 answer
275 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
619 views

Invoke-AzVMRunCommand on Azure VM using domain user

I am working on ARM template to setup SQL server VM on Azure with Always on High availibility setup using Win server 2019 and SQL Server 2019 Enterprise image. I am trying to automate everything using ...
user avatar
0 votes
0 answers
54 views

Configuring SQL Server database transaction logs truncation regularly? [duplicate]

How can I configure SQL Server 2014, to allow truncating the logs by itself so that it doesn't fill up my database drive? I need some help as I'm not a DBA myself and this SQL Server is installed ...
Senior Systems Engineer's user avatar
1 vote
0 answers
254 views

Sql profiler - result in profiler : "Audit Login" and immediately after "Audit Logout" without running the query

I have a service running on an Azure kubernetes (AKS) that is connecting to a DB running on a Virtual Machine (VM) on Azure. There is a failure to run the service. The result of SQL Profiler is: ...
dexon's user avatar
  • 47
0 votes
0 answers
92 views

BACKUP LOG failed to write to Azure Blob

We have a SQL VM running out of Azure with SQL Agent jobs running BACKUP LOG every x hours to Azure Blob. These jobs have been running fine for a long time until recently. We keep getting the below ...
sydney's user avatar
  • 157
0 votes
1 answer
47 views

Azure VM disk per drive SQL server

On an Azure VM, does it matter if I partition a large disk into multiple drives (to hopefully be more contiguous - not sure if it'd matter virtually) where if space is needed, it'd then need to be a ...
Nicholas McQuillen's user avatar
1 vote
1 answer
60 views

Azure infrastructure (cost optimisation) and optimal disk throughput: azure storage size / speed / cost / optimisation

with reference to: Azure Managed Disks SQL Server 2019; Windows 2016 C: OS maps to 128 GB (S10 @ 60mb/sec). So far so good. I have drives for Data, Index, TempDB, Log and Local Backups. Data, Index, ...
Alocyte's user avatar
  • 422
3 votes
0 answers
71 views

Monitor tempdb iops on Azure VM

I've inherited SQL on Azure VMs where not all the tempdb files are on the ephemeral D: drive. I'd like to move them back there as that is the MS recommended location for latency reasons. However, ...
Simon's user avatar
  • 31
0 votes
0 answers
237 views

Azure VM with alwayson AGs - expand data disk

I have a three nodes SQL Server Alwayson cluster on Azure VM. I need to expand the data disk on all three nodes. The disk is a stripe disk build during VM configuration. Based on this: https://learn....
MBuschi's user avatar
  • 4,440
2 votes
0 answers
517 views

How to create logins in sql server based on the Azure Active Directory?

In my Azure environment I have many resources, and I have a virtual machine that contains my sql server database This is my virtual machine: What I would like to achieve is to create logins inside my ...
Marcello Miorelli's user avatar
2 votes
2 answers
214 views

SQL Server Azure VM with 512e SSD Storage - Error 9012

I have been given a SQL Server Azure VM that has 512e storage attached for data and log files, according to fsutil fsinfo ntfsinfo [drive letter]:\. It is a DR replication node from an on-premises ...
Dina's user avatar
  • 1,487
4 votes
1 answer
469 views

Why significantly worse Column Store performance on Read-only AG secondary DB?

We have a pair of SQL 2019 Enterprise instances hosted in identically spec'd and configured VMs in Azure. They for a simple primary/secondary availability group array, containing a small number of ...
Mark's user avatar
  • 879
0 votes
1 answer
118 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 ...
Richard101's user avatar
1 vote
0 answers
237 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 ...
UBK's user avatar
  • 111
4 votes
1 answer
885 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. ...
SimonB's user avatar
  • 51
1 vote
1 answer
1k 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 ...
Oana Marina's user avatar
1 vote
0 answers
33 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 ...
Crogacht's user avatar
0 votes
1 answer
60 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 ...
DMDM's user avatar
  • 1,738
1 vote
2 answers
430 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 ...
Andres Arango's user avatar
0 votes
0 answers
3k 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 ...
YusufD's user avatar
  • 1
0 votes
1 answer
265 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 ...
variable's user avatar
  • 3,541
0 votes
0 answers
16 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 ...
Asher's user avatar
  • 303
1 vote
2 answers
123 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?
user2368632's user avatar
  • 1,087
0 votes
1 answer
115 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 ...
JRA's user avatar
  • 139
1 vote
1 answer
2k 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'...
Aleksey Vitsko's user avatar
1 vote
2 answers
137 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 ...
Todd Chittenden's user avatar
0 votes
1 answer
18 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!
Sree Lekha's user avatar
1 vote
0 answers
42 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 ...
Mahendra Nikam's user avatar
0 votes
1 answer
64 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 ...
Abdallah Mehdoini's user avatar
0 votes
2 answers
271 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. ...
Im88's user avatar
  • 326
1 vote
1 answer
283 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 ...
David A Stumpf's user avatar
2 votes
2 answers
1k 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 ...
Andres Arango's user avatar
0 votes
1 answer
286 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 ...
M.Ali's user avatar
  • 1,950
1 vote
1 answer
287 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 ...
Prashanth Subramanian's user avatar
2 votes
1 answer
584 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 ...
Victor Barajas's user avatar
9 votes
1 answer
1k 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 ...
Nicholas McQuillen's user avatar
0 votes
2 answers
1k 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 ...
Victor Barajas's user avatar
2 votes
2 answers
2k 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?
sachin-SQLServernewbiee's user avatar
4 votes
1 answer
816 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, ...
Victor Barajas's user avatar
2 votes
2 answers
448 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 ...
Tom.Wheater's user avatar
2 votes
2 answers
679 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 ...
JohnC's user avatar
  • 133
0 votes
0 answers
33 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 ...
Vishal's user avatar
  • 15
0 votes
2 answers
1k 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 ...
Scott E's user avatar
  • 11