August 29, 2011 at 2:32 pm
I have 4 parent stored procedures that will be executing the same child stored procedure. These parent stored procedures will all be executed around the same time.
Will I have any problems with this? Does the stored procedure get locked similar to a table lock when one parent runs it?
The child stored procedure has to be dynamic because there is about 4000 different things it can to do. However, if I make 4 different child stored procedures, I can split that into 1000 for each, but it would still need to be dynamic.
They will be selecting information from roughly the same tables though, will WITH (NOLOCK) prevent any problem I might have there?
Thank you in advance for your help!
August 30, 2011 at 5:33 am
you can call the same proc multiple times - we'd all have issues if we couldn't! If you don't qualify procs then this can cause blocking, you get similar if you names your procs sp_xxxx .
However if your proc is dynamic it may recompile which may cause other issues.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply