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.)
SQL SERVER – Removing Additional Transactional Log Files
While working on Comprehensive Database Performance Health Check about additional transactional log files and today I got to follow up via email.
How to Solve Error When Transaction Log Gets Full? – Interview Question of the Week #272
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 – Fixing Freezing Activity Monitor
I personally prefer to use DMVs and DMFs but for the visualization easiness client preferred Activity Monitor which was Freezing suddenly.
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.
SQL SERVER – Unable to Disable Query Store for Always On Database
My clients enabled query store features to perform some troubleshooting which was a cause of unable to disable Query Store for Always On Database.
SQL SERVER – Upgrade Failure – There are No More Endpoints Available From the Endpoint Mapper
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