I have a magic phrase I've memorized and you can have it too.

"I don't know, but here's how I'd find the answer..."

Now, you have to have a plan...

Since you're talking non-production environments, I'd suggest doing side-by-side installs so you can be more assured of your results. Upgrading, and downgrading, are always fraught with potential issues. You just...

Since you're talking non-production environments, I'd suggest doing side-by-side installs so you can be more assured of your results. Upgrading, and downgrading, are always fraught with potential issues. You just...

Thanks for the feedback all. No, no hate on Trace. I was dead serious in what I said about never questioning anyone using it ever again. Also, equally serious about...

And I understand it's fixed now.

Next time, please, a link. I tracked it down. Seems to be missing or something. I've sent it on to those who might know.

SQL Server 2022 Forum on SQLServerCentral

All set. I tested to make sure posts can go up, so you should be ready to go. Ask away!!

Good point. I'll see what I can do.

Make sure you turn on blocked process report in Extended Events. It'll be a lot easier to KNOW what's going on rather than relying on some random people on...

It's not traditional ghost rows. Those are from a simple delete and you'd never see what you're seeing (I stand by my very first post in this thread on that...

You didn't indicate schema in your pseudocode. Did you use schema name in your query? (Recommend you always do to avoid ambiguity) Any tables, views, or synonyms w/ the...

Also, the code didn't include the clustered index that is clearly there in the plan and the picture of the table.

Ah, so RCSI and Availability Groups. That changes things.

So, yeah, what's happening is, because you have RCSI, it has to keep those version records. Normally, those get cleaned up, but,...

If there are 50k reads, there's some data somewhere. Without seeing the query, your structures, the execution plan, nothing but the version of SQL Server, which, sorry, communicates just almost...