• Review the query plan of the longer running queries and see if tuning indexes can help speed up the queries.  Also, look into fragmentation of the tables as well.  Maybe a rebuilding of the indexes if they get a high number of inserts, deletes and or updates to them causing fragmentation.