Useful SQL to check your indexes. If avg fragmentation is larger than 15% consider rebuilding the indexes: SELECT OBJECT_NAME ( object_id,database_id), * FROM [sys].dm_db_index_physical_stats, NULL, NULL, NULL, DEFAULT) AS ddips order by avg_fragmentation_in_percent desc [...]
This script will show you how many Workflow progress records each workflow in your environment has generated. SELECT i.WorkflowName, COUNT(p.InstanceID) [Number of WF Progress Records], i.siteid, i.webid, i.listid FROM dbo.workflowinstance i inner join dbo.workflowprogress p on i.InstanceID = p.InstanceID GROUP BY i.WorkflowName, i.siteid, i.webid, i.listid ORDER BY COUNT(p.InstanceId) DESC This [...]
