There were a few emails about login times so I figured it warranted a blog post. Strap in, this one goes sideways fast. Some people noted that the amount of time to log in with a SQL Login in SQL Server 2025 all of a sudden took longer. This is clearly stated in the Docs, […]
It feels like only yesterday I was complaining about Sentinel One trying to take the crown for shittiest security software. Afraid they may be dethroned, CrowdStrike hit back and hit back hard! It started off with a report that Erik loves some big memory grants and cannot lie. One of the worst monitoring tools for […]
I have a long history shitting on CrowdStrike – and well, with their past it’s pretty warranted – but antivirus software is general does bother the hell out of me. You’re essentially installing something that interrogates everything on your system and injects itself everywhere hoping it stops a known issue but generally ends up causing […]
Primer If you haven’t already read up on cooperative and preemptive scheduling or aren’t sure what those are, please read the intro to that first, otherwise you’ll be lost. Much as I’ve discussed before, SQL Server uses a cooperative scheduling model. This doesn’t mean that Windows does, nor does it mean Windows will scheduler whatever […]
Issue Introduction In this olved stery the problem comes as a slow database restore. That’s what I was given, that’s all I have. It’s super fun when someone tells you the issue and there is absolutely no information or data around it, right? Questions That Need Answered Why is the “restore slow” What factors, if […]
You’ve won! If, somehow, you’ve managed to see this error in your errorlog then congratulations, you’ve won an instance of SQL Server that probably won’t be doing much. I found out about this message a few months ago, but it has been in the product for years and I went this long without ever even […]
Overall Introduction I’ve had some feedback that people would like to know some of the stuff I see and how I ended up finding the issue and troubleshooting the problem. I present to you a new heading/series called “olved steries”. If you’re wondering, “What is this name and do you not know how to spell?” […]
One of the most common issues I look at from day to day is some variation of the question. “Why did it take a long time for my AG/Database to failover?”. There are many different meanings for this innocuously simple looking statement, for example was it that the failover time was long or was it […]
Departure Hopefully, you’re not finding this entry because you’re scouring the web for what reverting means while your production server is in this state… but chances are, that’s the case. Initiation What is reverting? How did I get here? Is this real life? All great questions. Each time a secondary replica connects to the primary, […]
I tend to be involved in many HA related issues, as is the nature of my current work agreement. The interesting part is that roughly 85% of all the “HA” issues are performance issues (with 10-12% being config issues and the last 3-5% being truly HA issues). Whether this is an FCI, AG, Replication, some […]
