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.
107
questions
1
vote
1
answer
50
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 ...
- 152
1
vote
1
answer
50
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 ...
0
votes
0
answers
108
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 ...
- 213
0
votes
1
answer
139
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 ...
- 1
0
votes
1
answer
430
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 ...
Nirav B
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 ...
1
vote
0
answers
156
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:
...
- 11
0
votes
0
answers
59
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 ...
- 147
0
votes
1
answer
28
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 ...
1
vote
1
answer
56
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, ...
- 333
3
votes
0
answers
51
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, ...
- 31
0
votes
0
answers
130
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....
- 4,045
2
votes
0
answers
215
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 ...
- 15.6k
2
votes
2
answers
164
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 ...
- 1,447
4
votes
1
answer
364
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 ...
- 869
0
votes
1
answer
93
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 ...
- 15
1
vote
0
answers
185
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 ...
- 111
4
votes
1
answer
572
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. ...
- 51
1
vote
1
answer
731
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 ...
- 111
1
vote
0
answers
26
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 ...
- 11
0
votes
1
answer
55
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 ...
- 1,728
1
vote
2
answers
283
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 ...
- 175
0
votes
0
answers
2k
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 ...
- 1
0
votes
1
answer
216
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 ...
- 3,225
0
votes
0
answers
14
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 ...
- 283
1
vote
2
answers
95
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?
- 1,066
0
votes
1
answer
88
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 ...
- 109
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'...
- 5,182
1
vote
2
answers
129
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
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!
- 15
1
vote
0
answers
40
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
1
answer
57
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
2
answers
179
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. ...
- 326
1
vote
1
answer
215
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 ...
- 111
2
votes
2
answers
883
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 ...
- 175
0
votes
1
answer
130
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,910
1
vote
1
answer
214
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
1
answer
505
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 ...
- 363
9
votes
1
answer
836
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
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 ...
- 363
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?
4
votes
1
answer
639
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, ...
- 363
2
votes
2
answers
357
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 ...
- 163
2
votes
2
answers
601
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 ...
- 133
0
votes
0
answers
32
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 ...
- 15
0
votes
2
answers
789
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 ...
- 11
0
votes
1
answer
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 ...
- 2,258
0
votes
0
answers
114
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 ...
- 8,554
2
votes
0
answers
38
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 ...
- 21
2
votes
1
answer
154
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 ...
- 145