March 7, 2011 at 11:48 am
I have got errors when i ran DBCC Checks on one of my databases.
The error doesn't say anything except that are in bold below:
Msg 8967, Level 16, State 216, Line 1
An internal error occurred in DBCC that prevented further processing. Contact Customer Support Services.
DBCC results for 'oncontact'.
Msg 8921, Level 16, State 1, Line 1
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.
DBCC results for 'sys.sysrowsetcolumns'.
There are 8715 rows in 47 pages for object "sys.sysrowsetcolumns".
DBCC results for 'sys.sysrowsets'.
There are 661 rows in 7 pages for object "sys.sysrowsets".
DBCC results for 'sysallocunits'.
There are 681 rows in 9 pages for object "sysallocunits".
DBCC results for 'sys.sysfiles1'.
There are 2 rows in 1 pages for object "sys.sysfiles1".
DBCC results for 'sys.syshobtcolumns'.
There are 8715 rows in 55 pages for object "sys.syshobtcolumns".
DBCC results for 'sys.syshobts'.
There are 661 rows in 8 pages for object "sys.syshobts".
DBCC results for 'sys.sysftinds'.
There are 0 rows in 0 pages for object "sys.sysftinds".
DBCC results for 'sys.sysserefs'.
There are 681 rows in 3 pages for object "sys.sysserefs".
DBCC results for 'sys.sysowners'.
There are 32 rows in 1 pages for object "sys.sysowners".
DBCC results for 'sys.sysprivs'.
There are 1462 rows in 9 pages for object "sys.sysprivs".
DBCC results for 'sys.sysschobjs'.
There are 1419 rows in 20 pages for object "sys.sysschobjs".
DBCC results for 'sys.syscolpars'.
There are 10603 rows in 110 pages for object "sys.syscolpars".
DBCC results for 'sys.sysnsobjs'.
There are 1 rows in 1 pages for object "sys.sysnsobjs".
DBCC results for 'sys.syscerts'.
There are 0 rows in 0 pages for object "sys.syscerts".
DBCC results for 'sys.sysxprops'.
There are 5012 rows in 34 pages for object "sys.sysxprops".
DBCC results for 'sys.sysscalartypes'.
There are 27 rows in 1 pages for object "sys.sysscalartypes".
DBCC results for 'sys.systypedsubobjs'.
There are 0 rows in 0 pages for object "sys.systypedsubobjs".
DBCC results for 'sys.sysidxstats'.
There are 4280 rows in 67 pages for object "sys.sysidxstats".
DBCC results for 'sys.sysiscols'.
There are 6236 rows in 37 pages for object "sys.sysiscols".
DBCC results for 'sys.sysbinobjs'.
There are 23 rows in 1 pages for object "sys.sysbinobjs".
DBCC results for 'sys.sysobjvalues'.
There are 4541 rows in 1054 pages for object "sys.sysobjvalues".
DBCC results for 'sys.sysclsobjs'.
There are 27 rows in 1 pages for object "sys.sysclsobjs".
DBCC results for 'sys.sysrowsetrefs'.
There are 0 rows in 0 pages for object "sys.sysrowsetrefs".
DBCC results for 'sys.sysremsvcbinds'.
There are 0 rows in 0 pages for object "sys.sysremsvcbinds".
DBCC results for 'sys.sysxmitqueue'.
There are 0 rows in 0 pages for object "sys.sysxmitqueue".
DBCC results for 'sys.sysrts'.
There are 1 rows in 1 pages for object "sys.sysrts".
DBCC results for 'sys.sysconvgroup'.
There are 0 rows in 0 pages for object "sys.sysconvgroup".
DBCC results for 'sys.sysdesend'.
There are 0 rows in 0 pages for object "sys.sysdesend".
DBCC results for 'sys.sysdercv'.
There are 0 rows in 0 pages for object "sys.sysdercv".
DBCC results for 'sys.syssingleobjrefs'.
There are 260 rows in 1 pages for object "sys.syssingleobjrefs".
DBCC results for 'sys.sysmultiobjrefs'.
There are 5467 rows in 39 pages for object "sys.sysmultiobjrefs".
DBCC results for 'sys.sysdbfiles'.
There are 2 rows in 1 pages for object "sys.sysdbfiles".
DBCC results for 'sys.sysguidrefs'.
There are 0 rows in 0 pages for object "sys.sysguidrefs".
DBCC results for 'sys.sysqnames'.
There are 92 rows in 1 pages for object "sys.sysqnames".
DBCC results for 'sys.sysxmlcomponent'.
There are 93 rows in 1 pages for object "sys.sysxmlcomponent".
DBCC results for 'sys.sysxmlfacet'.
There are 97 rows in 1 pages for object "sys.sysxmlfacet".
DBCC results for 'sys.sysxmlplacement'.
There are 17 rows in 1 pages for object "sys.sysxmlplacement".
DBCC results for 'sys.sysobjkeycrypts'.
There are 0 rows in 0 pages for object "sys.sysobjkeycrypts".
DBCC results for 'sys.sysasymkeys'.
There are 0 rows in 0 pages for object "sys.sysasymkeys".
DBCC results for 'sys.syssqlguides'.
There are 0 rows in 0 pages for object "sys.syssqlguides".
DBCC results for 'sys.sysbinsubobjs'.
There are 0 rows in 0 pages for object "sys.sysbinsubobjs".
DBCC results for 'temp_cmoship_backup'.
There are 197781 rows in 28255 pages for object "temp_cmoship_backup".
DBCC results for 'gmtitle'.
There are 16 rows in 1 pages for object "gmtitle".
DBCC results for 'cst_sample_ent'.
There are 501 rows in 10 pages for object "cst_sample_ent".
DBCC results for 'gmcampaign_c'.
There are 0 rows in 0 pages for object "gmcampaign_c".
DBCC results for 'cst_duns'.
There are 577 rows in 7 pages for object "cst_duns".
DBCC results for 'tb_PrgMilestone'.
There are 1288 rows in 25 pages for object "tb_PrgMilestone".
DBCC results for 'gm_groupd_backup'.
There are 204 rows in 3 pages for object "gm_groupd_backup".
DBCC results for 'tb_DistHolding'.
There are 221 rows in 250 pages for object "tb_DistHolding".
DBCC results for 'gmzip'.
There are 73600 rows in 1503 pages for object "gmzip".
DBCC results for 'cst_sample_opp'.
There are 9 rows in 1 pages for object "cst_sample_opp".
DBCC results for 'gmclient'.
There are 0 rows in 0 pages for object "gmclient".
DBCC results for 'cst_fcstwk_dddw'.
There are 61 rows in 1 pages for object "cst_fcstwk_dddw".
DBCC results for 'tb_DistProd'.
There are 148 rows in 2 pages for object "tb_DistProd".
DBCC results for 'cst_ship_from_dddw'.
There are 33 rows in 1 pages for object "cst_ship_from_dddw".
DBCC results for 'gmcm_a'.
There are 0 rows in 1 pages for object "gmcm_a".
DBCC results for 'tmp_forecastbulk'.
There are 302 rows in 16 pages for object "tmp_forecastbulk".
DBCC results for 'cst_fcstyr_dddw'.
There are 5 rows in 1 pages for object "cst_fcstyr_dddw".
DBCC results for 'tb_Territory'.
There are 243 rows in 2 pages for object "tb_Territory".
DBCC results for 'cst_ship_via_dddw'.
There are 13 rows in 1 pages for object "cst_ship_via_dddw".
DBCC results for 'gmcm_acct'.
There are 0 rows in 0 pages for object "gmcm_acct".
DBCC results for 'cst_fiscal_year'.
There are 261 rows in 10 pages for object "cst_fiscal_year".
DBCC results for 'cst_status_dddw'.
There are 6 rows in 1 pages for object "cst_status_dddw".
DBCC results for 'gmcm_addr'.
There are 25225 rows in 2181 pages for object "gmcm_addr".
DBCC results for 'tmp_CurrencyActual'.
There are 151 rows in 2 pages for object "tmp_CurrencyActual".
DBCC results for 'gmcm_aka'.
There are 27567 rows in 845 pages for object "gmcm_aka".
DBCC results for 'tb_PrgNote'.
There are 687 rows in 18 pages for object "tb_PrgNote".
DBCC results for 'temp_nsbfcst'.
There are 12077 rows in 2013 pages for object "temp_nsbfcst".
DBCC results for 'gmcm_assoc'.
There are 0 rows in 0 pages for object "gmcm_assoc".
DBCC results for 'tb_DimOpportunity'.
There are 18591 rows in 624 pages for object "tb_DimOpportunity".
DBCC results for 'gmcm_b'.
There are 0 rows in 1 pages for object "gmcm_b".
DBCC results for 'temp_doitr'.
There are 4403 rows in 201 pages for object "temp_doitr".
DBCC results for 'cst_country_dddw'.
There are 100 rows in 1 pages for object "cst_country_dddw".
DBCC results for 'gmcm_campaign'.
There are 0 rows in 0 pages for object "gmcm_campaign".
DBCC results for 'tb_PrgPart'.
There are 15 rows in 1 pages for object "tb_PrgPart".
DBCC results for 'tmp_PlanMidterm_0632'.
There are 7302 rows in 318 pages for object "tmp_PlanMidterm_0632".
DBCC results for 'gmcm_list'.
There are 0 rows in 0 pages for object "gmcm_list".
DBCC results for 'cst_opp_gauge_dddw'.
There are 11 rows in 1 pages for object "cst_opp_gauge_dddw".
DBCC results for 'tProductShipOrg'.
There are 8792 rows in 57 pages for object "tProductShipOrg".
DBCC results for 'gmcm_notes'.
There are 1 rows in 1 pages for object "gmcm_notes".
DBCC results for 'tmp_PlanNextYear_07A1'.
There are 1787 rows in 82 pages for object "tmp_PlanNextYear_07A1".
DBCC results for 'gmcm_prf'.
There are 0 rows in 0 pages for object "gmcm_prf".
DBCC results for 'temp_fyr'.
There are 1 rows in 1 pages for object "temp_fyr".
DBCC results for 'cst_planner'.
There are 19 rows in 1 pages for object "cst_planner".
DBCC results for 'tmp_LegacyCustomers'.
There are 42 rows in 3 pages for object "tmp_LegacyCustomers".
DBCC results for 'gmcm_rshp'.
There are 0 rows in 0 pages for object "gmcm_rshp".
DBCC results for 'tb_ShipAgg_AMUS_AME'.
There are 30914 rows in 2577 pages for object "tb_ShipAgg_AMUS_AME".
DBCC results for 'cst_prod_status'.
There are 4 rows in 1 pages for object "cst_prod_status".
DBCC results for 'tb_PrgPriority'.
There are 3 rows in 1 pages for object "tb_PrgPriority".
DBCC results for 'tmp_PlanMidterm_0639'.
There are 7602 rows in 331 pages for object "tmp_PlanMidterm_0639".
DBCC results for 'gmcm_sic'.
There are 213 rows in 2 pages for object "gmcm_sic".
DBCC results for 'tb_PlanMidtermAllegro'.
There are 7627 rows in 364 pages for object "tb_PlanMidtermAllegro".
DBCC results for 'cst_region_ddw'.
There are 46 rows in 1 pages for object "cst_region_ddw".
DBCC results for 'tb_PlanPreviousYear'.
There are 4051 rows in 193 pages for object "tb_PlanPreviousYear".
DBCC results for 'gmcm_sls'.
There are 23517 rows in 205 pages for object "gmcm_sls".
DBCC results for 'tb_PlanMidtermSanken'.
There are 7302 rows in 326 pages for object "tb_PlanMidtermSanken".
DBCC results for 'tmp_OrderType'.
There are 12 rows in 1 pages for object "tmp_OrderType".
DBCC results for 'tb_PrgRDEName'.
There are 6 rows in 1 pages for object "tb_PrgRDEName".
DBCC results for 'cst_pac_dddw'.
There are 0 rows in 0 pages for object "cst_pac_dddw".
DBCC results for 'gmcm_src'.
There are 0 rows in 0 pages for object "gmcm_src".
DBCC results for 'gm_agent'.
There are 7975 rows in 316 pages for object "gm_agent".
DBCC results for 'cst_portfolio'.
There are 97 rows in 2 pages for object "cst_portfolio".
DBCC results for 'cst_import_xref'.
There are 25254 rows in 336 pages for object "cst_import_xref".
DBCC results for 'tmp_DistPurge'.
There are 1288 rows in 4 pages for object "tmp_DistPurge".
DBCC results for 'gm_agent_notes'.
There are 330 rows in 6 pages for object "gm_agent_notes".
DBCC results for 'temp_ews_factory'.
There are 6155 rows in 308 pages for object "temp_ews_factory".
DBCC results for 'tmp_ForecastForOracle'.
There are 2214 rows in 111 pages for object "tmp_ForecastForOracle".
DBCC results for 'tb_PrgRDE'.
There are 1104 rows in 12 pages for object "tb_PrgRDE".
DBCC results for 'cst_mile_alert_log'.
There are 1589 rows in 7 pages for object "cst_mile_alert_log".
DBCC results for 'gm_agt_names'.
There are 281 rows in 3 pages for object "gm_agt_names".
DBCC results for 'gmcmpgnd'.
There are 0 rows in 0 pages for object "gmcmpgnd".
DBCC results for 'tb_CRD'.
There are 184783 rows in 14274 pages for object "tb_CRD".
DBCC results for 'gm_alert'.
There are 2 rows in 1 pages for object "gm_alert".
DBCC results for 'tmp_LegacyBillings'.
There are 116749 rows in 7297 pages for object "tmp_LegacyBillings".
DBCC results for 'gm_clseth'.
There are 0 rows in 0 pages for object "gm_clseth".
DBCC results for 'gmcntry'.
There are 247 rows in 26 pages for object "gmcntry".
DBCC results for 'gm_colh'.
There are 597 rows in 12 pages for object "gm_colh".
DBCC results for 'tb_PrgStatus'.
There are 5 rows in 1 pages for object "tb_PrgStatus".
DBCC results for 'tmp_LegacyProducts'.
There are 8682 rows in 121 pages for object "tmp_LegacyProducts".
DBCC results for 'temp_dowcr'.
There are 9792 rows in 105 pages for object "temp_dowcr".
DBCC results for 'gmcntstat'.
There are 0 rows in 0 pages for object "gmcntstat".
DBCC results for 'gm_comp_prod'.
There are 0 rows in 0 pages for object "gm_comp_prod".
DBCC results for 'FixMe'.
There are 466 rows in 11 pages for object "FixMe".
DBCC results for 'gmcnty'.
There are 3308 rows in 67 pages for object "gmcnty".
DBCC results for 'gm_comph'.
There are 0 rows in 0 pages for object "gm_comph".
DBCC results for 'tb_PrgTeamRole'.
There are 18 rows in 1 pages for object "tb_PrgTeamRole".
DBCC results for 'tmp_FiscalMonth'.
There are 72 rows in 1 pages for object "tmp_FiscalMonth".
DBCC results for 'temp_wtdobook'.
There are 769 rows in 70 pages for object "temp_wtdobook".
DBCC results for 'gmcont_role'.
There are 0 rows in 0 pages for object "gmcont_role".
DBCC results for 'tmp_DistBackup'.
There are 54418 rows in 379 pages for object "tmp_DistBackup".
DBCC results for 'gm_contract'.
There are 0 rows in 0 pages for object "gm_contract".
DBCC results for 'tb_Billings'.
There are 140155 rows in 14565 pages for object "tb_Billings".
DBCC results for 'tb_DimCustomer'.
There are 23421 rows in 1027 pages for object "tb_DimCustomer".
DBCC results for 'temp_weekly_oracle_bookings'.
There are 1125 rows in 103 pages for object "temp_weekly_oracle_bookings".
DBCC results for 'gmcycled'.
There are 0 rows in 0 pages for object "gmcycled".
DBCC results for 'tmp_DistDel'.
There are 3597 rows in 7 pages for object "tmp_DistDel".
DBCC results for 'gm_contractd'.
There are 0 rows in 0 pages for object "gm_contractd".
DBCC results for 'temp_pmobook'.
There are 7625 rows in 694 pages for object "temp_pmobook".
DBCC results for 'gmcycleh'.
There are 0 rows in 0 pages for object "gmcycleh".
DBCC results for 'gm_criteriac'.
There are 961 rows in 38 pages for object "gm_criteriac".
DBCC results for 'temp_mtdobook'.
There are 1002 rows in 92 pages for object "temp_mtdobook".
DBCC results for 'gmdedupd'.
There are 3 rows in 1 pages for object "gmdedupd".
DBCC results for 'gm_criteriah'.
There are 80 rows in 1 pages for object "gm_criteriah".
DBCC results for 'tmp_LegacyProducts2'.
There are 347 rows in 15 pages for object "tmp_LegacyProducts2".
DBCC results for 'temp_dobook'.
There are 309 rows in 29 pages for object "temp_dobook".
DBCC results for 'gmdeduph'.
There are 2 rows in 1 pages for object "gmdeduph".
DBCC results for 'gm_dberr'.
There are 0 rows in 0 pages for object "gm_dberr".
DBCC results for 'temp_cdobook'.
There are 228355 rows in 20772 pages for object "temp_cdobook".
DBCC results for 'gmdedupj'.
There are 18 rows in 1 pages for object "gmdedupj".
DBCC results for 'gm_excld'.
There are 6 rows in 1 pages for object "gm_excld".
DBCC results for 'temp_dooo'.
There are 9477 rows in 1053 pages for object "temp_dooo".
DBCC results for 'gmdept'.
There are 5 rows in 1 pages for object "gmdept".
DBCC results for 'gm_groupd'.
There are 204 rows in 5 pages for object "gm_groupd".
DBCC results for 'gmdeptd'.
There are 0 rows in 0 pages for object "gmdeptd".
DBCC results for 'tb_RepCompanyAccess'.
There are 4244816 rows in 15958 pages for object "tb_RepCompanyAccess".
DBCC results for 'temp_mtdoship'.
There are 533 rows in 77 pages for object "temp_mtdoship".
DBCC results for 'gm_grouph'.
There are 12 rows in 1 pages for object "gm_grouph".
DBCC results for 'tmp_MonthlyBillings'.
There are 47857 rows in 6837 pages for object "tmp_MonthlyBillings".
DBCC results for 'temp_daspor'.
There are 10163230 rows in 163925 pages for object "temp_daspor".
CHECKDB found 0 allocation errors and 0 consistency errors in database 'oncontact'.
does this mean the database is corrupted?
March 7, 2011 at 12:03 pm
Please script out your tempdb database (righ-click on the database icon in SSMS and Script Database As Create To New Query window.
Maybe you just have a tempdb that is too small and cannot grow to fit necessary stuff for dbcc checkdb to run.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
March 7, 2011 at 12:03 pm
Google is your friend. I blogged about this error here CHECKDB bug that people are hitting - Msg 8967, Level 16, State 216 almost 3 years ago.
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
March 7, 2011 at 12:07 pm
Run DBCC CheckDB With EstimateOnly and verify that you have enough tempDB space. EstimateOnly will tell you how much tempDB space it estimates will be needed.
If not enough space, try breaking the tempDB command into various parts. Paul Randal has a great blog post on how to run individual pices of DBCC CheckDB: http://www.sqlskills.com/BLOGS/PAUL/post/CHECKDB-From-Every-Angle-Consistency-Checking-Options-for-a-VLDB.aspx
EDIT: Never mind. Paul Randal posted a better reply while I was writing. 😀
March 7, 2011 at 12:29 pm
I ran dbcc check with estimateonly and i got:
Estimates tempdb space needed for CHECKALLOC(KB):
2182
Estimates tempdb space needed for CHECKTABLES(KB):
224267
Now i will i know the tempdb space of the database so that i can change it.
March 7, 2011 at 12:50 pm
Ignore TempDB. Go read Paul's blog post.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 7, 2011 at 2:06 pm
I did table lock on my database and saw couple of errors for the table named 'temp_shipbad' so i did a restore everything works fine now.
I have scheduled these DBCC CHECKDB to run on daily basis ,the only problem i have is when i get any errors (like data corruption ) how will i know without looking into error log or history daily,is there any automatic process for this which will tell me when i get the error ...
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply