（求助）SQL Server 存储过程在更换服务器后，执行速度变得很慢，原因会是什么？

Question

编写的SQL Server 存储过程执行速度一直很正常，但是在把数据库导入到另一台服务器后，一开始也是正常的，运行一段时间后，执行速度变得很慢。

已经尝试重新编译、重新建立新数据库等，仍然无法解决。

Answer 1

Hi hydxgcxy,

有关SQL Server速度优化的问题，这里有一篇博客或许你可以参考一下。

SQL Server查询优化方法。

有关SQL Server的问题，我建议你到SQL Server论坛进行提问，那边会有更专业的人帮助你。

Regards,

Kyle

Note: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; Therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 2

谢谢您，我已经在SQL SERVER 论坛里提问了，谢谢！