Unexpected failed login messages in AlwaysOn Availability Groups from SQL Server Agent.
How to recover out of orphan distributed transaction?
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
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
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
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