在SQL Server中执行过程缓慢的原因是什么 [英] What is the reason of slow execution of procedure in SQL server

问题描述

嗨。

我有查询。让我们假设在晚上我的存储过程需要2秒才能运行。

和早上当我上任并检查同样的程序需要很长时间才能运行。

什么有发生在昨晚。

请注意，我是唯一一个可以访问同一个DB的人。没有其他人在同一个DB上工作。



这可能是我将要考虑的第一个措施。





先谢谢。



我尝试了什么：



Plz让我知道原因可能是什么。

Hi.
I have a query. Lets suppose in evening my stored procedure is taking 2 sec to run.
and in morning when i come office and check that same procedure is taking long to run.
what had happened in last night.
Note that i am the only one who has access on same DB.No other is working on same DB.

what could be my first measures that i will look upon.


Thanks in Advance.

What I have tried:

Plz let me know what could be the reasons.

推荐答案

您是否在程序中进行批量插入或更新。如果是，则检查您的日志文件大小，可能是它增加了多于mdf文件大小。

Are you doing bulk insert or update in your procedure.If yes then check your log file size, may be it has been increased more then mdf file size.

这篇关于在SQL Server中执行过程缓慢的原因是什么的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！