Estimated Exec Time & Query Governor 
Author Message
 Estimated Exec Time & Query Governor

We have the "query governor cost limit" option in place. When you go over
the limit, it tells you how long it estimates the query will take.

Two questions:

Is there a way to configure sql server to log or notify when the estimated
or actual execution time is a certain value (e.g., ten seconds less than the
limit)?

Is there a way to get at the time estimate SQL Server is using? You can show
stats time in QA to get actual time of a query that's already run, but how
can a stored procedure be programmed to detect and report that the query
it's about to execute is at or approaching the limit?

(The trouble is that a query can run fine for months, then when enough data
accumulates, suddenly you're over the limit and things start breaking.)

Thanks all.



Sat, 28 Jun 2003 02:34:14 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Estimating query execution time

2. estimating the execution time of a query ?

3. Estimated Query Execution TIME

4. Estimated Query Execution TIME

5. Estimate query time

6. Estimate query time

7. Estimating query execution time

8. Estimating query execution time

9. Query varies in exec time

10. Query Exec time

11. Help with Slow Query & Exec Plan

12. Bit-Map Indexes and Query Governors


 
Powered by phpBB® Forum Software