question about "query governor cost limit " 
Author Message
 question about "query governor cost limit "

hi all

i have set my
 query governor to prevent queries exceeding specified cost =10
 & restarted my sqlserver
so i run two statement in query analyzer
fisrt:
 begin tran
 select * from mytable with(holdlock) where id=1

(open a new query)
second:
 begin tran
 update mytable  set col1=col1 where id=1

 here the second process is blocked by the first process
 but it doesn't quit when 10 seconds are passed, i have thinked
 that "query governor cost limit " is set to 10(s),so the blocked
 process will quit when 10 seconds pass
 i wonder why?

 best reguard



Sat, 01 Jan 2005 15:50:53 GMT
 question about "query governor cost limit "

Query governor limiter will not run any queries with an
estimated execution time in seconds greater than the value
set.   It does not kill queries that exceed that value

In your case the estimated time will be less than 10 secs
and will be allowed to run even though it will be blocked
by your first query

Quote:
>-----Original Message-----
>hi all

>i have set my
> query governor to prevent queries exceeding specified
cost =10
> & restarted my sqlserver
>so i run two statement in query analyzer
>fisrt:
> begin tran
> select * from mytable with(holdlock) where id=1

>(open a new query)
>second:
> begin tran
> update mytable  set col1=col1 where id=1

> here the second process is blocked by the first process
> but it doesn't quit when 10 seconds are passed, i have
thinked
> that "query governor cost limit " is set to 10(s),so the
blocked
> process will quit when 10 seconds pass
> i wonder why?

> best reguard

>.



Sat, 01 Jan 2005 19:31:29 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. question about " query governor cost limit "

2. Query Governor Cost Limit Values

3. max of ("...","...","..")

4. query governor cost

5. "Assembly" Database for Cost Estimating

6. Cluster "isalive" Query security related question

7. Question about queries using "UNION"

8. Question about queries using "UNION"

9. "newbie" Query Analyzer question

10. Question: Research on "typical" database queries

11. "LIMIT" problem

12. "LIMIT" problem again


 
Powered by phpBB® Forum Software