October 3, 2014 at 12:09 pm
Noticed this on a tucked-away server going through things today. Ran DBCC a couple different ways but the page is still marked suspect. Output from suspect_pages and the dbcc check is below.
Any suggestions?
Thanks
Database file_id page_idevent_typeerror_countlast_update_date
DB_0104521 15336961 1 2014-09-11 21:13:50.923
DBCC CHECKDB (DB_010452) WITH DATA_PURITY
DBCC results for 'DB_010452'.
Service Broker Msg 9675, State 1: Message Types analyzed: 14.
Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.
Service Broker Msg 9667, State 1: Services analyzed: 3.
Service Broker Msg 9668, State 1: Service Queues analyzed: 3.
Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.
Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.
Service Broker Msg 9605, State 1: Conversation Priorities analyzed: 0.
DBCC results for 'sys.sysrscols'.
There are 1378 rows in 18 pages for object "sys.sysrscols".
DBCC results for 'sys.sysrowsets'.
There are 209 rows in 2 pages for object "sys.sysrowsets".
DBCC results for 'sys.sysallocunits'.
There are 260 rows in 4 pages for object "sys.sysallocunits".
DBCC results for 'sys.sysfiles1'.
There are 2 rows in 1 pages for object "sys.sysfiles1".
DBCC results for 'sys.syspriorities'.
There are 0 rows in 0 pages for object "sys.syspriorities".
DBCC results for 'sys.sysfgfrag'.
There are 2 rows in 1 pages for object "sys.sysfgfrag".
DBCC results for 'sys.sysphfg'.
There are 1 rows in 1 pages for object "sys.sysphfg".
DBCC results for 'sys.sysprufiles'.
There are 2 rows in 1 pages for object "sys.sysprufiles".
DBCC results for 'sys.sysftinds'.
There are 0 rows in 0 pages for object "sys.sysftinds".
DBCC results for 'sys.sysowners'.
There are 16 rows in 1 pages for object "sys.sysowners".
DBCC results for 'sys.sysprivs'.
There are 150 rows in 1 pages for object "sys.sysprivs".
DBCC results for 'sys.sysschobjs'.
There are 332 rows in 6 pages for object "sys.sysschobjs".
DBCC results for 'sys.syscolpars'.
There are 2044 rows in 37 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 8 rows in 4 pages for object "sys.sysxprops".
DBCC results for 'sys.sysscalartypes'.
There are 36 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 366 rows in 6 pages for object "sys.sysidxstats".
DBCC results for 'sys.sysiscols'.
There are 566 rows in 4 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.sysaudacts'.
There are 0 rows in 0 pages for object "sys.sysaudacts".
DBCC results for 'sys.sysobjvalues'.
There are 499 rows in 134 pages for object "sys.sysobjvalues".
DBCC results for 'sys.sysclsobjs'.
There are 16 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 154 rows in 1 pages for object "sys.syssingleobjrefs".
DBCC results for 'sys.sysmultiobjrefs'.
There are 1448 rows in 13 pages for object "sys.sysmultiobjrefs".
DBCC results for 'sys.sysguidrefs'.
There are 0 rows in 0 pages for object "sys.sysguidrefs".
DBCC results for 'sys.syscompfragments'.
There are 0 rows in 0 pages for object "sys.syscompfragments".
DBCC results for 'sys.sysftstops'.
There are 0 rows in 0 pages for object "sys.sysftstops".
DBCC results for 'sys.sysqnames'.
There are 97 rows in 1 pages for object "sys.sysqnames".
DBCC results for 'sys.sysxmlcomponent'.
There are 99 rows in 1 pages for object "sys.sysxmlcomponent".
DBCC results for 'sys.sysxmlfacet'.
There are 112 rows in 1 pages for object "sys.sysxmlfacet".
DBCC results for 'sys.sysxmlplacement'.
There are 18 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 3 rows in 1 pages for object "sys.sysbinsubobjs".
DBCC results for 'sys.syssoftobjrefs'.
There are 525 rows in 7 pages for object "sys.syssoftobjrefs".
DBCC results for 'tbl_extr_items'.
There are 261819 rows in 29704 pages for object "tbl_extr_items".
DBCC results for 'tbl_entryIDs_parentInfo'.
There are 0 rows in 0 pages for object "tbl_entryIDs_parentInfo".
DBCC results for 'tbl_entryIDs'.
There are 0 rows in 0 pages for object "tbl_entryIDs".
DBCC results for 'tbl_email_metadata'.
There are 212076 rows in 90176 pages for object "tbl_email_metadata".
DBCC results for 'tbl_email_log'.
There are 803 rows in 23 pages for object "tbl_email_log".
DBCC results for 'tbl_container_types'.
There are 440 rows in 2 pages for object "tbl_container_types".
DBCC results for 'tbl_apps_config'.
There are 0 rows in 0 pages for object "tbl_apps_config".
DBCC results for 'tbl_action_results'.
There are 0 rows in 0 pages for object "tbl_action_results".
DBCC results for 'tbl_item_mso_metadata'.
There are 0 rows in 0 pages for object "tbl_item_mso_metadata".
DBCC results for 'tbl_4FreqRpt_ItemTermHits'.
There are 0 rows in 0 pages for object "tbl_4FreqRpt_ItemTermHits".
DBCC results for 'tbl_item_imgs'.
There are 0 rows in 0 pages for object "tbl_item_imgs".
DBCC results for 'tbl_item_custom_metadata'.
There are 0 rows in 0 pages for object "tbl_item_custom_metadata".
DBCC results for 'tbl_img_folders'.
There are 0 rows in 0 pages for object "tbl_img_folders".
DBCC results for 'tbl_history_rollback'.
There are 0 rows in 0 pages for object "tbl_history_rollback".
DBCC results for 'tbl_history_action_source'.
There are 0 rows in 0 pages for object "tbl_history_action_source".
DBCC results for 'tbl_history_action_results'.
There are 0 rows in 0 pages for object "tbl_history_action_results".
DBCC results for 'tbl_history_action_log'.
There are 0 rows in 0 pages for object "tbl_history_action_log".
DBCC results for 'tbl_NSF_Properties'.
There are 0 rows in 0 pages for object "tbl_NSF_Properties".
DBCC results for 'tbl_history_action_keyword_steps'.
There are 0 rows in 0 pages for object "tbl_history_action_keyword_steps".
DBCC results for 'tbl_NSF_Folders'.
There are 0 rows in 0 pages for object "tbl_NSF_Folders".
DBCC results for 'tbl_group_hash_created'.
There are 192283 rows in 842 pages for object "tbl_group_hash_created".
DBCC results for 'tbl_NSF_Docs_in_Folders'.
There are 0 rows in 0 pages for object "tbl_NSF_Docs_in_Folders".
DBCC results for 'tbl_GetNextXLSerHelper'.
There are 0 rows in 0 pages for object "tbl_GetNextXLSerHelper".
DBCC results for 'tbl_Extensions'.
There are 84 rows in 1 pages for object "tbl_Extensions".
DBCC results for 'tbl_GetNextTifferHelper'.
There are 0 rows in 0 pages for object "tbl_GetNextTifferHelper".
DBCC results for 'tbl_GetNextTextExtractorHelper'.
There are 0 rows in 0 pages for object "tbl_GetNextTextExtractorHelper".
DBCC results for 'tbl_GetNextQCHelper'.
There are 0 rows in 0 pages for object "tbl_GetNextQCHelper".
DBCC results for 'tbl_GetNextNSFTifferHelper'.
There are 0 rows in 0 pages for object "tbl_GetNextNSFTifferHelper".
DBCC results for 'tbl_GetNextItemIndexHelper'.
There are 1 rows in 1 pages for object "tbl_GetNextItemIndexHelper".
DBCC results for 'tbl_GetNextEmailGroupForHashHelper'.
There are 0 rows in 0 pages for object "tbl_GetNextEmailGroupForHashHelper".
DBCC results for 'tbl_GetNextDedupHelper'.
There are 0 rows in 0 pages for object "tbl_GetNextDedupHelper".
DBCC results for 'tbl_folders'.
There are 0 rows in 0 pages for object "tbl_folders".
DBCC results for 'tbl_action_log'.
There are 0 rows in 0 pages for object "tbl_action_log".
DBCC results for 'tbl_extr_items_interim'.
There are 0 rows in 0 pages for object "tbl_extr_items_interim".
DBCC results for 'tbl_action_keyword_steps'.
There are 0 rows in 0 pages for object "tbl_action_keyword_steps".
DBCC results for 'tbl_4FreqRpt_Midval_Final_RefTab'.
There are 0 rows in 0 pages for object "tbl_4FreqRpt_Midval_Final_RefTab".
DBCC results for 'tbl_4FreqRpt_ItemTermHits_orig'.
There are 0 rows in 0 pages for object "tbl_4FreqRpt_ItemTermHits_orig".
DBCC results for 'tbl_4FreqRpt_ItemHitCountLog'.
There are 0 rows in 0 pages for object "tbl_4FreqRpt_ItemHitCountLog".
DBCC results for 'tbl_4FreqRpt_Colllist_Optionset'.
There are 0 rows in 1 pages for object "tbl_4FreqRpt_Colllist_Optionset".
DBCC results for 'tbl_4FreqRpt_Midval_Final_RefTab_manual'.
There are 0 rows in 2 pages for object "tbl_4FreqRpt_Midval_Final_RefTab_manual".
DBCC results for 'tbl_4FreqRpt_CollectionTermHits'.
There are 0 rows in 0 pages for object "tbl_4FreqRpt_CollectionTermHits".
DBCC results for 'tbl_4FreqRpt_CollectionMetric'.
There are 0 rows in 1 pages for object "tbl_4FreqRpt_CollectionMetric".
DBCC results for 'tbl_4FreqRpt_CollectionHitCountLog'.
There are 1 rows in 1 pages for object "tbl_4FreqRpt_CollectionHitCountLog".
DBCC results for 'tbl_4FreqRpt_ActionTermHits'.
There are 0 rows in 0 pages for object "tbl_4FreqRpt_ActionTermHits".
DBCC results for 'rits_dedup_audit'.
There are 0 rows in 0 pages for object "rits_dedup_audit".
DBCC results for 'tbl_4FreqRpt_ActionTerm'.
There are 0 rows in 1 pages for object "tbl_4FreqRpt_ActionTerm".
DBCC results for 'tbl_4FreqRpt_ActionHitCountLog'.
There are 0 rows in 0 pages for object "tbl_4FreqRpt_ActionHitCountLog".
DBCC results for 'tbl_sortorder'.
There are 0 rows in 0 pages for object "tbl_sortorder".
DBCC results for 'tbl_QC_Performance'.
There are 0 rows in 0 pages for object "tbl_QC_Performance".
DBCC results for 'tbl_QC_log'.
There are 0 rows in 0 pages for object "tbl_QC_log".
DBCC results for 'tbl_properties_standard'.
There are 0 rows in 0 pages for object "tbl_properties_standard".
DBCC results for 'tbl_properties_mapping'.
There are 0 rows in 0 pages for object "tbl_properties_mapping".
DBCC results for 'tbl_nsf_custom_metadata'.
There are 0 rows in 0 pages for object "tbl_nsf_custom_metadata".
DBCC results for 'Review_MSODoc_type'.
There are 20 rows in 1 pages for object "Review_MSODoc_type".
DBCC results for 'tbl_log'.
There are 8 rows in 1 pages for object "tbl_log".
DBCC results for 'tbl_LockSelectRecordHelper'.
There are 0 rows in 0 pages for object "tbl_LockSelectRecordHelper".
DBCC results for 'tbl_LockSelectRecordHeaderHelper'.
There are 0 rows in 0 pages for object "tbl_LockSelectRecordHeaderHelper".
DBCC results for 'ExtractedItem_Review_Alert_Location'.
There are 0 rows in 0 pages for object "ExtractedItem_Review_Alert_Location".
DBCC results for 'tbl_LockSelectNSFRecordHelper'.
There are 0 rows in 0 pages for object "tbl_LockSelectNSFRecordHelper".
DBCC results for 'tbl_Item_Types'.
There are 0 rows in 0 pages for object "tbl_Item_Types".
DBCC results for 'ExtractedItem_Review_Alerts'.
There are 0 rows in 0 pages for object "ExtractedItem_Review_Alerts".
DBCC results for 'ExtractedItem_Review_Status'.
There are 0 rows in 0 pages for object "ExtractedItem_Review_Status".
DBCC results for 'freqdata'.
There are 0 rows in 0 pages for object "freqdata".
DBCC results for 'UsedKeywordFilters'.
There are 0 rows in 0 pages for object "UsedKeywordFilters".
DBCC results for 'werekws'.
There are 0 rows in 0 pages for object "werekws".
DBCC results for 'Sizedata'.
There are 0 rows in 0 pages for object "Sizedata".
DBCC results for 'PDF_Scan_Status'.
There are 0 rows in 0 pages for object "PDF_Scan_Status".
DBCC results for 'sys.queue_messages_1977058079'.
There are 0 rows in 0 pages for object "sys.queue_messages_1977058079".
DBCC results for 'tbl_Global_Dedup_ItemIDX_DocID_List_Overlay_Audit'.
There are 0 rows in 0 pages for object "tbl_Global_Dedup_ItemIDX_DocID_List_Overlay_Audit".
DBCC results for 'tbl_Global_Dedup_Audit_Table'.
There are 0 rows in 0 pages for object "tbl_Global_Dedup_Audit_Table".
DBCC results for 'sys.queue_messages_2009058193'.
There are 0 rows in 0 pages for object "sys.queue_messages_2009058193".
DBCC results for 'sys.queue_messages_2041058307'.
There are 0 rows in 0 pages for object "sys.queue_messages_2041058307".
DBCC results for 'sys.filestream_tombstone_2073058421'.
There are 0 rows in 0 pages for object "sys.filestream_tombstone_2073058421".
DBCC results for 'sys.syscommittab'.
There are 0 rows in 0 pages for object "sys.syscommittab".
DBCC results for 'Hashes from all previous jobs and Please always add the next job'.
There are 0 rows in 0 pages for object "Hashes from all previous jobs and Please always add the next job".
CHECKDB found 0 allocation errors and 0 consistency errors in database 'DB_010452'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
EDIT:
Following along from here[/url]
USE DB_010452
DBCC TRACEON (3604);
DBCC PAGE (91,1,1533696, 0);
DBCC TRACEOFF (3604);
GO
PAGE: (1:1533696)
BUFFER:
BUF @0x000000055EFD45C0
bpage = 0x000000055E8BA000 bhash = 0x0000000000000000 bpageno = (1:1533696)
bdbid = 91 breferences = 0 bcputicks = 0
bsampleCount = 0 bUse1 = 52354 bstat = 0xc00009
blog = 0xa2152159 bnext = 0x0000000000000000
PAGE HEADER:
Page @0x000000055E8BA000
m_pageId = (1:1533696) m_headerVersion = 1 m_type = 8
m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x200
m_objId (AllocUnitId.idObj) = 99 m_indexId (AllocUnitId.idInd) = 0 Metadata: AllocUnitId = 6488064
Metadata: PartitionId = 0 Metadata: IndexId = 0 Metadata: ObjectId = 99
m_prevPage = (0:0) m_nextPage = (0:0) pminlen = 90
m_slotCnt = 2 m_freeCnt = 6 m_freeData = 8182
m_reservedCnt = 0 m_lsn = (1435:32555:86) m_xactReserved = 0
m_xdesId = (0:0) m_ghostRecCnt = 0 m_tornBits = 232878925
Allocation Status
GAM (1:1533696) = ALLOCATED SGAM (1:1533697) = NOT ALLOCATED
PFS (1:1528632) = 0x40 ALLOCATED 0_PCT_FULL DIFF (1:1533702) = CHANGED
ML (1:1533703) = NOT MIN_LOGGED
Returns the ObjectID 99
But, from Paul's page:
The Metadata: ObjectId field is what we want. If you see it is 99, then stop as that means the damaged page is part of the allocation system and not part of a table and you’ll need to wait for DBCC CHECKDB to complete to know the extent of the damage.
Yet the DBCC doesn't return any errors :ermm:
October 3, 2014 at 3:16 pm
SQL logs an entry in suspect pages when it finds a corrupt page. In your case, that happened on the 11th of last month and SQL only found an error on that page once. It was probably fixed very soon afterwards, otherwise the error_count would be a lot higher.
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
October 3, 2014 at 4:17 pm
GilaMonster (10/3/2014)
SQL logs an entry in suspect pages when it finds a corrupt page. In your case, that happened on the 11th of last month and SQL only found an error on that page once. It was probably fixed very soon afterwards, otherwise the error_count would be a lot higher.
That all makes sense, but why would the event type ID not update to 4 or 5 after repair?
Restored (The page was restored after it was marked bad) - 4
Repaired (DBCC repaired the page) - 5
October 4, 2014 at 3:59 am
Maybe it wasn't actually repaired, just deallocated by something like an index rebuild.
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply