I was presented with a question I didn't have an answer to. Hopefully this will get an answer and not go unanswered. I think it's fairly basic but I'm still new to the product.
Does Foglight-SQL PI record only the stored proc metrics or does it also record the t-sql code metrics inside the stored procedure as well?
Example. Stored procedure "spGetData" has a select statement in it. Does SQLPI gather metrics on both "spGetData" and the select statement it is running?
Thanks!