This was a very interesting situation and at the end of we had found the culprit for the slow query and resolved it. Today we will discuss the experience.
After a careful investigation into their system, we learned that this issue was with Power Options. Let us learn about that in this blog post.
I wrote a blog post about SQL SERVER – Best Value for Max Worker Count, after reading this blog post, I have received lots of emails.
Question: How Does QUOTED_IDENTIFIER Works in SQL Server?Answer: If you search on the internet, you may find quite lots of notes about it. So in this blog post, I will explain in very simple words.
Just the other day, I had a very interesting experience while using the latest SQL Server Management Studio 18.0 preview 7 (SSMS 18.0) during one of the Comprehensive Database Performance Health Check. My client said they have realized that SQL Server does not have settings of Priority Boost settings available in SQL Server anymore. Actually, this is not true, let us quickly understand the same.
SQL SERVER – FIX: The specified instance of SQL Server is hosted by a system that is not a Windows Server Failover Cluster(WSFC) Node.
Sometimes if the sequence is not followed correctly, we might see some weird errors. In this blog, we would learn how to fix always on an error while adding new replica “The specified instance of SQL Server is hosted by a system that is not a Windows Server Failover Cluster(WSFC) node.”