sys.dm_db_index_physical_stats

  • The sys.dm_db_index_physical_stats is missing. I do not see this DMV in sql 2005 or Sql; 2008 server. What do you think is wrong? I want to find out the logical index fragmentation and this DMV is missing. Can some one please help? Thanks

  • You are probably looking in the wrong place. It isn't a system view, it is a system TVF.

  • IT should be in any system views. The other DMV's are there but this one. Please help me finding this Sys.dm_db_index_physical_stats dmv.

  • hydbadrose (11/23/2009)


    IT should be in any system views. The other DMV's are there but this one. Please help me finding this Sys.dm_db_index_physical_stats dmv.

    It isn't a VIEW, it is a FUNCTION. Look under Programmability.

    You will find it under system functions.

  • Thanks! The function name I had in caps and the system has in lowercase. When I drag and drop the function name it worked.

  • hydbadrose (11/23/2009)


    The function name I had in caps and the system has in lowercase.

    That'll only make a difference if you've installed the server with a case-sensitive collation.

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply