Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning All queries running slow after moving the db from staging server to production Server in SQL Server 2008 R2 RE: All queries running slow after moving the db from staging server to production Server in SQL Server 2008 R2

  • Where do you keep the database. is it on a SAN or the machine.

    It is advised to check on hardware side issues as well.

    We recently performed a migration similar to this and observed our HP SAN settings were incorrect due to which the loading process was taking time. We corrected this issue and everything was OK