Recently I have been concentrating on Performance Tuning to identify when blocking is slowing down the system. I have learned how to see which sessions are involved; I have used tools to warn me when this happens. I have been tuning indexes to make queries faster, used free stored procedure to help me see missing indexes, and use them to identify duplicate indexes on table. I have also created a set of diagnostic information queries to give me a good baseline and help plan out performance tuning.