azure-vm Archives

PREEMPTIVE_OS_WRITEFILEGATHER wait on database RESTORE with IFI on

By adminPosted on September 14, 2022

Question : I have an Azure VM with Windows Server 2012 R2 and SQL Server 2014 Enterprise Edition. I have […]

By adminPosted on August 9, 2022

Question : This question already has answers here: Why Does the Transaction Log Keep Growing or Run Out of Space? […]

By adminPosted on July 25, 2022

Question : I have a virtual machine running SQL Server 2012 in Azure and have also generated a script of […]

By adminPosted on July 21, 2022

Question : Is there anyway to change a column data type so that it will accept only negative values? It’s […]

By adminPosted on June 15, 2022

Question : I have two SQL Server 2016 VMs in Azure. I am trying to connect these two sql server […]

By adminPosted on May 24, 2022

Question : Is this doable? Since we know the peak times of our platform we are planning to downscale our […]

By adminPosted on May 3, 2022

Question : Are there benefits specific to SQL Server on Azure VM when using the SQL Server Data Files in […]

By adminPosted on April 21, 2022

Question : I’m working on measuring the performance impact of Backups on CPU. I would like to capture all the […]

By adminPosted on April 19, 2022

Question : We want to create an Always On Availability group where the primary replica will be On-premises and the […]

By adminPosted on April 12, 2022

Question : I have an Azure VM running SQL 2017, deployed around August 2020. Not yet taking a production load. […]