Loading ...
Sorry, an error occurred while loading the content.
 

Re: MUGH-SQLCON 1]How to find indexs are fragmented or not? 2]How to find tables are fragmented or not? 3]Is fragmentation of the tables and fragmentation of the indexes same or diffrent?

Expand Messages
  • sunil john
    for index defragmentation u have to check the dmv.. sys.dm_index_physical_stats Best Regards Sunil John ________________________________ From: SARADADEVI
    Message 1 of 2 , Jan 26, 2011
      for index defragmentation u have to check the dmv.. sys.dm_index_physical_stats

      Best Regards


      Sunil John




      ________________________________
      From: SARADADEVI <sv_39@...>
      To: sqlcon@yahoogroups.com
      Sent: Saturday, October 30, 2010 14:36:10
      Subject: MUGH-SQLCON 1]How to find indexs are fragmented or not? 2]How to find
      tables are fragmented or not? 3]Is fragmentation of the tables and fragmentation
      of the indexes same or diffrent?



      Hi All,

      1}Could you please tell me IS fragmentation of the tables and
      fragmentation of indexes is both are same or diffrent?

      2}How to generate report on current SALES DB health check in terms of the
      indexes?
      Need to know if the indexes are fragemented or not.for all indexes.

      3}How to generate a report on the fragmentation of the tables in ANY database.

      Thanks and Regards,
      Kishore

      [Non-text portions of this message have been removed]






      [Non-text portions of this message have been removed]
    Your message has been successfully submitted and would be delivered to recipients shortly.