My SQL Server appears to be running slowly. What is SQL Server index fragmentation, and how do I fix it?
See the Reorganize and Rebuild Indexes MSDN article for information on index fragmentation (choose your version of SQL Server from the drop-down menu).
There are two solutions to this issue.
Run either the Rebuild or Reorganize commands then verify if your WorkflowGen indexes have been successfully following the instructions in the above article.
Set up a scheduled defragmentation by scheduling a job to run the defragmentation script.
For instructions on how to schedule a job, see the How to: Schedule a Job (SQL Server Management Studio) MSDN article (choose your version of SQL Server from the drop-down list).
Run the B. Using DBCC SHOWCONTIG and DBCC INDEXDEFRAG to defragment the indexes in a database sample script in the DBCC INDEXDEFRAG (Transact-SQL) MSDN article. (The script can be run as-is.)