Search results matching tags 'Training' and 'plan cache'

Geek City: Plan Caching Internals

Kalen Delaney — Mon, 23 Aug 2010 17:04:00 GMT

This Friday is the last of my summer seminars. On August 27, I am presenting on plan caching, plan reuse and recompile and plan cache metadata. This is one of my favorite topics to talk about, because a lot of the information is not very widely known, and you can have a tremendous performance impact by making sure when plans are reused when that is the best option and when a new plan is compiled when that is best choice. By examining the plan cache metadata, you can see exactly what plans are currently in cache and what those plans are doing, i.e. index seeks or scan? hash joins or loop joins? extra sorting? parallelization?

Here is the link for more info and registration:

http://www.vconferenceonline.com/shows/workshops/plancaching.asp

The seminar has been pre-recorded, but I will be available concurrently for online chat and Q&A.

See you there!

~Kalen

Did You Know? I'm doing 3 more online seminars with SSWUG!

Kalen Delaney — Fri, 11 Jun 2010 22:46:00 GMT

As I told you in April, I recorded two more seminars with Stephen Wynkoop, on aspects of Query Processing. The first one will be broadcast on June 30 and the second on August 27. In between, we'll broadcast my Index Internals seminar, on July 23. Workshops can be replayed for up to a week after the broadcast, and you can even buy a DVD of the workshop.

You can get more details by clicking on the workshop name, below, or check out the announcement on the SSWUG site at http://www.sswug.org/editorials/default.aspx?id=1948

Query Plans Workshop (June 30, 2010)
Learn about basic elements, tools for exploring your query plans, how to detect inefficient plans and best practice guidelines

Indexing Workshop (July 23, 2010)
Learn about basic index structures, tools for exploring those structures, index design considerations and best practice guidelines

Plan Caching Workshop (Aug 27, 2010)
Learn about basic management of the plan cache, tools for exploring the plans in cache and detecting when they are reused, query design considerations to provide the optimal caching behavior and best practice guidelines

For those of you who attended my presentation at the Colorado PASS seminar last Wednesday in Denver, note that the 3rd workshop (Plan Caching), includes most of what I talked about in my presentation, and a lot more besides. The scripts from that session are now up on my site at www.sqlserverinternals.com/conferences

Have fun!

~Kalen

Did You Know? More online seminars!

Kalen Delaney — Thu, 22 Apr 2010 23:20:00 GMT

I am in Tucson again, having just recorded two more online workshops to be broadcast by SSWUG. We haven't set the dates yet, but we are thinking about offering a special package deal for the two of them. The topics really are related and I think they would work well together.

They are both on aspects of Query Processing. The first was on how to interpret Query Plans and is an introduction to the topic. However, it only includes a discussion of how SQL Server actually processes your queries. For example, what exactly does a Hash Join or Stream Aggregation mean? The second was on Caching and Recompiling, basically discussing how SQL Server stores and reuses the plans once it creates them. And, how to tell if reusing or recompiling the best option.

I'll post more details and links once they are available.

Also, I just realized I had never announced the winners of the drawing from my previous seminar.

Lorna M. won a copy of my SQL Server 2008 Internals book, and
Bob L. won a copy of SQL Server MVP Deep Dives

More books will be given away at future seminars!

~Kalen