• State Not Answered
  • Locked Locked
  • Replies 3 replies
  • Subscribers 59 subscribers
  • Views 5451 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

SQL PI Performance tree

john.waclawski
over 7 years ago

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!

 

Parents
  • 0 over 7 years ago
    Yes, your understanding is correct. Expand the (+) next to the stored procedure name (eg. spGetData) and you will have another set of dimensions to pick. The SQL Statements one will show the executions of the statement(s) within that stored procedure.
Reply
  • 0 over 7 years ago
    Yes, your understanding is correct. Expand the (+) next to the stored procedure name (eg. spGetData) and you will have another set of dimensions to pick. The SQL Statements one will show the executions of the statement(s) within that stored procedure.
Children
No Data