Unexpected failed login messages in AlwaysOn Availability Groups from SQL Server Agent.
Category: High Availability and Disaster Recovery
Parent category for all topics relating to High Availability and Disaster Recovery (HADR). SQL Server AlwaysOn Failover Clustered Instances, SQL Server AlwaysOn Availability Groups, Log Shipping, etc.
Distributed Transactions Suck!
How to recover out of orphan distributed transaction?
Changing @@SERVERNAME causes SQL Server Backups to Fail for AlwaysOn Availability Group
One of customers changed the value returned from @@SERVERNAME. SQL Server works no problem, however an unexpected behavior appeared. Changing the value for @@SERVERNAME, caused
SQL Server Failover Cluster, Agent Services Failed to come online, Error 435.
This was a troublesome error, because there is not much information available on what is going wrong. I looked the application log, SQL Agent Error
Missing registery settings in cluster nodes for SQL Server
I run into this occasionally, I think in last 3-4 years being SQL Server PFE, I have seen this issue total of 4 times. So
Slow disk write performance when you use a back-end SAN on a computer that is running Windows Server 2008 R2
Interesting fix was released today, your WRITE performance might be poor due to incorrect priority in DPC in Windows 2008 R2. If you have write