Profiler your database for quite period time and feed the result into Index Tuning Wizard to identify the columns that need to be indexed. And then inentify the long run queries and see changes in indexes will help the performance.