I have a batch (7 queries) which executes in a couple of seconds locally by takes more than an hour in production.
I've have a .sqlplan XML file from that long running query on production and trying to find the bottleneck based on the execution plan. I'm looking for Actual number of rows = a big number, but don't see anything above a 1000 rows, I'm expecting something in the millions there considering it the query took so long.
I think this is not a deadlock because running sp_who shows the first query from the batch doing tens of millions of IO operations, but no clue about it in the actual execution plan.
What other metrics in the execution plan should I pay attention too to try find the bottleneck?