http://www.sqlservercentral.com/blogs/stratesql/2012/02/14/two-webcasts-one-day/

Printed 2014/09/02 05:53AM

Two Webcasts, One Day

2012/02/14

4879560573_c672e47116_m

If you are interested in listening to my sultry Minnesota voice this Thursday, you have the opportunity to do it… and twice!  Think of it as a late Valentine’s present.

Over the course of the day, I’ll be doing two webcast.  The first presentation will be through Digineer, the consulting firm I work for, to talk about querying the plan cache.  Later later in the day, I’ll be online with the Edmonton SQL Server user group for a session on extended events.

Below are the details for both sessions…

Discovering the Plan Cache

Date: Thursday, February 16, 2012
Time: 1:00 PM – 2:00 PM CT

Execution plans are stored (after execution) in the plan cache.  This metadata about how queries are executed can provide insight into how your SQL Server environment is functioning.  Using XQuery to browse and search the plan cache can help you find potential performance issues and opportunities to tune your queries.  Additionally, this information  can be used to help reduce issues related to parallelism, shift queries from using scans to using seek operations, or simply just  discovering  exactly which queries are using what indexes.  All of this and more is readily available through the plan cache.

Register here!

Extended Events, Work Smarter Not Harder

Date: Thursday, February 16, 2012
Time: 6:30 PM – 8:00 PM CT

There are many ways to performance monitor your SQL Server environment. In this session we’ll review Extended Events, which is one of the newer SQL Server monitoring platforms. Learn the ins and outs of how to get detailed information on the errors and events that occur within SQL Server and how to dig into the information. With a few T-SQL statements, issues that could take weeks to research can be investigated in minutes.

Register here!

Related posts:

  1. PASS Summit 2011 Session Materials
  2. TechFuse 2011 – This Month
  3. PASS Summit Evals – Plan Cache Querying


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.