Database Administrators Stack Exchange
Database Administrators Stack Exchange

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.

Microsoft Azure cloud-based hosting for Virtual Machines.

More information

119 questions
47
votes
6 answers

Is there any limit to the number of databases you can put on one SQL server?

I'm setting up a SaaS system, where we're planning to give each customer their own database. The system is already set up so that we can easily scale out to additional servers if the load becomes too great; we're hoping to have thousands, or even…
Shaul Behr
  • 2,963
  • 8
  • 34
  • 42
21
votes
4 answers

Advice on diagnosing a "sometimes" slow query

I have a stored procedure which returns results from an indexed view via a covering index. Usually, it runs fast (~10ms), sometimes it can run up to 8 seconds. Here's an example random execution (note: this isn't a slow one, but the query text is…
RPM1984
  • 435
  • 3
  • 10
10
votes
1 answer

Why is my Azure SQL Server so slow?

We currently have a VM that is very underpowered and are proposing to move to an Azure VM with better specs. The problem is, the Azure VM is much slower than the original VM even though it is of a higher spec. The original server is a 2 core VM…
Steve Kaye
  • 201
  • 2
  • 5
9
votes
1 answer

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 you get a D:\ drive for free which is SSD. The…
QuilleyPowers
  • 142
  • 1
  • 9
8
votes
2 answers

SQL Server Transaction Logs in the Cloud

It is a common practice to place the transaction logs (*.ldf) on a separate physical disk system than database files (*.mdf, *.ndf). In a virtual machine cloud environment, is it okay to put the transaction logs on the same drive letter as the other…
Jason Kresowaty
  • 231
  • 1
  • 8
6
votes
1 answer

Azure: Many Failed Login Attempts Logged

I run a SQL Server on an Azure Virtual Machine. I have noticed in the Event Logs of the server lots of failed SQL Login attempts using a ton of different usernames (none of which exist): Login failed for user 'kisadminnew1'. Reason: Could not find…
user73880
5
votes
2 answers

Change default collation when provisioning a SQL Server VM in the Azure portal

Is there a way to change the default SQL collation directly from the "Create virtual machine" wizard in Azure ? The SQL VM images from the gallery are set for SQL_Latin1_General_CP1_CI_AS. Browsing through the wizard's SQL Server settings, there's…
Razvan Zoitanu
  • 1,004
  • 4
  • 18
  • 31
5
votes
2 answers

PREEMPTIVE_OS_WRITEFILEGATHER wait on database RESTORE with IFI on

I have an Azure VM with Windows Server 2012 R2 and SQL Server 2014 Enterprise Edition. I have enabled IFI (added SQL Server user NTSERVICE\MSSQLSERVER to "Perform Volume Maintenance Tasks"). I have tried to restore a 3 GB database with files on C…
Horia
  • 183
  • 1
  • 9
4
votes
1 answer

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 databases across a small number of AGs. The single…
Mark
  • 941
  • 1
  • 8
  • 20
4
votes
1 answer

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. The VM is only used for the SQL DBs and storing…
SimonB
  • 51
  • 5
4
votes
1 answer

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, but in all the examples I find, they always have…
Victor Barajas
  • 363
  • 2
  • 12
4
votes
2 answers

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, and run the following test (all tests are running…
Patrick
  • 256
  • 1
  • 6
4
votes
2 answers

Set column to only accept negative values

Is there anyway to change a column data type so that it will accept only negative values? It's SQL Server 2014 Azure.
Easy987us
  • 83
  • 1
  • 2
  • 5
3
votes
0 answers

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, before doing so I want to see the current IOPS and…
Simon
  • 31
  • 2
3
votes
2 answers

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 Server on Azure virtual machines which provides…
Andres Arango
  • 195
  • 2
  • 9
1
2 3 4 5 6 7 8