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:49:15
|
| 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 some quick help.Zee |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-06-28 : 12:51:21
|
| We probably need to see the content of both A + B procs....(sanitised for any confidential stuff if required)Are there any deadlocks visisble using sp_who?? |
 |
|
|
zeeshan13
Constraint Violating Yak Guru
347 Posts |
Posted - 2007-06-28 : 13:00:22
|
| You are not going to understand the SP's. They are big & very complex. For that you need to understand the whole Database schema which is obviously not possible. I am not a admin guy, thats why i am sturggling here. I use sp_who and thats the first time I have use it. sp_who return some mix status including sleeping for the Database that Iam running the storedprocedure against.What sleeping tell us? |
|
|
|
zeeshan13
Constraint Violating Yak Guru
347 Posts |
Posted - 2007-06-28 : 14:20:46
|
| Any answere please?... |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-06-29 : 06:08:30
|
| we don't need to understand them....but we may be able to spot some obvious bad/poor practice within the code. sometimes these things just leap off the page....Your questions at the moment is phrased a bit like "patient: doctor i've a problem. Doctor: what are the symptoms? Patient: sorry i'm so sick I can't tell you." I know it's important to you....but with so little detail supplied to date the lack of replies reflects this.sleeping connections, usually refer to connections that actually have terminated...but the server hasn't been informed of that.you're really looking for info on blocking...search here for previous advice in the area, there should be some useful guidelines / best practices listed. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-30 : 21:35:11
|
| Search profiler in books online, or ask your dba for help. |
|
|
|
|
|
|
Performance issue during StoredProcedur executuion