Display sys.dm_db_stats_properties per partition for incremental statistics - by Ola Hallengren

Status : 

 


22
0
Sign in
to vote
ID 797156 Comments
Status Closed Workarounds
Type Suggestion Repros 2
Opened 8/12/2013 12:38:57 PM
Access Restriction Public

Description

I think that the information in sys.dm_db_stats_properties should be displayed per partition for incremental statistics.

Some of the columns (like last_updated and modification_counter) is difficult to understand or don't give any meaning if you don’t display the information per partition.

It would also be very useful to be able to check the information in sys.dm_db_stats_properties per partition when you're manually updating statistics.
Sign in to post a comment.
Posted by Microsoft on 7/13/2016 at 4:35 PM
A new DMF sys.dm_db_incremental_stats_properties is introduced in SQL Server 2014 SP2 to expose information per-partition for incremental stats.
Posted by Blaž Dakskobler on 7/12/2016 at 11:22 PM
Has this been "fixed" in SQL 2014 SP2, via the new DMF sys.dm_db_incremental_stats_properties (https://support.microsoft.com/kb/3170114)?
Posted by Adam A. Sharp on 9/17/2014 at 4:51 PM
Is there an official word on this suggestion?