Chapter 4: dbcc Stored Procedures

sp_dbcc_differentialreport

Description

Generates a report that highlights the changes in I/O statistics and faults that took place between two dbcc operations.

Syntax

sp_dbcc_differentialreport [dbname [, objectname]], 
	[db_op] [, "date1" [, "date2"]]

Parameters

dbname: specifies the name of the database. If you do not specify a dbname, the report contains information on all databases in dbccdb..dbcc_operation_log.

objectname: specifies the name of the table or index for which you want the report generated. If object_name is not specified, statistics on all objects in the target database are reported.

db_op: specifies the source of the data to be used for the report. The only value is checkstorage. The report is generated on the data specified by db_op on date1 and date2 for the specified object in the target database. If dates are not specified, the last two operations of the type db_op are compared.

date1: specifies the first date of a dbcc checkstorage operation to be compared.

date2: specifies the last date of a dbcc checkstorage operation to be compared.

Examples

Example 1

Generates a report that shows the changes in I/O statistics and faults that occurred in the sysprocedures table between May 1, 1997 and May 4, 1997:

sp_dbcc_differentialreport master, sysprocedures, 
    checkstorage, "05/01/97", "05/04/97"

Usage

sp_dbcc_differentialreport generates a report that highlights the changes in I/O statistics and faults that occurred between two dbcc operations. It compares counter values reported from two instances of dbcc checkstorage. Only the values that have been changed are reported.
If only one date is specified, the results of the dbcc checkstorage operation selected by the specified date are compared to the results of the dbcc checkstorage operation immediately preceding the selected operation.
If no dates are specified, the results of last two dbcc checkstorage operations are compared.
If sp_dbcc_differentialreport returns a number for object_name, it means the object was dropped after the dbcc checkstorage operation completed.
If no changes occurred between the specified operations, sp_dbcc_differentialreport does not generate a report.

Permissions

Any valid user for the database name specified can run sp_dbcc_differentialreport.