Matan Yungman is a Technical Evangelist for Madeira SQL Server Services. He has over 10 years of experience working with SQL Server, focusing mainly on performance tuning, high availability, database development and database design. Matan also co-hosts the Israeli SQL Server Radio show. He is passionate about SQL Server, technology and the SQL Server community.
The plan cache is one of SQL Server's fundamental components. Getting to know it can take you a few steps ahead in optimizing your system.
In this session we will demonstrate ways the Plan Cache can help us identify performance problems.
It's 18:00 o'clock on Friday. You execute a process that usually takes a few minutes and start packing in order to start the weekend. You are already with your bag on your back, but the process doesn't finish. What should you do now?