Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a customer who has upgraded their SQL Server from SQL Server 2005 to SQL Server 2012. According to them, no other changes were made. They have an ERP database which does a full reindex once a week (the SQL just locates every index in the DB and rebuilds it) and it completed normally in 3 hours before the upgrade.

The DB is 178GB. After the upgrade, suddenly performance tanked. They performed a reindex and it was taking several hours and before being half way finished the log file grew to close to 500 GB. They ran out of disk space, so they dumped the log and did the reindex in pieces.

Would an upgrade to SQL Server 2012 change how indexes need to be rebuilt? Did something about the upgrade change the indexes? Do upgrades like this change indexes? We are going to monitor this on the next go around and see if it drops back to 3 hours or if it takes a huge amount of time and space again. Any imaginative thoughts would be appreciated as well, since I'm getting a lot of this information second hand from my customer :)

share
    
Can you also post what steps were taken after the upgrade - post upgrade steps as well as confirm that all the sp_configure (or select * from sys.configurations) match the old server as well ? –  Kin Jul 3 '13 at 15:52
comments disabled on deleted / locked posts

migration rejected from stackoverflow.com Jul 3 '13 at 16:51

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as too broad by Paul White, Nick Chammas, Kin, swasheck, dezso Jul 3 '13 at 16:51

There are either too many possible answers, or good answers would be too long for this format. Please add details to narrow the answer set or to isolate an issue that can be answered in a few paragraphs.If this question can be reworded to fit the rules in the help center, please edit the question.