We've all been there, trying to figure out who's blocking who, who is the most avid blocker. Personally, I was and still am a huge fan of Adam Machanic's (b) sp_WhoIsActive for accomplishing that. But I stumbled upon a nice script from @SQL_Undercover (b|t) which is using sp_BlitzWho stored procedure. For the ones not familiar … Continue reading Collecting blocking chain
Hello again... I came across something weird recently while trying to understand some strange behaviors we seen on our RDS instances in AWS. Here's some background. We have 18 RDS instances in AWS (various sizes) spread across 3 environments: test, stage and production. All 18 of them are using multi-az and SQL 2017 Standard Edition. … Continue reading AWS RDS multi-az setup falsely reports multiple secondary partners
Hello again. You all probably heard here and there that separating data from the indexes is good. Some of you even went down that road and actually did it. Which is good. There are also a ton of articles on this topic and the ones that come quickly to my mind are the ones authored … Continue reading Why is important to separate data from indexes
We all know that autogrowth events are bad, for a lot of reasons. For starters, it increases the number of VLOGs for the transaction log. Second, depending on your settings, it may also slow down your server if these are often enough. Third, it means that you, as a DBA, missed something in the configuration … Continue reading Reporting on AutoGrowth Events
Part of my scripts collection, is a script that returns the details of a table: storage, metadata (sys.objects), partitioning, etc. I was using this script for quite a while and ran ok. Few days ago, however, after I disabled an index on a partitioned table it failed and the error was a bit puzzling: Msg … Continue reading The joy of FILEGROUP_NAME (and probably other as well)
One of my main tasks is to keep a close eye on performance. Every time we have a major release, I have to start looking at performance, find main culprits and fix them. Well, not me, but work with developers and find a solution to the issues at hand. And our databases are rather large, … Continue reading Aggregation and partitioned tables
I received recently an email from a friend asking for my help as he faced a problem. He runs a small business in the healthcare industry and his needs in terms of IT should and are minimalist, if you want. And that's expected. Of course, I asked what was the problem about and he said: … Continue reading Corruption she (the DBCC) wrote….