Stored Procedures and Caching
-
Big applause. Great article. Nice and tight delievery.
-
Hm, I would call it a bit of article recycling.
Without compromising the quality, Brian.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
I would agree, Frank, but I had nothing to do with it, honest!!! Every so often they re-schedule some of the older articles and I guess it was my time. I'm not complaining!
K. Brian Kelley
@kbriankelley -
Hey, Brian, why should you complain anyway? I like the article, too.
And I'd rather read a good article twice or more than a not so good article once.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Brian,
Really nice job on the "Stored Procedures and Caching" article. Looks like a few other folks share my sentiment. Definitely above the norm of what I've come to expect from "authors", professional or not. Thanks for the great read.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Great article. As a former mainframe DB2 DBA, I was used to having more control over buffering and caching than what SqlServer allows - for better and for worse. and it's good to know a little bit more of the internal behaviour, even if just at a glance, to avoid some future pitfalls. Your article enlightened me.
Anyway, I think there may be a way around the recompilation problem of procedures with interleaved DML and DDL using nested stored procedures, but I may be wrong... I should try it some time.
-
Brian, i was unable to reproduce the CacheMiss when i executed a SP without specifying owner name. I followed the steps which u mentioned like creating a non-dbo account, creating a dbo owned SP etc., for testing this scenario. But i always got the ExecContextHit event instead of CacheMiss from the second execution.
Could you please give me some more details on how to reproduce this.
Thanks for such a great article.
Viewing 7 posts - 16 through 21 (of 21 total)
You must be logged in to reply to this topic. Login to reply