I’ve been aware of the Query Store since it was first introduced in SQL Server 2016 and I’ve had it enabled since, but honestly, I didn’t appreciate the power of this thing until a few years ago. I’ve since learned, the Query Store can be a lot more than a passive black box, it should…… Continue reading The Query Store, right here waiting for you
Tag: SQL Server
What’s running right now?
sp_activespids will tell you There’s a lot of ways to see what requests are running on a MS SQL instance. For years I’ve trusted this handy custom stored procedure, sp_activespids, to get it done quickly and with little overhead. It’s been around in one form or another for almost 20 years. I’ve made most of…… Continue reading What’s running right now?