improving performance | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

improving performance

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
Yes, you have to update statistics full scan.
Luis Martin
Moderator 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.
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
More over is it necessary to update the stats while detaching db.
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
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.