SQL Query Runtime

Hello All:
   Try to find a way to see if there are any existing SQL function or commands that measure last ran query run time. Like how @@rowcount or @@PROCID is used
pengbsamAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
lcohanConnect With a Mentor Database AnalystCommented:
You could code your own datetime variables just before and immediately after your query to capture that however if you want to see that for debugging purpose use SET STATISTICS TIME ON in your session then execute your query and check results. Another extremely useful setting is SET STATISTICS IO ON
0
 
jijeeshCommented:
If you use sql profiler you can see the query history.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.