Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit 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.

0
votes
1answer
16 views

Transaction Replication on Azure MI servers

I'm struggling to verify whether an Azure Managed Instance of SQL Server can both subscribe to Transactional Replication, and Publish, at the same time - I've been googling like a demon and ...
1
vote
0answers
10 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 ...
0
votes
0answers
18 views

Disk recovery for Azure VM to host SQL Server

As per the Azure VM Creation of the storage pool best practice document, Simple Recovery option is what Microsoft recommend. For recovery purpose shouldn't this be at least Mirror. What is ...
2
votes
2answers
35 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 ...
0
votes
0answers
69 views

SQL listener connection fluctuates between primary and Secondary

We have SQL Server 2017 + CU11 Always On set up with one primary and a secondary replica. Suddenly we started facing issues where SQL Server AG listener connection started fluctuating between primary ...
1
vote
0answers
21 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 ...
0
votes
0answers
8 views

Azure Site recovery with Site to Site VPN having DNS service

i wanted to understand how the Azure site recovery service will work with disaster recovery where the DR site is connected over a site-site VPN and the DNS Name is bound to one of the primary server. ...
1
vote
0answers
32 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
28 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 ...
2
votes
1answer
148 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 ...
0
votes
0answers
152 views

Linked Server from SQL Server on Azure VM to On-premise Oracle Database

How to create a Linked Server from my SQL Server on Azure VM IaaS to an Oracle Database which is present on On-premise? Is it the same process as we create on on-premise SQL Server or what extra ...
1
vote
3answers
657 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 ...
0
votes
0answers
22 views

Azure premium storage on Dsv3 VM

I am new to Azure VM's and I am going through General purpose virtual machine sizes. In there under "Dsv3-series" it says we can use Premium storage. But if I go through the premium storage page, it ...
1
vote
1answer
329 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. ...
1
vote
2answers
258 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?
0
votes
0answers
50 views

Near real time writable copy of production database

I have a production database (SQL server 2016) which is hosted on an Azure VM. We have set up a log shipping (every 15 mins) onto another Azure VM which is a read replica and would act as a DR system. ...
4
votes
1answer
485 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 ...
0
votes
1answer
171 views

Single Domain Controller for SQL Server Always On Availability Group

I was wondering if SQL Server Always On Availability Group supports a single Domain Controller server as opposed to 2 Domain Controllers in every example I've seen. I ask because I suspect that this ...
0
votes
0answers
379 views

Adding Azure VM as 3rd node to the 2-node On-Premise Windows Server Failover Cluster - Problem

We have 2-node WSFC, which is hosted on-premise in our datacenter This WSFC is running one clustered role which is SQL Server Availability Group Node-1: Windows Server 2016 - two subnets - 192.168.7....
19
votes
4answers
871 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 (...
39
votes
6answers
7k 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 ...
1
vote
1answer
2k 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
816 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. ...
0
votes
1answer
441 views

Set-ClusterParameter : Parameter 'OverrideAddressMatch' does not exist on the cluster object while configuring failover cluster resources

I configured an availability group in Azure using this guide. I have 2 failover cluster nodes with SQL Server 2016. User 'Install' has administrative permissions on both machines and sql server ...
3
votes
2answers
2k 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.
1
vote
2answers
180 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 ...
2
votes
0answers
186 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:...
3
votes
1answer
106 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 ...
0
votes
1answer
236 views

Connecting Remote Shares via Powershell

I had a big problem which I just happened to solve, but it's a permissions issue I don't quite understand. Unfortunately I'm in a tight bind and no amount of googling in the past week has really ...
1
vote
2answers
733 views

Reclaim Transaction Log space of SQL Server

I have a SQL Server databases for which log files have grown huge. I have log backup scheduled to run only once a day. But now all the disk space is used by these log files. Can anyone help me ...
1
vote
0answers
365 views

How to restore SQL Server database from Azure Blob?

I created a database (IaaS) from Azure marketplace (Windows server 2012 + SQL Server Web 2014). I Selected automatic backups to blob storage. Now I'm trying to do a test restore operation. I imported ...
3
votes
2answers
1k 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, ...
1
vote
1answer
61 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 ...
4
votes
1answer
4k 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 ...
1
vote
2answers
741 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
0answers
851 views

FILESTREAM shared folder can not be accessed using listener name

I have AlwaysOn configured in SQL Server 2014 and enabled Filestream in both nodes (node 1 and node2) as shown here: Enable and Configure FILESTREAM (MSDN Library) I have named the shared folder ...
1
vote
1answer
3k views

What is difference between internal and external load balancer listener with respect to azure (IaaS)

As per below MSDN blog, I see there are 2 ways we can create load balancer listener . https://azure.microsoft.com/en-gb/documentation/articles/virtual-machines-windows-classic-ps-sql-int-listener/ ...
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 ...
0
votes
1answer
202 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 ...
0
votes
0answers
26 views

Load DATAINFILE extremely slow

I am using the code below to insert a 2.2MB file into a MySQL database in the cloud using Azure (the free version) with 36 thousand rows and 8 columns of doubles. MySqlCommand sqlCmd = new ...
1
vote
1answer
6k 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
421 views

Transaction Log file size is increasing in my Azure (IAAS) SQL Server 2014 database [duplicate]

Recently we have migrated our application (both web app and database) to Azure (IASS). There we have a VM with SQL Server 2014 installed. Also I have restored all the necessary databases and SQL ...
3
votes
2answers
3k 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 ...
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
137 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 ...
2
votes
2answers
94 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
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 ...
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 ...
2
votes
1answer
211 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 ...
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 ...