Yes, that's the one.

The SQL is application-generated, but it's from a reporting tool that does not do any DML, only reads from star-schema data models.

Still, I'll try and dig deeper and see if it's part of a bigger transaction.

About lock escalation: It's SQL Server 2005, so I don't think partition level lock escalation is possible.

I will run dbcc tracestatus (-1) on all environments to see if any lock escalation flags are set.

Thanks so much for diving into this.