Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sys.dm_db_index_physical_stats Expand / Collapse
Author
Message
Posted Monday, November 23, 2009 9:55 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 8:31 AM
Points: 236, Visits: 934
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
Posted Monday, November 23, 2009 10:05 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 5:18 PM
Points: 23,397, Visits: 32,245
You are probably looking in the wrong place. It isn't a system view, it is a system TVF.



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
Posted Monday, November 23, 2009 10:09 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 8:31 AM
Points: 236, Visits: 934
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
Posted Monday, November 23, 2009 10:15 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 5:18 PM
Points: 23,397, Visits: 32,245
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.



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 #823372
Posted Monday, November 23, 2009 10:34 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 8:31 AM
Points: 236, Visits: 934
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
Posted Monday, November 23, 2009 12:28 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 4:28 PM
Points: 43,028, Visits: 36,193
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 »

Add to briefcase

Permissions Expand / Collapse