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 |
|
zeeshan13
Constraint Violating Yak Guru
347 Posts |
 Posted - 2007-06-28 : 11:50:46
|
| Hi All,I have a StoredProcedure sp_A which was working fine. I created another StoredProcedure called sp_B to do some inserts in some of the tables. sp_B has bunch of temperory tables. sp_A call the sp_B. I had a script that runs a bunch of StoredProcedure's together including the sp_A. Now it taking much longer; infact it keep on running. I need to check where it is causing the problem. I have no clue about SQL profiler and how to youse SQL profiler & where to use it. Can some tell me some steps to do that. Which Sp should I run it against?Looking for quick help.Zee |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-06-28 : 12:51:49
|
| dup....http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=85702 |
 |
|
|
|
|
|
Peromance issue with StoredProcedure execution