LinkedIn | FaceBook | Twitter
I know – I skipped one report, the one entitled Object Execution Statistics [DatabaseName], but I type these entries in on the bus ride to work in the mornings, and I need to do some setup for that one! I’ll catch it next when I’m in office on a “proper” system.
This report shows information about the DBCC commands you’ve run on your database. The DBCC commands are integral to your database maintenance, because it checks the database for consistency at the physical and logical levels. If you want more information about that, check here.
Even if you haven’t run the DBCC commands, this report will likely have data in it from your Maintenance Plans (more on those here), since they do run the command. If you don’t see any info, you should be concerned!
The first band in the report groups the information by the DBCC Command:
I'm continuing my series on the Standard Reports in SQL Server Management Studio , and today we’re