azure-vm Archives

Advice on diagnosing a “sometimes” slow query

By adminPosted on September 25, 2023

Question : I have a stored procedure which returns results from an indexed view via a covering index. Usually, it […]

By adminPosted on September 9, 2023

Question : We currently have a VM that is very underpowered and are proposing to move to an Azure VM […]

By adminPosted on August 24, 2023

Question : I have a customer who has just lifted-n-shifted their 1TB SQL Server 2008 R2 production, and QA servers […]

By adminPosted on August 14, 2023

Question : I have Microsoft SQL Server 2014 on an Azure VM (Windows Server 2012 R2) with one database. Is […]

By adminPosted on July 1, 2023

Question : I am not sure if this questions belongs here or in server fault, apologies if it belongs there. […]

By adminPosted on March 8, 2023

Question : One of the clients at my workplace asked me to find out information on what would be the […]

By adminPosted on February 27, 2023

Question : Given the following Azure VM: E8s_v3 (8 cpu, 64 GB RAM, 12800 IOPS, 192 MBps) I added 2 […]

By adminPosted on February 24, 2023

Question : We have a newly created Azure SQL Server 2014 instance. The specs for the server are as follows […]

By adminPosted on December 20, 2022

Question : We are working on setting up AlwaysOn Availability Group for SQL Server 2014. There will be 2 nodes: […]

By adminPosted on December 11, 2022

Question : Is there a way to change the default SQL collation directly from the “Create virtual machine” wizard in […]