Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 dm_db_index_physical_stats Bug?

Author  Topic 

szewczykm
Starting Member

1 Post

Posted - 2013-11-05 : 14:11:07
I'm looking at the output that I'm getting from sys.dm_db_index_physical_stats and I've added a where clause to show me only indexes that are fragmented more than 50%.

The odd thing is, I'm being returned table names and indexes that don't seem to exist. I look at the database ID and go to that DB and I don't find that table. Am I looking at this wrong?

The index type is a Clustered Index. The table name looks like it fits in the purpose of the database, but looking at the database it's not there.

Thanks!

Mike
   

- Advertisement -