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
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 (...
10
votes
1answer
8k views

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 ...
8
votes
2answers
1k views

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 ...
6
votes
1answer
2k views

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

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 ...
4
votes
1answer
132 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, ...
4
votes
2answers
4k views

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

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.
3
votes
2answers
122 views

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, ...
3
votes
2answers
2k views

Connecting to MySQL VM remotely (Azure Resource Manager)

I have a VM setup in Azure (running Windows Server 2012 R2) with MySQL 5.7 installed. I am trying to access this using MySQL Workbench - which when running on the server works perfectly. However, ...
3
votes
0answers
75 views

Compress backup taken from two different environments take different time to restore

I have two backup files one from Normal SQL Server and one from SQL Server from Azure VM. The restore of these backup files is totally different from each other. Though the database backups are ...
3
votes
1answer
46 views

SQL Server 2012 Explicit transactions taking time with Always on Setup

We have a weird issue while we setup the AlwaysOn on Azure VM. We have explicit transactions in our stored procedures, and which are causing some delays and blocking when till the time we get the ...
2
votes
2answers
102 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?
2
votes
1answer
5k views

Backup SQL Server to Google Drive

I have Microsoft SQL Server 2014 on an Azure VM (Windows Server 2012 R2) with one database. Is it possible to configure an automatic backup to my Google Drive folder? Maybe a special tool or ...
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 ...
2
votes
2answers
72 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 ...
2
votes
2answers
382 views

Storage pool configuration for SQL Server

We are in the middle of building a new SQL Server 2017 always-on cluster in Azure VM. The data disk layout of VM are as follows TempDb : 2 Azure Disk Read Cache TempDBLog : 1 ...
2
votes
1answer
1k views

Can we move SQL Server installed bit from default location to other drive

My client gave me command line installer for SQL Server. Since it is command line there is no option to select the installation path! So installer automatically chooses the default location C:\Program ...
2
votes
2answers
166 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 ...
2
votes
1answer
63 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 ...
2
votes
1answer
481 views

Backup to Azure Blob Failing with Hallengren Framework

We are running IAAS VMs in Azure using SQL Server 2016 SP1 CU2. We are backing up to blob storage using a URL, and the errors received are shown below and described in the MS Connect URL provided. ...
2
votes
2answers
96 views

Moving database from one server to another

I have a virtual machine running SQL Server 2012 in Azure and have also generated a script of my database to be run on the SQLSERVER2012 VM on Azure, however I am getting an error "C:\Program ...
2
votes
1answer
1k views

What is limiting the batch requests per sec

We have a newly created Azure SQL Server 2014 instance. The specs for the server are as follows Pretty bare bones, I know. Since this is just a testing server, we have opted to set up the data files ...
2
votes
1answer
983 views

Does installing SQL Server Database Engine and Reporting Services in Azure require two virtual machines?

We are evaluating moving a large-ish web application comprising ASP.NET, Classic ASP and SQL Server Reporting Services into Azure, and we want to know the "best practice" for installing the Database ...
2
votes
0answers
26 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 ...
2
votes
0answers
273 views

SQL Server Backup/Restore IO performance on Azure VM

We are currently experiencing an issue where the IO performance of our SQL Server running on an Azure VM isn't quite up to snuff. We are running a Azure VM (Standard DS2). This one has a 127 GB SSD C:...
2
votes
1answer
153 views

How to deal with seldom used big database and postgresql?

I loaded in PostgreSQL (9.3) OpenStreetMap data for whole europe (400gb). Then I installed a geocoding api (nominatim) that queries the database with gis queries. My problem is : This database is ...
2
votes
1answer
222 views

Does SQLBackup2Azure delete the blobs as well?

I am not sure if this questions belongs here or in server fault, apologies if it belongs there. I am using MS SQL 2012 on an azure VM, and am planning on utilizing the SQLbackup2Azure tool to store ...
2
votes
0answers
754 views

Sql Server 2012 Disk I/O Too high

I am running SQL Server 2012 on windows azure VM Windows server 2012. This is a live Database, about 250GB, with high usage. I applied some best practice articles for the temp-db long ago, and also ...
2
votes
0answers
740 views

How to use Blob Storage as shared storage in a Windows Azure Failover Cluster?

In the context of SQL Server 2012 Standard Edition, is it possible to make Azure Blob storage available to a SQL Failover cluster directly as a shared SCSI resource on a Windows Cluster composed on VM'...
1
vote
1answer
3k views

Sql Server 2016 errror Incorrect syntax near 'EXTERNAL'

I have two SQL Server 2016 VMs in Azure. I am trying to connect these two sql server instances using External datasource. I can safely connect the two instances from my local pc, remotely. While ...
1
vote
1answer
152 views

Do I need a separate server for Quorum?

We are working on setting up AlwaysOn Availability Group for SQL Server 2014. There will be 2 nodes: Primary Replica and Secondary Replica. The question is, do we need a separate server for Quorum? ...
1
vote
1answer
1k views

Unable to access SSRS web URL outside Azure VM

I've configured SSRS in SQL Server 2016 on Azure VM. However I am unable to access the web URL outside of the VM. Since it is my test box I've tried disabling the firewall as well. Still didn't help. ...
1
vote
2answers
919 views

Can I access the file stream shared folder using Listeners in case of AlwaysOn cluster environment?

One of the most effective ways to extend your SQL Server Integration Services (SSIS) control flow is to use a Script task to write custom code that perform tasks you cannot perform with the built-in ...
1
vote
1answer
1k views

Azure TempDB and Log files

I'm setting up an Azure D11 SQL Server to be used for a data warehouse. I can only attach 4 data disks and have done so, now I need to determine how to configure them and split the DB files. I'm ...
1
vote
1answer
141 views

Is my mssql 2008 standard suitable for web edition 2014

A web edition seems enough for me when I read this. I thought it had a 2gb size limit before? I have three databases our current db and am not doing anything fancy. Just some server agent jobs from ...
1
vote
1answer
62 views

Should I update to sql server 2008 sp2 before restoring the db's or do the update after?

I'm making a move from SQL Server 2008 to SQL Server 2008 R2 (Azure VM) as part of a hosting provider switch (from MyHosting to Azure). Should I update the VM to R2 SP2 before restoring the db's or do ...
1
vote
2answers
457 views

How to create shared folder between my on-premise Windows Server and Azure VM Server?

I'm trying to migrate my on-premise SQL Server to Azure VM using 'Microsoft Data Migration Assistant'. But it is asking for shared folder to be accessed by both source and target. How to achieve this?
1
vote
1answer
67 views

Accessing file share from ETL package in SQL Always-On configuration

How can I access the file share from ETL? Here are my environment details: I have 2 nodes in a windows cluster. node 01 and node 02 SQL Server 2014 is installed on both the nodes. Both are Windows ...
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 ...
1
vote
1answer
825 views

SQL Server VM in Azure with In Memory

I am running azure and considering deploying a SQL Server 2014 instance due to the in memory feature, however, I was looking through the documentation and couldn't seem to find how to configure In-...
1
vote
2answers
2k views

SQL Server storage limits on Azure

Looking at SQL Server maximum capacity limits on here: http://msdn.microsoft.com/en-us/library/ms143432(v=sql.120).aspx Database size can be as big as 524,272 terabytes. Here, you could see VM size ...
1
vote
0answers
78 views

Detecting disk throttling on Azure VM

Is it possible to monitor disk IO usage on an Azure VM or in SQL Management to detect whether disks are being throttled? How would you do it? Background: I'm looking for a way to raise an alert when ...
1
vote
0answers
163 views

SQL Server in Azure VM + Azure AD + SSIS - how to authenticate?

Our configuration: Windows Server 2016 VM in Azure, running SQL Server (same as on-prem version) Azure Active Directory with users etc. Local Windows 10 PCs are joined to the AAD domain SQL Server ...
1
vote
0answers
54 views

CPU Power Saving Setting for Azure VM

I'm seeing from Perfmon that %C2 Time is being primarily used instead of %C1 Time in our Azure VM that is used for SQL Server. Normally if the host was on something like VMWare, I could get the Admins ...
1
vote
0answers
29 views

Can I remove some of our disk allocation?

I've started work for a new company who are using Azure for their SQL Databases. As one of my first tasks, they've asked me if they have too much storage (expensive storage), and would like to remove ...
1
vote
1answer
345 views

When trying to connect to an external postgres database using pgAdmin, I get an error

I get the following error when trying to connect: "FATAL: no pg_hba.conf entry for host "", user "postgres", database "postgres", SSL off" The db is installed on an Ubuntu machine in Azure. I have ...
1
vote
3answers
2k views

Azure PaaS Vs IaaS [closed]

I've be been tasked with deciding between iaas and paas for our upcoming product. I have gone through most of the documentation out there but unfortunately lacks any practical real-life experience ...
1
vote
2answers
208 views

Backing up databases on SQL Server hosted in Windows Azure VM

One of the clients at my workplace asked me to find out information on what would be the best possible or recommended approach to run maintenance jobs such as backup job for a SQL Server 2016 hosted ...