Query Governor 
Author Message
 Query Governor
When turn on Query Governor, several stored procedures
stop running because they exceed the threshold. The
estimated time is very, very different than the real time
to run the stored procedures, for example, the estimated
time for one stored procedure is 60 minutes, but actually
it takes only 4 minutes to run. Any idea on how Query
Governor estimates the time?

Thanks for any ideas.



Sat, 14 Feb 2004 10:18:58 GMT
 Query Governor

Based on the statistics on your tables. You might want to check if the
statistics are up to date.
-GertD


Quote:
> When turn on Query Governor, several stored procedures
> stop running because they exceed the threshold. The
> estimated time is very, very different than the real time
> to run the stored procedures, for example, the estimated
> time for one stored procedure is 60 minutes, but actually
> it takes only 4 minutes to run. Any idea on how Query
> Governor estimates the time?

> Thanks for any ideas.



Sat, 14 Feb 2004 15:48:47 GMT
 Query Governor

Thanks for the info. The database is set with Auto create statistics and Auto update statistics under Options.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!



Sun, 15 Feb 2004 01:16:13 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Bit-Map Indexes and Query Governors

2. Estimated Exec Time & Query Governor

3. Query Governor - possible to exclude replication jobs?

4. Query Governor Cost Limit Values

5. query governor

6. question about "query governor cost limit "

7. query governor cost

8. 2000 Query Governor

9. Query Governor - Good or Evil?

10. Query Governor?

11. Query Governor for System 11

12. question about " query governor cost limit "


 
Powered by phpBB® Forum Software