query governor 
Author Message
 query governor

Wonhyuk,

im afraid its neither.

The query governor is calibrated at Microsoft based on a machine running
queries there.  Unless you know the exact specification of that machine
(which I dont) then the unit of measurement can only act as a guide line.
What you can do though is compare the costs of the query through the
governor and the show stats option from which you should be able to make an
estimate.

Steve Robinson
SQLServer MVP



Quote:
>What is the unit of Query_Governor_cost_limit? Is that a ms or sec?

>--
>Thanks in advance,

>Wonhyuk William Chung

>"If you want to see the rainbow, you must first put up with the rain" -
>Unknown



Fri, 27 Jul 2001 03:00:00 GMT
 query governor

What is the unit of Query_Governor_cost_limit? Is that a ms or sec?

--
Thanks in advance,

Wonhyuk William Chung

"If you want to see the rainbow, you must first put up with the rain" -
Unknown



Fri, 27 Jul 2001 03:00:00 GMT
 
 [ 2 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. question about "query governor cost limit "

6. Query Governor

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