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.
| Author |
Topic |
|
Venujdv
Starting Member
1 Post |
 Posted - 2013-07-22 : 10:15:47
|
| Hi,I am using SQL 2008 R2.I have one stored procedure in that 6 insert statement and 2 update statement.1.Insert Statement2.Insert Statement3.Update statement4.Insert Statement5.Insert Statement6.Update statement7.Insert Statement8.Insert StatementIf i run 1st insert statement it is taking max 30 seconds to execute, for 2nd insert statement it is taking max 20 seconds to execute,for update statement 10 seconds.If i run all the three it taking more than 15 mins.Please any idea...?Thanks in advance...VenuJD |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-07-22 : 10:18:02
|
| Are they all working on same set of tables?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
Stored Procedure performance