July 8, 2014 at 5:48 am
As far as i know sys.dm_db_index_usage_stats should have one record per table and index but in one of my server this count is mismTHIS IS CLEARLY SPAMans this DMV doesn't have records for every index/table.
there was issue in sql 2005 which can be resolved by trace flag 2330 but i think this has been fixed in sql 2008
i am using sql 2008 but still i can see same issue.
Another question is , if i do dbcc traceon (2330,-1) , does it "STOP" to gather the information OR "START" to gather the information ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
July 8, 2014 at 5:59 am
As far as i know sys.dm_db_index_usage_stats should have one record per table and index
No. It has one row for each index which has been used since SQL last started. If an index has not been used in any way since SQL last started, it will have no row in that DMV.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 8, 2014 at 6:03 am
thanks a lot Gail
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply