• The first thing to do is compare how the execution plan and number of page read/writes differ between the two databases. You can then focus on why. This can be done using "STATISTICS IO" and "SHOWPLAN_TEXT" settings.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho