Problem With Query Cost Govenor

3 Jun 2005 2:45 PM

BDB

Hi,

I'm running this:

DBCC CHECKDB ( '<database>', REPAIR_FAST ) WITH ALL_ERRORMSGS, TABLOCK

And I'm getting this:

Server: Msg 8649, Level 17, State 1, Line 2
The query has been canceled because the estimated cost of this query (13451)
exceeds the configured threshold of 10800. Contact the system administrator.

When I remove the query governor it runs in about 30 seconds not 10800+.
The stats on this database were manually updated with sp_createstats and
sp_updatestats.

Does anyone have any recommendations?

Thanks,
Bryan

3 Jun 2005 2:52 PM

Tibor Karaszi

You had some reply on this last time you posted:

http://groups.google.com/groups?hl=sv&lr=&threadm=AF7048A7-CBBC-4EAC-A6F6-1F5D5AD4F45E%40microsoft.com&rnum=8&prev=/groups%3Fhl%3Dsv%26lr%3D%26q%3D8649%26btnG%3DS%25C3%25B6k%26meta%3Dgroup%253Dmicrosoft.public.sqlserver.*

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/

Show quoteHide quote

"BDB" <re***@to.group.com> wrote in message news:%23TgJUrEaFHA.3876@TK2MSFTNGP12.phx.gbl...
> Hi,
>
> I'm running this:
>
> DBCC CHECKDB ( '<database>', REPAIR_FAST ) WITH ALL_ERRORMSGS, TABLOCK
>
> And I'm getting this:
>
> Server: Msg 8649, Level 17, State 1, Line 2
> The query has been canceled because the estimated cost of this query (13451)
> exceeds the configured threshold of 10800. Contact the system administrator.
>
> When I remove the query governor it runs in about 30 seconds not 10800+.
> The stats on this database were manually updated with sp_createstats and
> sp_updatestats.
>
> Does anyone have any recommendations?
>
> Thanks,
> Bryan
>
>