During Comprehensive Database Performance Health Check, I have recently a very interesting experience with an Azure. In this blog post, we will discuss which disks are preferred for performance – Standard Disks or Premium Disks. Well, honestly my answer here is very simple Premium Disks. If you stop reading this blog post over here, I am totally fine as well.
SQL SERVER – Always On Availability Group Failover Generating Dump. Error: 17066: SQL Server Assertion: HadrFstrVnnUtils.cpp:479
One of my clients was using Always On availability group. They were having 3 nodes Always On AG setup. For simplicity, let’s call them Node1, Node2 and Node3. The first two nodes were in one subnet and node3 was in separate subnet. Let us learn about availability group failover.
Couple of week back, I was playing around with using Powershell for some simple activities. The fall out of that was the ability to search the SQL Server Error Logs. Though we can search for anything, I just showed you a case of usage. In this blog post, I will talk about one of the most sought after request for searching what the disk latencies are. Let us see a powershell script for for Identify Disk Latency on SQL Server Box.
A very common question I often receive is how to detect if the disk space is running low on SQL Server.