SQL Server：如何以编程方式检索性能指标;特别是逻辑读取

Background: I have a very complex stored procedure that dynamically creates SQL based on ten parameters. On top of this, it uses some views, which are themselves quite complicated. As one can imagine, in some cases, the resulting SQL statement generates quite a few (as in trillions in the worst case) logical reads. I have several strategies that I'm working through. I have a very complex stored proced