Recently we have had problems on one of the database that is used on 24/7 basis where a ETL process to import and export millions of rows on few tables has been taking longer time to finish. Further the SELECT queires on reports are timed-out and smaller queries are taking more time to finish. First instance I thought REINDEXING would do some betterment on the performance, as it is for 2 days to complete the reporting queries without any issues and then again problem started. Eventually after struggling...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/perftune/archive/2008/01/09/3025.aspx