Skip to main content
Search Again

We think these articles could help you:

    See More
    Nintex Knowledge Base

    Cleaning Fragmented Indexes In The Nintex Content Database

    Summary
    How to clean fragmented indexes in the Nintex Content Database

    Solution

    The t-sql below will retrieve the fragmentation on the indexes for a database named DATABASENAME. You will want to replace 'DATABASENAME' with the name of your database. 

    Use DATABASENAME
    GO
    SELECT OBJECT_NAME(i.object_id) AS TableName ,i.name AS TableIndexName ,phystat.avg_fragmentation_in_percent
    FROM sys.dm_db_index_physical_stats(DB_ID(), NULL, NULL, NULL, 'DETAILED') phystat
    inner JOIN sys.indexes i ON i.object_id = phystat.object_id AND i.index_id = phystat.index_id
    WHERE phystat.avg_fragmentation_in_percent > 10

    You can also use the PowerShell Script here: How to quickly check the health of your Nintex Workflow SQL Indexes  

    Once the fragmentation has been found you can plan accordingly for reorganizing/rebuilding the indexes. The link below provides further information on how to reorganize/rebuild these indexes.

    MSDN: Reorganize and Rebuild Indexes

    • Was this article helpful?