The Distributed Availability Group Dashboard can be downloaded from our GitHub repo. https://github.com/SQLUndercover/UndercoverToolbox/blob/master/DAG%20Dashboard.pbix. This comes off of the back of my last post looking at using a distributed availability group (DAG) to help facilitate a SQL server migration. SQL Server Migration Using a Distributed Availability Group One thing that I mentioned in that post was that,... Continue Reading →
SQL Server migrations are a headache, ask anyone who's been through the pain of moving a reasonably large server and I'm sure they will agree. There are all sorts of methods out there for getting the data over to our new server. We can simply backup the databases and restore them to their new home.... Continue Reading →
Recently I received a cry for help over Teams. The issue was that an application was throwing up the following SQL error, The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very... Continue Reading →
"Could you help me, we deleted the database's transaction log file and now that database is stuck in 'Recovery Pending'?" This was a panicked call that I received a few weeks ago. "Sure, no problem" said I, "we'll have to restore back to your last backup" And then things went silent for a while before... Continue Reading →
Way back in the mists of time I wrote a post on how to backup SQL server to an S3 bucket using TNTDrive, https://sqlundercover.com/2018/06/18/backup-your-on-premise-sql-server-directly-to-an-aws-s3-bucket/. Back then, if we wanted to backup SQL to S3 we needed to use a third party tool. Since SQL 2022 things have changed and we've now got the option to... Continue Reading →
Are you struggling with a laggy redo and a build up in the redo queue on your readonly secondaries? Are you suffering with high PARALLEL_REDO_TRAN_TURN waits? Then this magic remedy could cure your ailments. There is a slight misconception with readonly AG replicas that the data should be 100% up to date with what's on... Continue Reading →
I recently received a complaint that Query Store for a particular database was turned off, which was strange as that particular database has seen quite a few performance issues and I know that I'd ensured Query Store was enabled in the past. No problem, I flicked the switch and Query Store was enabled again. Half... Continue Reading →
This is something that I've seen pop up a couple of times on various forums recently, how can we export the results of an XEvent session. So I thought I'd answer the question here. It's actually a very simple thing to do in SSMS, although the option is not always easy to spot. When we... Continue Reading →
Full documentation on the Undercover Catalogue can be found HERE It's been a while since the Undercover Catalogue last received an update but having had a few of those moments recently when I thought to myself 'I really wish I was capturing that data', so I decided to roll a few changes into the Catalogue.... Continue Reading →
Your boss walks up to you one morning and says, "Hey, I wanna list of all of our databases and when they were last accessed". If you've got some sort of auditing switched on or a trace or xevent catching this sort of info you might be ok, but I'm betting you don't have any... Continue Reading →
SQL Undercover 