Skip to main content

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
1 vote
1 answer
44 views

Running into MSSQLSERVER_701 "insufficient memory in the resource pool to run the SQL queries" when Azure SQL backup runs

We have a VM that was on-prem, but we recently moved it into Azure. The VM hosts a SQL Server instance with a few databases on it. After setting up a schedule of SQL database backups through Azure, we'...
j. kiel's user avatar
  • 21
-2 votes
0 answers
28 views

What is the meaning of distributed server in wsfc cluster manager (Azure VM FCI)?

On a SQL server FCI on Azure VM, when I open the wsfc failover cluster manager, then under cluster properties, I cannot see the IP address of the cluster. Also, when I click on the cluster, below the ...
variable's user avatar
  • 3,476
0 votes
0 answers
40 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 ...
juFo's user avatar
  • 299
0 votes
1 answer
46 views

Does Azure automated backup for SQL database on Azure VM have way to detect log chain?

I have SQL server on Azure VM. If I enable Azure automated backups for the SQL server on Azure VM to backup the dbs (full/diff/log), and suppose if an admin performs a manual log backup (which ...
variable's user avatar
  • 3,476
0 votes
1 answer
24 views

For Azure VM SQL log shipping, What is the reason for requiring storage account to be in the same resource group as SQL VM? Any workaround?

https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/log-shipping-configure?view=azuresql The prerequisite for log shipping in Azure VM based SQL servers is: At least two domain-...
variable's user avatar
  • 3,476
0 votes
0 answers
13 views

error when running OPENROWSET query - what to do with the FORMATFILE_DATA_SOURCE

I want to run a query from Sql server to Blob Storage all in the same Azure Tenant. my environment : SQL SERVER 2022 (running on a azure virtual machine) Blob storage. I've ran this scripts (some ...
dexon's user avatar
  • 47
0 votes
0 answers
64 views

Entra ID auth to Azure SQL VM intermittently fails

We have a number of Azure VMs running SQL server 2022 in our organization. We create these VMs from a marketplace image that comes with SQL preinstalled. We then go through the configuration steps ...
TommiWan's user avatar
1 vote
1 answer
160 views

SQL Server - Log Shipping to Azure VM

I'm looking for some advice regarding Log Shipping from SQL Server 2016 On-Premises to SQL Server 2016 on an Azure VM. From my existing knowledge and research, there are a few ways of going about this....
FrugalShaun's user avatar
0 votes
1 answer
125 views

What are recommended values for block size, buffercount and maxtransfer size for Ola backups to Azure?

I have SQL servers running on onprem and Azure VM hardware. The backups write to a file share located on a network VM. I am wanting to change the backup destination to Azure blob storage. For this I ...
variable's user avatar
  • 3,476
0 votes
1 answer
175 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,476
0 votes
2 answers
95 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
85 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
  • 355
1 vote
1 answer
465 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
  • 360
1 vote
1 answer
130 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
183 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
  • 233
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
700 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
276 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
107 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
53 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 ...
QuilleyPowers's user avatar
1 vote
1 answer
61 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
  • 420
3 votes
0 answers
79 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
301 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,615
2 votes
0 answers
618 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
242 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,507
4 votes
1 answer
501 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
  • 899
0 votes
1 answer
140 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
262 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
1k 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
34 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
63 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,750
1 vote
2 answers
471 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
276 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,476
0 votes
0 answers
17 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
132 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,097
0 votes
1 answer
126 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
  • 149
1 vote
1 answer
3k 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
142 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
70 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
290 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
289 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
3 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
354 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,970
1 vote
1 answer
314 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
614 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