Yesterday we migrated a SQL Server 2005 database to SQL Server 2012. We made a full backup and restored it on the new server.
Problem now is that the database on SQL Server 2012 is much slower than it was on the Windows 2003 server with SQL Server 2005. What's even more worrisome is that the exact same maintenance plan (that took 37 minutes to run on SQL Server 2005) is now taking more than 2 hours and uses 16GB of memory and the
tempdb is filling up the empty space on the
C: drive. What's going on?
The server specification are the same for both:
- X5650 @ 2.67GHz (4procs)
- 16 GB RAM
The maintenance plan consists of the following steps:
- Step 1: Check DB integrity
- Step 2: Reorganize Index
- Step 3: Rebuild Index
- Step 4: Shrink Database