Is it possible to return server data with every query?
As an example, I might run a stored procedure which uses a lot of resources. If I were to log onto the server at the same time as I'm running the stored procedure, I could see the memory usage/CPU/etc. Is there any circumstance in which MSSQL returns that kind of data on a SPID basis?
It is also possible for me to build out (as part of the software) that as my query is running, it also runs sp_whoisactive or sp_who2, etc to collect that information every few seconds. Though it seems like an inefficient way to figure out what my query performance was.