related to get cpu resource/usage after running the query on tab

r_b_chauhan's profile image r_b_chauhan posted 2 years ago in General Permalink

hi, i want to get CPU usgae/resource for particular query so can anyone help for this how to get it?

ansgar's profile image ansgar posted 2 years ago Permalink

A good overview is given by the query profile, which you just need to activate at the right side of the query tab:

Description

r_b_chauhan's profile image r_b_chauhan posted 2 years ago Permalink

but if i am trying to run large/complex stored procedure then it is showing blank in result set like this.. what to do for this??

1 attachment(s):
  • Screenshot-135-
r_b_chauhan's profile image r_b_chauhan posted 2 years ago Permalink

even after > but if i am trying to run large/complex stored procedure then it is showing blank in result set like this..after activating the query profile..

what to do for this??

ansgar's profile image ansgar posted 2 years ago Permalink

No clue. I would activate multi-queries to see if that helps the profiler:

Description

Please login to leave a reply, or register at first.