Some suggestions

Hi,

I think it may be useful in SQL Defrag:

1. To see index script when I see the fragmentation of this index. Now I need to use another tool to do it.

2. Databases refresh (button?)

3. Now SQL Defrag is SDI, but sometimes I need to see the state of 2 databases in the same time.

Regards,
Oleg.

  • Thank you for the feedback.

    1. To see index script when I see the fragmentation of this index. Now I need to use another tool to do it.

    >>I’m not sure I fully understand this request. Will you please elaborate a little more on what you are looking for?

    2. Databases refresh (button?)

    >> Have you tried clicking on the instance name and selecting ‘Rediscover database objects’? That should refresh the list of databases, tables and indexes.

    3. Now SQL Defrag is SDI, but sometimes I need to see the state of 2 databases in the same time.

    >>We appreciate the suggestion. I will add this to our list of feature enhancement requests. If you have any more information you would like to share about what it is you are doing/comparing when looking at the two databases simultaneously, that would be great.

  • Thank you,
    1. To see index script when I see the fragmentation of this index. Now I need to use another tool to do it.

    Excuse my English.

    For example, I have selected index ix1 of table t in Defrag.

    I see the index fragmentation % and some other counters.
    But I do not know what fields are in this index etc.

    I need to see just here T-SQL DDL for this index, i.e.
    CREATE INDEX ix1 …..

    If I see the DDL then I can understand better why this index so fragmented.

    Now I run SSMS, go to this index ix1 and check its definition.

    Thanks.