Query Governor Cost Limit Values 
Author Message
 Query Governor Cost Limit Values
Hi

Does anyone know what units are the query governor cost limits?  I
understand that it will be application specific but are thery any commonly
used values.

Also, are there any counters to determine what value is SQL Server is
currently using/average/highest values of costs for the db.

Thanks -Paritosh



Sat, 29 May 2004 04:00:17 GMT
 Query Governor Cost Limit Values

Query cost refers to the estimated elapsed time, in seconds, required to
execute a query
You can set it on a connection basis using SET QUERY_GOVERNOR_COST_LIMIT
If you use sp_configure to change the value of query governor cost limit,
the changed value is server-wide

sp_configure will show you the current value for the server


Quote:
> Hi

> Does anyone know what units are the query governor cost limits?  I
> understand that it will be application specific but are thery any commonly
> used values.

> Also, are there any counters to determine what value is SQL Server is
> currently using/average/highest values of costs for the db.

> Thanks -Paritosh



Sat, 29 May 2004 04:21:47 GMT
 Query Governor Cost Limit Values
    This is practically useless. You cannot determine the estimated elapsed
time for a query by using any commands/tools in SQL Server. Instead look at
the IO & CPU usage for various transactions. This can be done using
profiler.

--
Umachandar Jayachandran
SQL Resources at http://www.umachandar.com/resources.htm
( Please reply only to newsgroup. )



Sat, 29 May 2004 09:05:12 GMT
 Query Governor Cost Limit Values
Thanks for the clarification.  The option should be eliminated in the future
releases if so.


Quote:
>     This is practically useless. You cannot determine the estimated
elapsed
> time for a query by using any commands/tools in SQL Server. Instead look
at
> the IO & CPU usage for various transactions. This can be done using
> profiler.

> --
> Umachandar Jayachandran
> SQL Resources at http://www.umachandar.com/resources.htm
> ( Please reply only to newsgroup. )



Sun, 30 May 2004 10:47:14 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. question about "query governor cost limit "

2. query governor cost

3. Query Analyzer - I/O Cost, CPU Cost, and Cost

4. Setting the cost limit for a query...

5. question about " query governor cost limit "

6. Monitoring MSDE workload governor that limits

7. Bit-Map Indexes and Query Governors

8. Estimated Exec Time & Query Governor

9. Query Governor - possible to exclude replication jobs?

10. query governor

11. Query Governor

12. 2000 Query Governor


 
Powered by phpBB® Forum Software