November 23, 2009 at 9:55 am
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
November 23, 2009 at 10:05 am
You are probably looking in the wrong place. It isn't a system view, it is a system TVF.
November 23, 2009 at 10:09 am
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.
November 23, 2009 at 10:15 am
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.
November 23, 2009 at 10:34 am
Thanks! The function name I had in caps and the system has in lowercase. When I drag and drop the function name it worked.
November 23, 2009 at 12:28 pm
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
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply