capture compression statistics

capture compression statistics enables the monTableCompression monitoring table to begin capturing compression statistics.

Summary Information

Default value

0 (off)

Range of values

1 (on), 0 (off)

Status

Dynamic

Display level

10

Required role

System administrator

Configuration group

SQL Server Administration