Entries:
Comments:
Posts:

Loading User Information from Channel 9

Something went wrong getting user information from Channel 9

Latest Achievement:

Loading User Information from MSDN

Something went wrong getting user information from MSDN

Visual Studio Achievements

Latest Achievement:

Loading Visual Studio Achievements

Something went wrong getting the Visual Studio Achievements

Procedure Cache-Part II

Download

Right click “Save as…”

Refer to our video blog , to know the important role that  "Procedure Cache"  can play  in increasing your application and SQL server performance.

Procedure Cache, main goal is to cache the query plans  and allow its reuse and thus minimize the compile time and improve the performance.

This blog will provide you detailed information about some of the below mentioned topics:-

  1. What is Procedure Cache?
  2. Types of Cached Objects
  3. Structure of the Procedure Cache
  4. Procedure Cache And Memory
  5. Non- Cached Plans and Zero Cost Plans

 

Presented By:- Niraj P mehta, Senior Support Enigneer, Microsoft GTSC Reviewed By: - Rishi Maini,Support Escalation Engineer,Microsoft GTSC                          Pranab Mazumdar,Support Escalation Engineer,Microsoft GTSC

Follow the Discussion

  • RobertRobert

    Just as bad as part 1.
    Please get someone that can read, at least.

  • PuneetPuneet

    @Robert: I guess, you can't understand the accent. But u know what? This isn't a story of the movie. Go watch a movie if you want great sounding accent and good story!!.. FYI, I didn't have any problem in understanding what he read. If you had any problem in understanding any part, I will write a transcript and send it over!!

Remove this comment

Remove this thread

close

Comments Closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums,
or Contact Us and let us know.