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 helpYes, 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.
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
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>