Microsoft KB Archive/325119

= Support WebCast: Analyzing Optimal Compiled Plan Caching =

Article ID: 325119

Article Last Modified on 8/10/2004

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q325119



Session Summary
During this Support WebCast, we will cover the different ways that you can submit queries to SQL Server, and the plan caching associated to each of them. We will discuss the plan caching mechanism in SQL Server, its merits and its flaws. We will also talk about techniques to improve plan caching for database queries, and explain the options that you can use to avoid poor plan caching.

This is a Level 300 session that was recorded May 1, 2001 and presented by Sajal Dam. Sajal Dam is an Application Development Consultant. He has been with Microsoft for about three years working with Premier customers to help tune their Web and WinDNA applications for both performance and scalability. He also conducts SQL Server performance tuning workshops for Premier customers. Sajal earned his Masters degree from Indian Institute of Science in Bangalore, India.

Viewing the Presentation
To view, please click on the link: [javascript:fnViewMMC('http://support.microsoft.com/servicedesks/webcasts/seminar/shared/asp/view.asp?url=/servicedesks/webcasts/en/WC050101/manifest.xml'); View this Support Webcast] (Length: 1 hour 9 minutes)



This Windows Streaming Media archive requires an Internet connection of 28.8 Kbps or faster, and is best viewed with a minimum screen resolution of 800 X 600.

Additional Resources
Download presentation WC050101.ppt. This is a 212-KB Microsoft PowerPoint (.ppt) file.

If you do not have PowerPoint and you want a copy of the slides, use the PowerPoint Viewer (2,752 KB).

Read the transcript from this Support WebCast

[mailto:?subject=Support%20WebCast:%20Analyzing%20Optimal%20Compiled%20Plan%20Caching&body=Take%20a%20look%20at%20this%20Microsoft%20Support%20WebCast%20about%20Analyzing%20Optimal%20Compiled%20Plan%20Caching%20(May%201,%202001).%20More%20information%20about%20this%20WebCast%20is%20available%20at%20http://support.microsoft.com/WebCasts. Tell a friend about this Support WebCast]

Supplemental reading:
 * SQL BooksOnline: Execution Plan Caching and Reuse
 * Q243588 INF: Troubleshooting Performance of Ad-Hoc Queries
 * Q243586 INF: Troubleshooting Stored Procedure Recompilation

Provide Feedback on this Broadcast

Support WebCasts Home

Keywords: kbinfo kbdownload kbtshoot kbwebcastsupport KB325119

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.