SQL Server Performance

improving performance

Discussion in 'General DBA Questions' started by aaronsandy, Jul 25, 2005.

  1. aaronsandy New Member

    If 2 servers exists A and B with same hardware configuraton. I have detach db1 from serv A and Attach to B.Now the queries on serv A takes 15 min where as query on serv B takes 30 min.How will I trouble shoot this issue.Is updating stats ,and reindexing will help
  2. Luis Martin Moderator

    Yes, you have to update statistics full scan.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell


    All postings are provided “AS IS” with no warranties for accuracy.



  3. aaronsandy New Member

    While deataching db from serv A I have checked the "check box stating update stats before detach".I am wondering why I need to update the stats again after attach on servB
  4. aaronsandy New Member

    More over is it necessary to update the stats while detaching db.
  5. satya Moderator

    Yes it is ideal to update stats in this case and always better to update stats after attaching in order to keepup the performance.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page