DBCC checkdb for SQL Server database

DBCC CHECKDB

Generally in a very large database it's no feasible to run the check for complete database because it's a resource intensive, so we different option to check the health.


Command-1:

DBCC CHECKDB ('AdventureWorks2012')

Output:

DBCC results for 'AdventureWorks2012'.
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 1754 rows in 21 pages for object "sys.sysrscols".
DBCC results for 'sys.sysrowsets'.
There are 324 rows in 3 pages for object "sys.sysrowsets".
DBCC results for 'sys.sysclones'.
There are 0 rows in 0 pages for object "sys.sysclones".
DBCC results for 'sys.sysallocunits'.
There are 368 rows in 5 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.sysseobjvalues'.
There are 0 rows in 0 pages for object "sys.sysseobjvalues".
DBCC results for 'sys.syspriorities'.
There are 0 rows in 0 pages for object "sys.syspriorities".
DBCC results for 'sys.sysdbfrag'.
There are 0 rows in 0 pages for object "sys.sysdbfrag".
DBCC results for 'sys.sysfgfrag'.
There are 0 rows in 0 pages for object "sys.sysfgfrag".
DBCC results for 'sys.sysdbfiles'.
There are 2 rows in 1 pages for object "sys.sysdbfiles".
DBCC results for 'sys.syspru'.
There are 0 rows in 0 pages for object "sys.syspru".
DBCC results for 'sys.sysbrickfiles'.
There are 0 rows in 0 pages for object "sys.sysbrickfiles".
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 3 rows in 1 pages for object "sys.sysftinds".
DBCC results for 'sys.sysowners'.
There are 15 rows in 1 pages for object "sys.sysowners".
DBCC results for 'sys.sysdbreg'.
There are 0 rows in 0 pages for object "sys.sysdbreg".
DBCC results for 'sys.sysprivs'.
There are 139 rows in 1 pages for object "sys.sysprivs".
DBCC results for 'sys.sysschobjs'.
There are 2735 rows in 48 pages for object "sys.sysschobjs".
DBCC results for 'sys.syscolpars'.
There are 1622 rows in 28 pages for object "sys.syscolpars".
DBCC results for 'sys.sysxlgns'.
There are 0 rows in 0 pages for object "sys.sysxlgns".
DBCC results for 'sys.sysxsrvs'.
There are 0 rows in 0 pages for object "sys.sysxsrvs".
DBCC results for 'sys.sysnsobjs'.
There are 7 rows in 1 pages for object "sys.sysnsobjs".
DBCC results for 'sys.sysusermsgs'.
There are 0 rows in 0 pages for object "sys.sysusermsgs".
DBCC results for 'sys.syscerts'.
There are 0 rows in 0 pages for object "sys.syscerts".
DBCC results for 'sys.sysrmtlgns'.
There are 0 rows in 0 pages for object "sys.sysrmtlgns".
DBCC results for 'sys.syslnklgns'.
There are 0 rows in 0 pages for object "sys.syslnklgns".
DBCC results for 'sys.sysxprops'.
There are 1231 rows in 42 pages for object "sys.sysxprops".
DBCC results for 'sys.sysscalartypes'.
There are 40 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 459 rows in 10 pages for object "sys.sysidxstats".
DBCC results for 'sys.sysiscols'.
There are 733 rows in 5 pages for object "sys.sysiscols".
DBCC results for 'sys.sysendpts'.
There are 0 rows in 0 pages for object "sys.sysendpts".
DBCC results for 'sys.syswebmethods'.
There are 0 rows in 0 pages for object "sys.syswebmethods".
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 776 rows in 154 pages for object "sys.sysobjvalues".
DBCC results for 'sys.syscscolsegments'.
There are 0 rows in 0 pages for object "sys.syscscolsegments".
DBCC results for 'sys.syscsdictionaries'.
There are 0 rows in 0 pages for object "sys.syscsdictionaries".
DBCC results for 'sys.sysclsobjs'.
There are 22 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 857 rows in 5 pages for object "sys.syssingleobjrefs".
DBCC results for 'sys.sysmultiobjrefs'.
There are 862 rows in 6 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.sysfoqueues'.
There are 0 rows in 0 pages for object "sys.sysfoqueues".
DBCC results for 'sys.syschildinsts'.
There are 0 rows in 0 pages for object "sys.syschildinsts".
DBCC results for 'sys.syscompfragments'.
There are 3 rows in 1 pages for object "sys.syscompfragments".
DBCC results for 'sys.sysftsemanticsdb'.
There are 0 rows in 0 pages for object "sys.sysftsemanticsdb".
DBCC results for 'sys.sysftstops'.
There are 0 rows in 0 pages for object "sys.sysftstops".
DBCC results for 'sys.sysftproperties'.
There are 0 rows in 0 pages for object "sys.sysftproperties".
DBCC results for 'sys.sysxmitbody'.
There are 0 rows in 0 pages for object "sys.sysxmitbody".
DBCC results for 'sys.sysfos'.
There are 0 rows in 0 pages for object "sys.sysfos".
DBCC results for 'sys.sysqnames'.
There are 363 rows in 4 pages for object "sys.sysqnames".
DBCC results for 'sys.sysxmlcomponent'.
There are 315 rows in 2 pages for object "sys.sysxmlcomponent".
DBCC results for 'sys.sysxmlfacet'.
There are 145 rows in 1 pages for object "sys.sysxmlfacet".
DBCC results for 'sys.sysxmlplacement'.
There are 322 rows in 2 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 165 rows in 2 pages for object "sys.syssoftobjrefs".
DBCC results for 'sys.xml_index_nodes_1765581328_256000'.
There are 195 rows in 3 pages for object "sys.xml_index_nodes_1765581328_256000".
DBCC results for 'Production.ScrapReason'.
There are 16 rows in 1 pages for object "Production.ScrapReason".
DBCC results for 'sys.xml_index_nodes_1765581328_256001'.
There are 301696 rows in 2152 pages for object "sys.xml_index_nodes_1765581328_256001".
DBCC results for 'sys.xml_index_nodes_526624919_256000'.
There are 9113 rows in 64 pages for object "sys.xml_index_nodes_526624919_256000".
DBCC results for 'HumanResources.Shift'.
There are 3 rows in 1 pages for object "HumanResources.Shift".
DBCC results for 'sys.xml_index_nodes_418100530_256000'.
There are 350 rows in 5 pages for object "sys.xml_index_nodes_418100530_256000".
DBCC results for 'Production.ProductCategory'.
There are 4 rows in 1 pages for object "Production.ProductCategory".
DBCC results for 'sys.xml_index_nodes_418100530_256001'.
There are 650 rows in 12 pages for object "sys.xml_index_nodes_418100530_256001".
DBCC results for 'Purchasing.ShipMethod'.
There are 5 rows in 1 pages for object "Purchasing.ShipMethod".
DBCC results for 'sys.fulltext_index_docidstatus_610101214'.
There are 0 rows in 0 pages for object "sys.fulltext_index_docidstatus_610101214".
DBCC results for 'sys.fulltext_docidfilter_610101214'.
There are 0 rows in 0 pages for object "sys.fulltext_docidfilter_610101214".
DBCC results for 'Production.ProductCostHistory'.
There are 395 rows in 3 pages for object "Production.ProductCostHistory".
DBCC results for 'sys.fulltext_indexeddocid_610101214'.
There are 4 rows in 1 pages for object "sys.fulltext_indexeddocid_610101214".
DBCC results for 'sys.fulltext_avdl_610101214'.
There are 3 rows in 1 pages for object "sys.fulltext_avdl_610101214".
DBCC results for 'sys.fulltext_index_docidstatus_1589580701'.
There are 0 rows in 0 pages for object "sys.fulltext_index_docidstatus_1589580701".
DBCC results for 'sys.fulltext_docidfilter_1589580701'.
There are 0 rows in 0 pages for object "sys.fulltext_docidfilter_1589580701".
DBCC results for 'Production.ProductDescription'.
There are 762 rows in 18 pages for object "Production.ProductDescription".
DBCC results for 'sys.fulltext_indexeddocid_1589580701'.
There are 13 rows in 1 pages for object "sys.fulltext_indexeddocid_1589580701".
DBCC results for 'Sales.ShoppingCartItem'.
There are 3 rows in 1 pages for object "Sales.ShoppingCartItem".
DBCC results for 'sys.fulltext_avdl_1589580701'.
There are 3 rows in 1 pages for object "sys.fulltext_avdl_1589580701".
DBCC results for 'sys.fulltext_index_docidmap_1077578877'.
There are 13 rows in 1 pages for object "sys.fulltext_index_docidmap_1077578877".
DBCC results for 'Production.ProductDocument'.
There are 32 rows in 1 pages for object "Production.ProductDocument".
DBCC results for 'sys.fulltext_index_docidstatus_1077578877'.
There are 0 rows in 0 pages for object "sys.fulltext_index_docidstatus_1077578877".
DBCC results for 'DatabaseLog'.
There are 1596 rows in 783 pages for object "DatabaseLog".
DBCC results for 'sys.fulltext_docidfilter_1077578877'.
There are 0 rows in 0 pages for object "sys.fulltext_docidfilter_1077578877".
DBCC results for 'Production.ProductInventory'.
There are 1069 rows in 7 pages for object "Production.ProductInventory".
DBCC results for 'sys.fulltext_indexeddocid_1077578877'.
There are 13 rows in 1 pages for object "sys.fulltext_indexeddocid_1077578877".
DBCC results for 'Sales.SpecialOffer'.
There are 16 rows in 1 pages for object "Sales.SpecialOffer".
DBCC results for 'ErrorLog'.
There are 0 rows in 0 pages for object "ErrorLog".
DBCC results for 'sys.fulltext_avdl_1077578877'.
There are 5 rows in 1 pages for object "sys.fulltext_avdl_1077578877".
DBCC results for 'Production.ProductListPriceHistory'.
There are 395 rows in 3 pages for object "Production.ProductListPriceHistory".
DBCC results for 'Person.Address'.
There are 19614 rows in 344 pages for object "Person.Address".
DBCC results for 'Sales.SpecialOfferProduct'.
There are 538 rows in 3 pages for object "Sales.SpecialOfferProduct".
DBCC results for 'Production.ProductModel'.
There are 128 rows in 12 pages for object "Production.ProductModel".
DBCC results for 'Person.AddressType'.
There are 6 rows in 1 pages for object "Person.AddressType".
DBCC results for 'Person.StateProvince'.
There are 181 rows in 2 pages for object "Person.StateProvince".
DBCC results for 'Production.ProductModelIllustration'.
There are 7 rows in 1 pages for object "Production.ProductModelIllustration".
DBCC results for 'AWBuildVersion'.
There are 1 rows in 1 pages for object "AWBuildVersion".
DBCC results for 'Production.ProductModelProductDescriptionCulture'.
There are 762 rows in 4 pages for object "Production.ProductModelProductDescriptionCulture".
DBCC results for 'Production.BillOfMaterials'.
There are 2679 rows in 20 pages for object "Production.BillOfMaterials".
DBCC results for 'sys.ifts_comp_fragment_610101214_4'.
There are 351 rows in 2 pages for object "sys.ifts_comp_fragment_610101214_4".
DBCC results for 'sys.ifts_comp_fragment_1589580701_5'.
There are 1324 rows in 9 pages for object "sys.ifts_comp_fragment_1589580701_5".
DBCC results for 'Sales.Store'.
There are 701 rows in 101 pages for object "Sales.Store".
DBCC results for 'Production.ProductPhoto'.
There are 101 rows in 50 pages for object "Production.ProductPhoto".
DBCC results for 'sys.ifts_comp_fragment_1077578877_3'.
There are 524 rows in 3 pages for object "sys.ifts_comp_fragment_1077578877_3".
DBCC results for 'Production.ProductProductPhoto'.
There are 504 rows in 2 pages for object "Production.ProductProductPhoto".
DBCC results for 'Production.TransactionHistory'.
There are 113443 rows in 792 pages for object "Production.TransactionHistory".
DBCC results for 'Production.ProductReview'.
There are 4 rows in 2 pages for object "Production.ProductReview".
DBCC results for 'Person.BusinessEntity'.
There are 20777 rows in 96 pages for object "Person.BusinessEntity".
DBCC results for 'Production.TransactionHistoryArchive'.
There are 89253 rows in 624 pages for object "Production.TransactionHistoryArchive".
DBCC results for 'Production.ProductSubcategory'.
There are 37 rows in 1 pages for object "Production.ProductSubcategory".
DBCC results for 'Person.BusinessEntityAddress'.
There are 19614 rows in 110 pages for object "Person.BusinessEntityAddress".
DBCC results for 'Purchasing.ProductVendor'.
There are 460 rows in 5 pages for object "Purchasing.ProductVendor".
DBCC results for 'Person.BusinessEntityContact'.
There are 909 rows in 6 pages for object "Person.BusinessEntityContact".
DBCC results for 'Production.UnitMeasure'.
There are 38 rows in 1 pages for object "Production.UnitMeasure".
DBCC results for 'Purchasing.Vendor'.
There are 104 rows in 2 pages for object "Purchasing.Vendor".
DBCC results for 'Person.ContactType'.
There are 20 rows in 1 pages for object "Person.ContactType".
DBCC results for 'Sales.CountryRegionCurrency'.
There are 109 rows in 1 pages for object "Sales.CountryRegionCurrency".
DBCC results for 'Person.CountryRegion'.
There are 238 rows in 2 pages for object "Person.CountryRegion".
DBCC results for 'Production.WorkOrder'.
There are 72591 rows in 528 pages for object "Production.WorkOrder".
DBCC results for 'Purchasing.PurchaseOrderDetail'.
There are 8845 rows in 64 pages for object "Purchasing.PurchaseOrderDetail".
DBCC results for 'Sales.CreditCard'.
There are 19118 rows in 187 pages for object "Sales.CreditCard".
DBCC results for 'Production.Culture'.
There are 8 rows in 1 pages for object "Production.Culture".
DBCC results for 'Production.WorkOrderRouting'.
There are 67131 rows in 696 pages for object "Production.WorkOrderRouting".
DBCC results for 'Sales.Currency'.
There are 105 rows in 1 pages for object "Sales.Currency".
DBCC results for 'Purchasing.PurchaseOrderHeader'.
There are 4012 rows in 42 pages for object "Purchasing.PurchaseOrderHeader".
DBCC results for 'Sales.CurrencyRate'.
There are 13532 rows in 96 pages for object "Sales.CurrencyRate".
DBCC results for 'Sales.Customer'.
There are 19820 rows in 121 pages for object "Sales.Customer".
DBCC results for 'HumanResources.Department'.
There are 16 rows in 1 pages for object "HumanResources.Department".
DBCC results for 'Production.Document'.
There are 13 rows in 1 pages for object "Production.Document".
DBCC results for 'Sales.SalesOrderDetail'.
There are 121317 rows in 1237 pages for object "Sales.SalesOrderDetail".
DBCC results for 'Person.EmailAddress'.
There are 19972 rows in 249 pages for object "Person.EmailAddress".
DBCC results for 'HumanResources.Employee'.
There are 290 rows in 7 pages for object "HumanResources.Employee".
DBCC results for 'Sales.SalesOrderHeader'.
There are 31465 rows in 685 pages for object "Sales.SalesOrderHeader".
DBCC results for 'HumanResources.EmployeeDepartmentHistory'.
There are 296 rows in 2 pages for object "HumanResources.EmployeeDepartmentHistory".
DBCC results for 'HumanResources.EmployeePayHistory'.
There are 316 rows in 2 pages for object "HumanResources.EmployeePayHistory".
DBCC results for 'Sales.SalesOrderHeaderSalesReason'.
There are 27647 rows in 86 pages for object "Sales.SalesOrderHeaderSalesReason".
DBCC results for 'Sales.SalesPerson'.
There are 17 rows in 1 pages for object "Sales.SalesPerson".
DBCC results for 'Production.Illustration'.
There are 5 rows in 1 pages for object "Production.Illustration".
DBCC results for 'HumanResources.JobCandidate'.
There are 13 rows in 11 pages for object "HumanResources.JobCandidate".
DBCC results for 'Production.Location'.
There are 14 rows in 1 pages for object "Production.Location".
DBCC results for 'Person.Password'.
There are 19972 rows in 235 pages for object "Person.Password".
DBCC results for 'Sales.SalesPersonQuotaHistory'.
There are 163 rows in 2 pages for object "Sales.SalesPersonQuotaHistory".
DBCC results for 'Person.Person'.
There are 19972 rows in 3809 pages for object "Person.Person".
DBCC results for 'Sales.SalesReason'.
There are 10 rows in 1 pages for object "Sales.SalesReason".
DBCC results for 'Sales.SalesTaxRate'.
There are 29 rows in 1 pages for object "Sales.SalesTaxRate".
DBCC results for 'Sales.PersonCreditCard'.
There are 19118 rows in 60 pages for object "Sales.PersonCreditCard".
DBCC results for 'Person.PersonPhone'.
There are 19972 rows in 148 pages for object "Person.PersonPhone".
DBCC results for 'Sales.SalesTerritory'.
There are 10 rows in 1 pages for object "Sales.SalesTerritory".
DBCC results for 'Person.PhoneNumberType'.
There are 3 rows in 1 pages for object "Person.PhoneNumberType".
DBCC results for 'Production.Product'.
There are 504 rows in 13 pages for object "Production.Product".
DBCC results for 'sys.queue_messages_1977058079'.
There are 0 rows in 0 pages for object "sys.queue_messages_1977058079".
DBCC results for 'sys.queue_messages_2009058193'.
There are 0 rows in 0 pages for object "sys.queue_messages_2009058193".
DBCC results for 'Production.vProductAndDescription'.
There are 1764 rows in 70 pages for object "Production.vProductAndDescription".
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 'Sales.SalesTerritoryHistory'.
There are 17 rows in 1 pages for object "Sales.SalesTerritoryHistory".
DBCC results for 'sys.filetable_updates_2105058535'.
There are 0 rows in 0 pages for object "sys.filetable_updates_2105058535".
DBCC results for 'Person.vStateProvinceCountryRegion'.
There are 181 rows in 2 pages for object "Person.vStateProvinceCountryRegion".
CHECKDB found 0 allocation errors and 0 consistency errors in database 'AdventureWorks2012'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.  ---- no errors
Completion time: 2022-05-16T01:40:12.8027767+05:30

Command-2: To skip the non-clustered index and non-system tables

DBCC CHECKDB ('AdventureWorks2012', NOINDEX)

Output:

DBCC results for 'AdventureWorks2012'.
Warning: NO_INDEX option of checkdb being used. Checks on non-system indexes will be skipped.
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 1754 rows in 21 pages for object "sys.sysrscols".
DBCC results for 'sys.sysrowsets'.
There are 324 rows in 3 pages for object "sys.sysrowsets".
DBCC results for 'sys.sysclones'.
There are 0 rows in 0 pages for object "sys.sysclones".
DBCC results for 'sys.sysallocunits'.
There are 368 rows in 5 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.sysseobjvalues'.
There are 0 rows in 0 pages for object "sys.sysseobjvalues".
DBCC results for 'sys.syspriorities'.
There are 0 rows in 0 pages for object "sys.syspriorities".
DBCC results for 'sys.sysdbfrag'.
There are 0 rows in 0 pages for object "sys.sysdbfrag".
DBCC results for 'sys.sysfgfrag'.
There are 0 rows in 0 pages for object "sys.sysfgfrag".
DBCC results for 'sys.sysdbfiles'.
There are 2 rows in 1 pages for object "sys.sysdbfiles".
DBCC results for 'sys.syspru'.
There are 0 rows in 0 pages for object "sys.syspru".
DBCC results for 'sys.sysbrickfiles'.
There are 0 rows in 0 pages for object "sys.sysbrickfiles".
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 3 rows in 1 pages for object "sys.sysftinds".
DBCC results for 'sys.sysowners'.
There are 15 rows in 1 pages for object "sys.sysowners".
DBCC results for 'sys.sysdbreg'.
There are 0 rows in 0 pages for object "sys.sysdbreg".
DBCC results for 'sys.sysprivs'.
There are 139 rows in 1 pages for object "sys.sysprivs".
DBCC results for 'sys.sysschobjs'.
There are 2735 rows in 48 pages for object "sys.sysschobjs".
DBCC results for 'sys.syscolpars'.
There are 1622 rows in 28 pages for object "sys.syscolpars".
DBCC results for 'sys.sysxlgns'.
There are 0 rows in 0 pages for object "sys.sysxlgns".
DBCC results for 'sys.sysxsrvs'.
There are 0 rows in 0 pages for object "sys.sysxsrvs".
DBCC results for 'sys.sysnsobjs'.
There are 7 rows in 1 pages for object "sys.sysnsobjs".
DBCC results for 'sys.sysusermsgs'.
There are 0 rows in 0 pages for object "sys.sysusermsgs".
DBCC results for 'sys.syscerts'.
There are 0 rows in 0 pages for object "sys.syscerts".
DBCC results for 'sys.sysrmtlgns'.
There are 0 rows in 0 pages for object "sys.sysrmtlgns".
DBCC results for 'sys.syslnklgns'.
There are 0 rows in 0 pages for object "sys.syslnklgns".
DBCC results for 'sys.sysxprops'.
There are 1231 rows in 42 pages for object "sys.sysxprops".
DBCC results for 'sys.sysscalartypes'.
There are 40 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 459 rows in 10 pages for object "sys.sysidxstats".
DBCC results for 'sys.sysiscols'.
There are 733 rows in 5 pages for object "sys.sysiscols".
DBCC results for 'sys.sysendpts'.
There are 0 rows in 0 pages for object "sys.sysendpts".
DBCC results for 'sys.syswebmethods'.
There are 0 rows in 0 pages for object "sys.syswebmethods".
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 776 rows in 154 pages for object "sys.sysobjvalues".
DBCC results for 'sys.syscscolsegments'.
There are 0 rows in 0 pages for object "sys.syscscolsegments".
DBCC results for 'sys.syscsdictionaries'.
There are 0 rows in 0 pages for object "sys.syscsdictionaries".
DBCC results for 'sys.sysclsobjs'.
There are 22 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 857 rows in 5 pages for object "sys.syssingleobjrefs".
DBCC results for 'sys.sysmultiobjrefs'.
There are 862 rows in 6 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.sysfoqueues'.
There are 0 rows in 0 pages for object "sys.sysfoqueues".
DBCC results for 'sys.syschildinsts'.
There are 0 rows in 0 pages for object "sys.syschildinsts".
DBCC results for 'sys.syscompfragments'.
There are 3 rows in 1 pages for object "sys.syscompfragments".
DBCC results for 'sys.sysftsemanticsdb'.
There are 0 rows in 0 pages for object "sys.sysftsemanticsdb".
DBCC results for 'sys.sysftstops'.
There are 0 rows in 0 pages for object "sys.sysftstops".
DBCC results for 'sys.sysftproperties'.
There are 0 rows in 0 pages for object "sys.sysftproperties".
DBCC results for 'sys.sysxmitbody'.
There are 0 rows in 0 pages for object "sys.sysxmitbody".
DBCC results for 'sys.sysfos'.
There are 0 rows in 0 pages for object "sys.sysfos".
DBCC results for 'sys.sysqnames'.
There are 363 rows in 4 pages for object "sys.sysqnames".
DBCC results for 'sys.sysxmlcomponent'.
There are 315 rows in 2 pages for object "sys.sysxmlcomponent".
DBCC results for 'sys.sysxmlfacet'.
There are 145 rows in 1 pages for object "sys.sysxmlfacet".
DBCC results for 'sys.sysxmlplacement'.
There are 322 rows in 2 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 165 rows in 2 pages for object "sys.syssoftobjrefs".
DBCC results for 'sys.xml_index_nodes_1765581328_256000'.
There are 195 rows in 3 pages for object "sys.xml_index_nodes_1765581328_256000".
DBCC results for 'Production.ScrapReason'.
There are 16 rows in 1 pages for object "Production.ScrapReason".
DBCC results for 'sys.xml_index_nodes_1765581328_256001'.
There are 301696 rows in 2152 pages for object "sys.xml_index_nodes_1765581328_256001".
DBCC results for 'sys.xml_index_nodes_526624919_256000'.
There are 9113 rows in 64 pages for object "sys.xml_index_nodes_526624919_256000".
DBCC results for 'HumanResources.Shift'.
There are 3 rows in 1 pages for object "HumanResources.Shift".
DBCC results for 'sys.xml_index_nodes_418100530_256000'.
There are 350 rows in 5 pages for object "sys.xml_index_nodes_418100530_256000".
DBCC results for 'Production.ProductCategory'.
There are 4 rows in 1 pages for object "Production.ProductCategory".
DBCC results for 'sys.xml_index_nodes_418100530_256001'.
There are 650 rows in 12 pages for object "sys.xml_index_nodes_418100530_256001".
DBCC results for 'Purchasing.ShipMethod'.
There are 5 rows in 1 pages for object "Purchasing.ShipMethod".
DBCC results for 'sys.fulltext_index_docidstatus_610101214'.
There are 0 rows in 0 pages for object "sys.fulltext_index_docidstatus_610101214".
DBCC results for 'sys.fulltext_docidfilter_610101214'.
There are 0 rows in 0 pages for object "sys.fulltext_docidfilter_610101214".
DBCC results for 'Production.ProductCostHistory'.
There are 395 rows in 3 pages for object "Production.ProductCostHistory".
DBCC results for 'sys.fulltext_indexeddocid_610101214'.
There are 4 rows in 1 pages for object "sys.fulltext_indexeddocid_610101214".
DBCC results for 'sys.fulltext_avdl_610101214'.
There are 3 rows in 1 pages for object "sys.fulltext_avdl_610101214".
DBCC results for 'sys.fulltext_index_docidstatus_1589580701'.
There are 0 rows in 0 pages for object "sys.fulltext_index_docidstatus_1589580701".
DBCC results for 'sys.fulltext_docidfilter_1589580701'.
There are 0 rows in 0 pages for object "sys.fulltext_docidfilter_1589580701".
DBCC results for 'Production.ProductDescription'.
There are 762 rows in 18 pages for object "Production.ProductDescription".
DBCC results for 'sys.fulltext_indexeddocid_1589580701'.
There are 13 rows in 1 pages for object "sys.fulltext_indexeddocid_1589580701".
DBCC results for 'Sales.ShoppingCartItem'.
There are 3 rows in 1 pages for object "Sales.ShoppingCartItem".
DBCC results for 'sys.fulltext_avdl_1589580701'.
There are 3 rows in 1 pages for object "sys.fulltext_avdl_1589580701".
DBCC results for 'sys.fulltext_index_docidmap_1077578877'.
There are 13 rows in 1 pages for object "sys.fulltext_index_docidmap_1077578877".
DBCC results for 'Production.ProductDocument'.
There are 32 rows in 1 pages for object "Production.ProductDocument".
DBCC results for 'sys.fulltext_index_docidstatus_1077578877'.
There are 0 rows in 0 pages for object "sys.fulltext_index_docidstatus_1077578877".
DBCC results for 'DatabaseLog'.
There are 1596 rows in 783 pages for object "DatabaseLog".
DBCC results for 'sys.fulltext_docidfilter_1077578877'.
There are 0 rows in 0 pages for object "sys.fulltext_docidfilter_1077578877".
DBCC results for 'Production.ProductInventory'.
There are 1069 rows in 7 pages for object "Production.ProductInventory".
DBCC results for 'sys.fulltext_indexeddocid_1077578877'.
There are 13 rows in 1 pages for object "sys.fulltext_indexeddocid_1077578877".
DBCC results for 'Sales.SpecialOffer'.
There are 16 rows in 1 pages for object "Sales.SpecialOffer".
DBCC results for 'ErrorLog'.
There are 0 rows in 0 pages for object "ErrorLog".
DBCC results for 'sys.fulltext_avdl_1077578877'.
There are 5 rows in 1 pages for object "sys.fulltext_avdl_1077578877".
DBCC results for 'Production.ProductListPriceHistory'.
There are 395 rows in 3 pages for object "Production.ProductListPriceHistory".
DBCC results for 'Person.Address'.
There are 19614 rows in 344 pages for object "Person.Address".
DBCC results for 'Sales.SpecialOfferProduct'.
There are 538 rows in 3 pages for object "Sales.SpecialOfferProduct".
DBCC results for 'Production.ProductModel'.
There are 128 rows in 12 pages for object "Production.ProductModel".
DBCC results for 'Person.AddressType'.
There are 6 rows in 1 pages for object "Person.AddressType".
DBCC results for 'Person.StateProvince'.
There are 181 rows in 2 pages for object "Person.StateProvince".
DBCC results for 'Production.ProductModelIllustration'.
There are 7 rows in 1 pages for object "Production.ProductModelIllustration".
DBCC results for 'AWBuildVersion'.
There are 1 rows in 1 pages for object "AWBuildVersion".
DBCC results for 'Production.ProductModelProductDescriptionCulture'.
There are 762 rows in 4 pages for object "Production.ProductModelProductDescriptionCulture".
DBCC results for 'Production.BillOfMaterials'.
There are 2679 rows in 20 pages for object "Production.BillOfMaterials".
DBCC results for 'sys.ifts_comp_fragment_610101214_4'.
There are 351 rows in 2 pages for object "sys.ifts_comp_fragment_610101214_4".
DBCC results for 'sys.ifts_comp_fragment_1589580701_5'.
There are 1324 rows in 9 pages for object "sys.ifts_comp_fragment_1589580701_5".
DBCC results for 'Sales.Store'.
There are 701 rows in 101 pages for object "Sales.Store".
DBCC results for 'Production.ProductPhoto'.
There are 101 rows in 50 pages for object "Production.ProductPhoto".
DBCC results for 'sys.ifts_comp_fragment_1077578877_3'.
There are 524 rows in 3 pages for object "sys.ifts_comp_fragment_1077578877_3".
DBCC results for 'Production.ProductProductPhoto'.
There are 504 rows in 2 pages for object "Production.ProductProductPhoto".
DBCC results for 'Production.TransactionHistory'.
There are 113443 rows in 792 pages for object "Production.TransactionHistory".
DBCC results for 'Production.ProductReview'.
There are 4 rows in 2 pages for object "Production.ProductReview".
DBCC results for 'Person.BusinessEntity'.
There are 20777 rows in 96 pages for object "Person.BusinessEntity".
DBCC results for 'Production.TransactionHistoryArchive'.
There are 89253 rows in 624 pages for object "Production.TransactionHistoryArchive".
DBCC results for 'Production.ProductSubcategory'.
There are 37 rows in 1 pages for object "Production.ProductSubcategory".
DBCC results for 'Person.BusinessEntityAddress'.
There are 19614 rows in 110 pages for object "Person.BusinessEntityAddress".
DBCC results for 'Purchasing.ProductVendor'.
There are 460 rows in 5 pages for object "Purchasing.ProductVendor".
DBCC results for 'Person.BusinessEntityContact'.
There are 909 rows in 6 pages for object "Person.BusinessEntityContact".
DBCC results for 'Production.UnitMeasure'.
There are 38 rows in 1 pages for object "Production.UnitMeasure".
DBCC results for 'Purchasing.Vendor'.
There are 104 rows in 2 pages for object "Purchasing.Vendor".
DBCC results for 'Person.ContactType'.
There are 20 rows in 1 pages for object "Person.ContactType".
DBCC results for 'Sales.CountryRegionCurrency'.
There are 109 rows in 1 pages for object "Sales.CountryRegionCurrency".
DBCC results for 'Person.CountryRegion'.
There are 238 rows in 2 pages for object "Person.CountryRegion".
DBCC results for 'Production.WorkOrder'.
There are 72591 rows in 528 pages for object "Production.WorkOrder".
DBCC results for 'Purchasing.PurchaseOrderDetail'.
There are 8845 rows in 64 pages for object "Purchasing.PurchaseOrderDetail".
DBCC results for 'Sales.CreditCard'.
There are 19118 rows in 187 pages for object "Sales.CreditCard".
DBCC results for 'Production.Culture'.
There are 8 rows in 1 pages for object "Production.Culture".
DBCC results for 'Production.WorkOrderRouting'.
There are 67131 rows in 696 pages for object "Production.WorkOrderRouting".
DBCC results for 'Sales.Currency'.
There are 105 rows in 1 pages for object "Sales.Currency".
DBCC results for 'Purchasing.PurchaseOrderHeader'.
There are 4012 rows in 42 pages for object "Purchasing.PurchaseOrderHeader".
DBCC results for 'Sales.CurrencyRate'.
There are 13532 rows in 96 pages for object "Sales.CurrencyRate".
DBCC results for 'Sales.Customer'.
There are 19820 rows in 121 pages for object "Sales.Customer".
DBCC results for 'HumanResources.Department'.
There are 16 rows in 1 pages for object "HumanResources.Department".
DBCC results for 'Production.Document'.
There are 13 rows in 1 pages for object "Production.Document".
DBCC results for 'Sales.SalesOrderDetail'.
There are 121317 rows in 1237 pages for object "Sales.SalesOrderDetail".
DBCC results for 'Person.EmailAddress'.
There are 19972 rows in 249 pages for object "Person.EmailAddress".
DBCC results for 'HumanResources.Employee'.
There are 290 rows in 7 pages for object "HumanResources.Employee".
DBCC results for 'Sales.SalesOrderHeader'.
There are 31465 rows in 685 pages for object "Sales.SalesOrderHeader".
DBCC results for 'HumanResources.EmployeeDepartmentHistory'.
There are 296 rows in 2 pages for object "HumanResources.EmployeeDepartmentHistory".
DBCC results for 'HumanResources.EmployeePayHistory'.
There are 316 rows in 2 pages for object "HumanResources.EmployeePayHistory".
DBCC results for 'Sales.SalesOrderHeaderSalesReason'.
There are 27647 rows in 86 pages for object "Sales.SalesOrderHeaderSalesReason".
DBCC results for 'Sales.SalesPerson'.
There are 17 rows in 1 pages for object "Sales.SalesPerson".
DBCC results for 'Production.Illustration'.
There are 5 rows in 1 pages for object "Production.Illustration".
DBCC results for 'HumanResources.JobCandidate'.
There are 13 rows in 11 pages for object "HumanResources.JobCandidate".
DBCC results for 'Production.Location'.
There are 14 rows in 1 pages for object "Production.Location".
DBCC results for 'Person.Password'.
There are 19972 rows in 235 pages for object "Person.Password".
DBCC results for 'Sales.SalesPersonQuotaHistory'.
There are 163 rows in 2 pages for object "Sales.SalesPersonQuotaHistory".
DBCC results for 'Person.Person'.
There are 19972 rows in 3809 pages for object "Person.Person".
DBCC results for 'Sales.SalesReason'.
There are 10 rows in 1 pages for object "Sales.SalesReason".
DBCC results for 'Sales.SalesTaxRate'.
There are 29 rows in 1 pages for object "Sales.SalesTaxRate".
DBCC results for 'Sales.PersonCreditCard'.
There are 19118 rows in 60 pages for object "Sales.PersonCreditCard".
DBCC results for 'Person.PersonPhone'.
There are 19972 rows in 148 pages for object "Person.PersonPhone".
DBCC results for 'Sales.SalesTerritory'.
There are 10 rows in 1 pages for object "Sales.SalesTerritory".
DBCC results for 'Person.PhoneNumberType'.
There are 3 rows in 1 pages for object "Person.PhoneNumberType".
DBCC results for 'Production.Product'.
There are 504 rows in 13 pages for object "Production.Product".
DBCC results for 'sys.queue_messages_1977058079'.
There are 0 rows in 0 pages for object "sys.queue_messages_1977058079".
DBCC results for 'sys.queue_messages_2009058193'.
There are 0 rows in 0 pages for object "sys.queue_messages_2009058193".
DBCC results for 'Production.vProductAndDescription'.
There are 1764 rows in 70 pages for object "Production.vProductAndDescription".
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 'Sales.SalesTerritoryHistory'.
There are 17 rows in 1 pages for object "Sales.SalesTerritoryHistory".
DBCC results for 'sys.filetable_updates_2105058535'.
There are 0 rows in 0 pages for object "sys.filetable_updates_2105058535".
DBCC results for 'Person.vStateProvinceCountryRegion'.
There are 181 rows in 2 pages for object "Person.vStateProvinceCountryRegion".
CHECKDB found 0 allocation errors and 0 consistency errors in database 'AdventureWorks2012'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Completion time: 2022-05-16T01:51:46.0634374+05:30


If you would like to check the estimation for your database migration, you could run the below command:

DBCC CHECKDB ('AdventureWorks2012') WITH ESTIMATEONLY


Output:

DBCC results for 'AdventureWorks2012'.
Estimated TEMPDB space (in KB) needed for CHECKDB on database AdventureWorks2012 = 229155.
CHECKDB found 0 allocation errors and 0 consistency errors in database 'AdventureWorks2012'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Completion time: 2022-05-16T01:53:56.8138360+05:30






Comments

Post a Comment

Popular posts from this blog

Auditing in Oracle database

Unified Auditing: Oracle Database 12c Release 1 introduces a new auditing feature called Unified Auditing (12.1). Oracle Unified Auditing modifies the database's fundamental auditing capabilities. In earlier versions of Oracle, each component has its own audit trail. With unified auditing, all auditing is compiled into a single repository and view. Due to the fact that all audit data is now in a single location and a single format, there is a double simplification as a result. This data is made available in a consistent format in the UNIFIED AUDIT TRAIL data dictionary view, which is made possible by the unified audit trail, which is stored in a read-only table in the AUDSYS schema in the SYSAUX tablespace.  DBAs can build audit rules and then assign them to various users using Oracle 12c Unified Auditing, which has the same advantages as giving users varying system capabilities based on their responsibilities. The unified_audit_trail database will contain all of the audit records....
Read more

rs.stepDown() in MongoDB replication

It instructs the primary of the replica set to become a secondary. After the primary steps down,the eligible secondaries will hold an election for primary. Generally, the rs.stepDown() does not immediately step down the primary. If no electable secondaries are up to date with the primary, the primary waits up to secondaryCatchUpPeriodSecs (by default 10 seconds)  for a secondary to catch up. Once an electable secondary is available, the method steps down the priamry.  Once stepped down, the original primary becomes a secondary and is ineligible from becoming primary again for the remainder of time specified by stepDownSecs. The rs.stepDown() method attempts to terminate long-running user's operations that block the primary from stepping down, such as an index build, a write operation, or a map-reduce job. Syntax: rs.stepDown(stepDownSecs, secondaryCatchUpPeriodSecs)
Read more

Tuples in Python

 Tuples Basically Tuples in Python are very similar to Lists, but, Tuples are immutable which means that they can not be modified/changed. We generally use Tuples to make sure the values are not changed like, dates, Year, and days of the week or dates on a Calendar.  Creating a Tuple: >>> my_t1=(1,2,3) >>> my_t2=('one','two','three') >>> my_t1 (1, 2, 3) >>> my_t2 ('one', 'two', 'three') -- check the length of tupple: >>> len(my_t1) 3 >>> len(my_t2) 3 -- Tuples can have mixed objects as like Lists. >>> my_t3=(1,'two',3,'four') >>> my_t3 (1, 'two', 3, 'four') -- indexing with tuples  >>> my_t3=(1,'two',3,'four') >>> my_t3[2] 3 Immutable Tuples We can not modify the value. Here is the example: >>> my_t3=(1,'two',3,'four') >>> my_t3[2]=4 Traceback (most recent call last):  ...
Read more