How One App Held an Availability Group Hostage
by Michal Kovaľ on 25/05/2021In the world of SQL Server, TEMPDB is often called the "public dumping ground." We expect it to be busy, but we also expect it to clean up after itself.
Read moreIn the world of SQL Server, TEMPDB is often called the "public dumping ground." We expect it to be busy, but we also expect it to clean up after itself.
Read moreYou might have been wondering what all those ANSI settings are and how they can affect you work.
Read moreRecently, we have got a case where our customer requested to implement archiving strategy for their DWH. We wanted to share with you how we approached this and what was the final output.
Read moreA customer’s SQL Server instance reached 100% CPU utilization. Blocking increased, response times deteriorated, and unrelated workloads slowed down. The cause was a Camunda worker query executed roughly 100 times per second in one database and 40–50 times
Read moreWhy an Index Seek can still process millions of rows, how redundant indexes affect write-heavy workloads, and why doubling cloud CPU capacity cannot compensate for slower storage.
Read moreIn high-concurrency environments, deadlocks are more than just technical glitches...they are silent performance killers.
Read more