Viewing 5 posts - 1 through 5 (of 5 total)
Marios Philippopoulos (6/2/2008)
What I’ve found in large production systems is that you cannot guarantee that data on every index is held in the dmvs...
June 2, 2008 at 4:32 pm
Marios Philippopoulos (6/2/2008)
You may well have stumbled on a bug here -I will do some more searching on the web for similar info.
I find it hard to believe that...
June 2, 2008 at 3:05 pm
Marios Philippopoulos (6/2/2008)
I think sys.dm_db_index_usage_stats is sensitive ONLY to index operations in the WHERE clause:eg. index operations taking place in a JOIN are not counted.
Even more reason they should...
June 2, 2008 at 2:54 pm
Marios Philippopoulos (6/2/2008)
Stress (6/2/2008)
I have seen lots of examples on the 2005 index usages DMV, but one thing has eluded me : it only seems shows access stats for...
June 2, 2008 at 2:40 pm
Hi.
I have seen lots of examples on the 2005 index usages DMV, but one thing has eluded me : it only seems shows access stats for the dbo. How...
June 2, 2008 at 2:17 pm
Viewing 5 posts - 1 through 5 (of 5 total)