Their server got tremendously slow with many sessions suspending in the status of SUSPENDED status and they were waiting on PAGELATCH_UP and PAGELATCH_SH.
SQL SERVER – 5 Performance Optimizations Must Do for TempDB
Great hardware, bad performance, and TempDB was the culprit. Here are 5 performance optimizations must do for TempDB, starting with pre-sizing it.
SQL SERVER – Error: 5173 – One or More Files do Not Match the Primary File of the Database
In this blog, we would discuss error: Error: 5173 – One or more files do not match the primary file of the database and its solution.
SQL SERVER – Docker Volume and Persistent Storage
What happens to your data when you patch or upgrade SQL Server in a container? Here is how to use a Docker Volume for persistent storage.
Get-AzureStorageBlob: The Remote Server Returned an Error: (403) Forbidden. HTTP Status Code: 403 – HTTP Error Message: This Request is Not Authorized to Perform This Operation
A runbook cleaning old backup blobs in Azure failed with (403) Forbidden: This request is not authorized to perform this operation. Here is the fix.
SSMS – Azure Storage Error – A Connection Attempt Failed Because the Connected Party did not Properly Respond After a Period of Time
SSMS could not open Azure Storage: a connection attempt failed because the connected party did not properly respond. Here is what caused it.
SQL SERVER – Unable to Set Cloud Witness. Error: The Client and Server Cannot Communicate, Because They do Not Possess a Common Algorithm
Adding a cloud witness to my cluster failed: The client and server cannot communicate, because they do not possess a common algorithm. I share the fix that worked.