SQL Server Performance

Loading Showcontig output into a table

Discussion in 'Performance Tuning for DBAs' started by aijaz90, Jan 16, 2003.

  1. aijaz90 New Member

    I am new to SQL server, and I am interested in determining the fragmentation on indexes on my server. The 'DBCC Showcontig' tool seems to have the information which will be useful in deciding the level of fragmentation on an index, and I'd like to load this information into a table. However, the following code copied from Books Online is not producing the desired results:


    INSERT INTO #fraglist
    EXEC ('DBCC SHOWCONTIG (''' + @tablename + ''')
    WITH FAST, TABLERESULTS, ALL_INDEXES, NO_INFOMSGS')

    First, it is not recognizing 'FAST' and 'ALL_INDEXES' options. Second, 'TABLERESULTS' option is not producing the output as rowset with additional information. I don't know what I am doing wrong.

    aijaz90
  2. Argyle New Member

Share This Page