The client was in very much panic as they were getting the following error – The operating system returned error 21(The device is not ready.)
While working on Comprehensive Database Performance Health Check about additional transactional log files and today I got to follow up via email.
Question: How to Solve Error When Transaction Log Gets Full?
Answer: This was a question I was asked in the recent Health Check.
SQL SERVER – Fix: Configuration Manager- Cannot Connect to WMI Provider. You Do Not Have Permission or The Server is Unreachable
Let us learn how to solve Configuration Manager – Cannot Connect to WMI Provider. You Do Not Have Permission or The Server is Unreachable.
My clients enabled query store features to perform some troubleshooting which was a cause of unable to disable Query Store for Always On Database.
When my client was trying to patch the other node, it failed with an error – There are No More Endpoints Available From The Endpoint Mapper