Using dbcc checktable

If the log segment is on its own device, running dbcc checktable on the syslogs table reports the logs used and free space.

For example:
Checking syslogs 
The total number of data pages in this table is 1. 
*** NOTICE: Space used on the log segment is 0.20 Mbytes, 0.13%. 
*** NOTICE: Space free on the log segment is 153.4 Mbytes, 99.87%.DBCC execution completed.  If dbcc printed error messages, see your system administrator.
If the log segment is not on its own device, the following message appears:
*** NOTICE:  Notification of log space used/free cannot be reported because the log segment is not on its own device.
In addition to the regular checks it performs, checktable verifies that the preallocation performed during table creation is correct:

  • The number of pages preallocated matches the total number of data pages that must be allocated for the specified max hash key value.

  • The data pages are not preallocated in an extent where the preallocation scheme specifies that only object allocation map (OAM) pages are allowed.

  • The OAM pages are allocated only in the first extent of an allocation unit.

Parent topic: dbcc