A message from our CEO about the future of Stack Overflow and Stack Exchange. Read now.

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
1answer
7k views

Shared network location in Availability Groups configuration

I am configuring Availability Groups feature in azure virtual machines nodes. In the below screen wizard, it's asking me for shared location. where and how I need to create this shared location? Do I ...
43
votes
6answers
8k views

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 ...
20
votes
4answers
910 views

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 (...
2
votes
2answers
5k views

Cannot remotely connect to SQL Server 2012 VM on Azure

I have a SQL Server 2012 instance running on a virtual machine in Azure. I have tried to connect to it using the public virtual IP address; however, I get an error saying: The server was not found ...
0
votes
2answers
138 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
395 views

Primary server 'XYZ' can not write to shared drive during availability group configuration

I am in a process of adding databases to availability group. In one of the steps it was asking "data synchronization prefferences" as shown below I have put the mapped drive location path, which was ...