question

skpani avatar image
skpani asked

How to track modification counters in SQL 2005/08

Hi In SQL Server 2008 R2(SP2) onwards we have a DMV (sys.dm_db_stats_properties)to track the modification counters but in 2005 and 2008 how can I track this ?
sql-server-2008sql-server-2005dmv
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Tim avatar image
Tim answered
You upgrade to SQL 2008R2 SP2 or SQL 2012 SP1. Joking aside, most folks have been able to pull statistic information out of sysindexes. The DMF introduced in 2008R2 SP2 and SP1 for 2012 may contain information not otherwise available however from what I have read prior to sys.dm_db_stats_properties, sysindexes was used.
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

skpani avatar image skpani commented ·
@Tim one of my instance is of SQL 2008R2 SP2 and 2 is of SQL 2005 SP2.And I tried that DMV on SQL 2008R2. Anyway I got my answer.Thanks a lot..
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.