• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 637
  • Last Modified:

time taken to execute query

Is there a way to determine the approximate time it would take to execute a particular query(of course without actually executing the query)?Some of our users complianed about time outs, since the amount of returned data is enormous.so..I would like to prompt them with a message saying that the processing time for their query is xxx secs/mins.

thanks in advance
0
spankenstien
Asked:
spankenstien
  • 2
1 Solution
 
muzzy2003Commented:
Short of something like:

SET SHOWPLAN_ALL ON
GO
<<User query>>
GO
SET SHOWPLAN_ALL OFF
GO

and some interpretation of the output based on comparisons with queries with roughly known execution times, I don't think so.
0
 
ShogunWadeCommented:
" since the amount of returned data is enormous.so"   Do they actually need all the data you are returning?

0
 
ShogunWadeCommented:
Do you need any more assistance with this question ?
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now