Recent Blog ArticlesNewest TopicsMost LikesTagged:TagQuery performance drops due to version_ghost_record_count in AlwaysOn The title is actually a little bit misleading, because the issue will not only happen on AlwaysOn, but let's start with this. The symptom is that, you may have alwayson environment and you have reada...AlwaysOn synchronize performance can affect memory? In an AlwaysOn environment, if you found your memory is slowly increasing or out of memory, you can use below way to check if it's caused by slow synchronization. Firstly, check the errorlog or...Troubleshooting for SQL Server 4014 error message Some times you may observe 4014 error messages in SQL Server errorlog, like below Error: 4014, Severity:20, State: 11. A fatal error occurred while reading the input stream from the network. The s...FDLauncher cannot be stopped automatically If you are using Full text index, then you should have a service named 'MSSQLFDLauncher', and usually it should be stopped automatically when you stop SQL Server serivce. This is the expected behavio...SQL Server Performance Counter are Missing If you find the SQL Server related performance counter objects are missing, you can try below steps to get it back For example, my instance name is STD2016, and now open the command window with...Why my transaction promoted to DTC transaction? Recently we received such kind of issue that, when you simply just open a connection to SQL Server, you can see there was DTC transactions enlisted. However, this only happened for the SQLOLEDB...SQL2019 certificate import error "selected certificate name does not match FQDN of this hostname"
MicrosoftMicrosoftMicrosoftMicrosoft
