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

Prepared vs AdHoc - Plan Cache ObjType Expand / Collapse
Author
Message
Posted Monday, April 8, 2013 10:45 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 5:32 AM
Points: 2,733, Visits: 3,538
I would think that this would be an easy find with google... However, I have not found anything useful. So, gurus... What is the definition of a Prepared ObjType for a plan and what is the definition of an AdHoc ObjType for a plan; what distinguishes one from another and why is it important to me?


Thanks,

Jared
SQL Know-It-All

How to post data/code on a forum to get the best help - Jeff Moden
Post #1439939
Posted Monday, April 8, 2013 10:58 AM


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 @ 3:41 PM
Points: 42,490, Visits: 39,296
Parameterised vs not parameterised. (though you can prepare a statement with hardcoded values in it )


Gail Shaw
Microsoft Certified Master: SQL Server, 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 #1439943
Posted Monday, April 8, 2013 11:01 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 5:32 AM
Points: 2,733, Visits: 3,538
GilaMonster (4/8/2013)
Parameterised vs not parameterised.
Excellent! Thanks Gail.


Thanks,

Jared
SQL Know-It-All

How to post data/code on a forum to get the best help - Jeff Moden
Post #1439944
Posted Tuesday, May 12, 2015 1:10 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 8:30 AM
Points: 220, Visits: 861
Hi Gila,
Don't know if I can add on this thread. let me know for future reference. Anyway just have a question:
my 'Prepared' size is more than 'adHoc'. should I run dbcc freesystemcache ('sql plans') to minimize size of the 'Prepared' plan Cache Object? Is 'Prepared' as bad as 'adHoc'?
thank you
Post #1684860
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse