Post reply

sp_estimate_data_compression_savings not showing any estimates

  • November 1, 2017 at 10:41 am

    #402639

    Hi, 

    I am trying to use sp_estimate_data_compression_savings to get the space estimates on SQL Server 2014 SP2 for using compression but it is showing 0 value in the size_with_requested_compression_settings (KB)column;

    EXEC sp_estimate_data_compression_savings 'dbo','productionhistory', null, NULL, NONE;
    EXEC sp_estimate_data_compression_savings 'dbo','productionhistory', null, NULL, ROW;
    EXEC sp_estimate_data_compression_savings 'dbo','productionhistory', null, NULL, PAGE;

    What could be the reason for this? Thanks

  • November 2, 2017 at 11:32 am

    #1966455

    Looks like the partition for the respective index_id has 0 rows in which case you would see 0 KB.
    Look for column 'rows' for the specific index_id and yourtable from sys.partitions. 
    You can get your object_id from sys.objects to refer the data in sys.partitions

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply