Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Stored Procedure - Performance issues

Author  Topic 

nguyenl
Posting Yak Master

128 Posts

Posted - 2009-02-20 : 16:55:56
Hi,

Not sure how to word this, but:

Does anyone whether there will be performance issues if many sql processes uses the same stored procedure?

Thanks

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-20 : 16:58:17
quote:
Originally posted by nguyenl

Hi,

Not sure how to word this, but:

Does anyone whether there will be performance issues if many sql processes uses the same stored procedure?

Thanks



Depends on what store procedure is doing. It could be due to blocking/locking issues.
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2009-02-20 : 20:54:09
It Depends! The answer to everything

Want to post the sproc, and decide to tell us how many calls per second?



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page
   

- Advertisement -