Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Procedure cache and sp recompile

Status
Not open for further replies.
timscronin

timscronin

MIS
Jun 27, 2001
837
US
I had a stored proc which called another sp. We changed the second sp and had a problem that a loop got stuck. I deleted the sp and then recreated the 2nd sp with the same code and problem gone. If you have an sp which calls a 2nd sp, does the executed plan stay in procedure cache
 
Sort by date Sort by votes
>>does the executed plan stay in procedure cache

theoritically yes, it must. however practically a lot of things like server memory etc will affect the caching policy of the server...

Known is handfull, Unknown is worldfull
 
Upvote 0 Downvote
It seems we had a problem, but when I dropped the 2nd sp and then recreated it and the problem went away
 
Upvote 0 Downvote
hmm, then i guess we need to wait and see if the error happens again...

Known is handfull, Unknown is worldfull
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

peac3
  • Locked
  • Question
Gaps and islands
Replies
8
Views
588
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
Derive staus date time by aligning start and end datetime
Replies
7
Views
615
Andrzejek
Andrzejek
peac3
  • Locked
  • Question
split one row into multiple rows... help pls 2
Replies
12
Views
1K
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
Adding Text to and XML Field 1
Replies
2
Views
313
grnzbra
grnzbra
TheBugSlayer
  • Locked
  • Question
Transaction with SELECT and UPDATE with XLOCK causing deadlocks 2
Replies
10
Views
839
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top