Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SQL Server 2005 memory manager procedure cache behavior?

0 views
Skip to first unread message

Bero

unread,
Aug 24, 2010, 7:49:38 PM8/24/10
to
Can some one give me some insight on the SQL Server 2005 memory
manager procedure cache behavior if the SQL statements are issued from
Visual Studio vs having club all the SQL Statements as an SP. Do SP
plans are kept longer in the procedure cathe than individual SQL ones.
Is there a priority of one vs other? Please point me to any articles
related to this. I have found one article but it is for SQLServer7.0

http://msdn.microsoft.com/en-us/library/aa226174(SQL.70).aspx

Andrew J. Kelly

unread,
Aug 25, 2010, 11:35:46 PM8/25/10
to
It's not so much which stays in the cache longer as it's about the same
principle as outlined in the white paper listed below. But it is more a
factor of plan reuse than anything. SP's are far easier to reuse the plans
than adhoc sql statements.

http://msdn.microsoft.com/en-us/library/ee343986(SQL.100).aspx


--

Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Bero" <robert...@gmail.com> wrote in message
news:54d50851-1f03-4fa3...@t20g2000yqa.googlegroups.com...

0 new messages