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,
BryanYou had some reply on this last time you posted:
http://groups.google.com/groups?hl=...lic.sqlserver.*
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"BDB" <reply@.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 (1345
1)
> exceeds the configured threshold of 10800. Contact the system administrato
r.
> 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
>
Wednesday, March 7, 2012
Problem With Query Cost Govenor
Labels:
all_errormsgs,
checkdb,
cost,
database,
govenor,
ltdatabasegt,
microsoft,
msg,
mysql,
oracle,
query,
repair_fast,
running,
server,
sql,
tablockand,
thisdbcc,
thisserver
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment