Hello. I was making some minor changes to indexes the other day. The next day I noticed our Work Files Per Minute counter for the instance I was working on had jumped from about 20k to 175k. Looking at historical data, this counter has always been down around 20k and the jump occured at the exact time I was making changes to indexes.
I kept a log of the "major" index changes I made, and I have undone time, but to no avail: the counter is still north of 150k, always.
I understand Work Files per Minute are generated from hash joins, which I most certainly could have affected by changing indexes around.
Is there a way for my to track down which query plans are generating the increased number of hash joins, or some how see what exactly is creating these work files?