sys.dm_db_index_physical

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » T-SQL (SS2K5) » sys.dm_db_index_physical_stats

sys.dm_db_index_physical_stats

Rate Topic

Display Mode

Topic Options

Author

Message

hydbadrose

Posted Monday, November 23, 2009 9:55 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, June 14, 2013 10:21 AM
Points: 227, Visits: 864

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

Post #823357

Lynn Pettis

Posted Monday, November 23, 2009 10:05 AM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 9:46 AM
Points: 21,832, Visits: 27,858

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

Cool

Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #823361

hydbadrose

Posted Monday, November 23, 2009 10:09 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, June 14, 2013 10:21 AM
Points: 227, Visits: 864

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.

Post #823365

Lynn Pettis

Posted Monday, November 23, 2009 10:15 AM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 9:46 AM
Points: 21,832, Visits: 27,858

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.

Cool

Lynn Pettis

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #823372

hydbadrose

Posted Monday, November 23, 2009 10:34 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, June 14, 2013 10:21 AM
Points: 227, Visits: 864

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

Post #823389

GilaMonster

Posted Monday, November 23, 2009 12:28 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 1:57 PM
Points: 38,093, Visits: 30,387

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 2008, MVP
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

Post #823456

« Prev Topic | Next Topic »

Permissions