在sql server中执行存储过程 [英] stored procedure execution in sql server

问题描述

在我执行存储过程的应用程序中花费2分钟时间，我想减少时间。有可能这样做。



提前谢谢。

Hi,

In my application to execute stored procedure it is taking 2minutes time,i want to reduce the time.is there any possibility to do that.

Thanks in advance.

推荐答案

一些存储过程只需要花费很多时间。您需要找出SP的哪个部分很慢。 SQL事件探查器将帮助您查明问题。这是找到从哪里开始你的性能增益的唯一方法，但是...有时候一切都很正确，这个过程只需要一些时间。



Eduard

Some stored procedures just take a lot of time. You need find out what part of the SP is slow. An SQL Profiler will help you pinpoint the problem. That's the only way to find out where to start with your performance gain but again... Somtimes everything is just right and the process just takes some time.

Eduard

首先，请阅读我的评论。



这可能是SP执行缓慢的几个原因。在这里您可以找到其中一些：针对TSQL性能的七种罪行 [ ^ ]



这是一个经常被问到的问题。另外，我建议使用 SearchBox [ ^ ]在本网站的右上角。

First of all, please read my comment.

It could be several reasons of slow execution of SP. Here you'll find some of them: The Seven Sins against TSQL Performance[^]

This is quite often asked question. Also, i would suggest to use SearchBox[^] at the right-top corner of this site.

这篇关于在sql server中执行存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！