Many customers get a slower SQL Server after moving to Azure. Should you pick Standard or Premium Disks? My short answer is Premium, and here is why.
Migrate SQL Server Cluster Storage to New Disks
To migrate cluster storage for a SQL Server failover cluster, add the new disks to the SQL Server role, take the instance offline, copy the files with their permissions, give the new disks the old drive letters and bring the instance back. This post lists every step, the checks to run first, the quorum and MSDTC disks, and the T-SQL alternative that changes file paths.
SQL SERVER – Always On Availability Group Failover Generating Dump. Error: 17066: SQL Server Assertion: HadrFstrVnnUtils.cpp:479
A client’s availability group failover across subnets got stuck in Resolving and generated dumps with Error 17066. Here is what we found and how we fixed it.
SQL SERVER – Too Many SQLDump Files Consuming a Lot of Disk Space. What Should You Do?
SQLDump files are SQL Server’s stress signal, and a client had so many they filled the disk. Here is what causes them and what you should do about it.
SQL SERVER – Errors When Disk Space is the Reason
When disk space runs out, SQL Server logs errors like 1101 and 1105, often during recovery. A roundup of the common messages and what each one tells you.
SQL SERVER – Backup Randomly Failing with Error 112 (There is not enough space on the disk.)
Solving puzzle is something everyone would love. IHere is the puzzle which they wanted me to solve for Error 112.
SQL SERVER – Identify Disk Latency on SQL Server Box Using PowerShell
Disks are often behind a slow server, and the problem can be hard to spot. Here is a PowerShell script to identify Disk Latency on your SQL Server box.