Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SPROC's calling SPROC's and the Plan Cache... Expand / Collapse
Author
Message
Posted Wednesday, March 5, 2014 11:33 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 11:19 AM
Points: 105, Visits: 191
Yes forgive me I still maintain some VLDB's on SQL 2000 and trying to improve performance where I can.

A thought entered my head while pouring through old nast code - We have a lot of SPROC's calling even more SPROC's that even call more SPROC's... Well you get the idea...

Now, does that in itself effect the plan cache(ability) at all of the SPROC? Force any kind of recompile each time etc.?

I can't seem to dig out an answer...

Much thanks!


-- Wally
-- Reluctant DBA
Post #1547954
Posted Wednesday, March 5, 2014 12:06 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 5:52 AM
Points: 43,042, Visits: 36,200
WaIIy (3/5/2014)
Now, does that in itself effect the plan cache(ability) at all of the SPROC?


No

Force any kind of recompile each time etc.?


No



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1547968
Posted Wednesday, March 5, 2014 12:12 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 11:19 AM
Points: 105, Visits: 191
GilaMonster (3/5/2014)
WaIIy (3/5/2014)
Now, does that in itself effect the plan cache(ability) at all of the SPROC?


No

Force any kind of recompile each time etc.?


No


Thank you!


-- Wally
-- Reluctant DBA
Post #1547973
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse