SQL Slow Performance

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