The Performance Virtual Group's mission is to empower the global Microsoft SQL Server database community with technical content regarding performance related to SQL Server.

Thank you to those of you that were able to attend the Winter 2012 Performance Palooza hosted by the Performance Virtual Chapter on December 6, 2012.  You can download the slide deck and scripts for each session using the Download buttons below.  If you missed a session, you can watch it using the Recorded session link provided below.  Enjoy, and thank you for supporting the Performance VC!

Session  Slide / Demos
Speaker: Kalen Delaney
Speaker: Argenis Fernandez
 
Speaker: Joe Sack
Speaker: John Sterrett
 
Speaker: Neil Hambly
 
 Speaker: Randy Knight
 
Speaker: Kevin Boles
Speaker: David Klee
 

 

16:00 UTC - Recompile or Reuse? Making the Most of Plan Cache by Kalen Delaney  

 Abstract

Multiple recompilations of the same query plan can definitely impact your application performance, but on the other hand, not recompiling and reusing an inappropriate plan can hurt performance also.

In this session, we'll explore SQL Server's plan cache, and look at the various ways that SQL Server determines whether to reuse or recompile. We’ll discuss how to tell whether plans are being reused and how to change SQL Server behavior to get the best performance from caching behavior.

Bio

Kalen Delaney has been working with SQL Server for over 25 years, and provides advanced SQL Server training to clients around the world. She has been a SQL Server MVP since 1993 and has been writing about SQL Server almost as long. Kalen has spoken at dozens of technical conferences, including every PASS conference in the US and multiple TechEd events in both the US and Europe. Kalen is the author or co-author of many books on SQL Server, the most recent being SQL Server 2012 Internals, from O’Reilly/Microsoft Press. She is one of the main editors for SQL Server Central’s SQL Server Stairways Series, http://www.sqlservercentral.com/stairway. Her most recent major editing project My most recent project was as editor of SQL Server MVP Deep Dives, Volume 2, a collection of articles by SQL Server experts from around the world, with all the royalties going to charity Kalen’s website with her current training schedule is at http://www.SQLServerInternals.com and she blogs at www.sqlblog.com. 

 

17:00 UTC - Troubleshooting SQL Server with SysInternals Tools by Argenis Fernandez 
 Abstract

In this demo-packed session we will explore the use of SysInternals tools like Process Monitor, Process Explorer, and many others to troubleshoot various problem scenarios with SQL Server. This session is not for the faint of heart and is tailored toward those adventurous DBAs who often like to step out of their comfort zone. A fair knowledge of Windows OS internals is recommended.

Bio

Argenis Fernandez is a Senior Consultant for Microsoft Consulting Services - US West Region based in Redmond, WA. He has been working with SQL Server for over 14 years. He thoroughly enjoys working with large SQL Server farms, high end OLTP databases, managing Windows environments and Powershell scripting. He is also a Microsoft Certified Master on SQL Server 2008, an avid user of Twitter (can be reached at @DBArgenis), and blogs rather infrequently on SQL Server topics at http://www.sqlblog.com/blogs/argenis_fernandez/.

 

18:00 UTC - Troubleshooting Query Plan Quality Issues by Joe Sack

Abstract

When the query optimizer inaccurately estimates the number of rows for query execution plan iterators, performance can suffer due to the generation and use of a suboptimal plan. Fixing cardinality estimate issues will help the query optimizer generate a higher quality plan. This session will teach you how to identify cardinality estimate issues in your query execution plan and also cover various ways in which cardinality estimate issues can be addressed.

Bio

Joe Sack is a Principal Consultant with SQLskills. Prior to joining SQLskills he worked at Microsoft as a Premier Field Engineer supporting large enterprise customer environments. He achieved “MCM:SQL Server 2005” and “MCM:SQL Server 2008” certification and from 2009 to 2011 he was the acting Program Manager for the SQL MCM program. His most recent book is "SQL Server 2008 Transact-SQL Recipes" (APress).
 
19:00 UTC - 12 Steps to Workload Tuning by John Sterrett
 

Abstract

We might know how to tune a query for optimal performance or create additional indexes to ensure faster execution, but how do we ensure that our changes don’t hurt our total workload? Do we know if the new 3rd Party application upgrade will make performance better or worse? Do we know if your application can scale due to unexpected stress? In this session, we will go over a process used to tune a workload and answer the common questions above. In this presentation we will also use RML Utilities to answer these questions and even give you a little insight into how you can document these changes to help you get that next raise.

Bio

John Sterrett has been active within the SQL Server community. He is a PASS Regional Mentor for the South Central Region, co-founded the West Virginia SQL Server User Group and hosted two PASS SQL Saturday events in West Virginia. John has presented at several SQL Server events including PASS SQLRally, PASS Member Summit, many PASS SQL Saturday events, code camps, and, user groups. John is a syndicated blogger at SQLServerPedia, contributes tips at MSSQLTIPS.

 

20:00 UTC - Effective Index Partitioning & Compression Strategies by Neil Hambly
 

Abstract

We all know that ‘Indexing’ is KING when it comes to achieving high levels of performance in SQL Server.  When Indexing also combines 2 of the Enterprise features: Partitioning &  Compression, we can often see substantial gains.  Learn how to identify those objects that benefit greatly from being Partitioned or Compressed, OR combining both of these features to even greater effect.  Using Demos to illustrate the performance gains with real-world examples, be the first to see and download these advanced scripts for use in your own environments.

Bio

Neil Hambly is a Senior DBA @ Confio Software, having held various SQL Server roles during the last 14 years @ market leading companies (Accenture, ABN AMRO, BBC, iProfile, MDSL)
He has considerable Experience in SQL Server starting with version 6.5  through to the latest 2012 release.  A regular International speaker @ SQL conference & User Group, he also leads the SQL London PASS Chapter (UK).  Frequently found studying the inner workings of SQL Server, as well as an avid Tweeter @Neil_Hambly
.
21:00 UTC - Understanding Transaction Isolation Levels by Randy Knight

Abstract

Transaction isolation levels are one of the most important but least understood areas of SQL Server. SQL Server offers several isolation levels beyond the default READ COMMITTED, but figuring out when to use each one can be daunting.
 
Whether you are a developer who needs to understand how isolation works and why NOLOCK is usually not an appropriate hint or a seasoned DBA who needs to understand the less commonly used isolation methods, this session is for you. We will look at each isolation level and how it impacts the engine, then examine appropriate (and inapproriate) use cases for each.

BIO

Randy Knight, MCITP, is an IT professional who has worked with Microsoft technology for over 20 years, focusing on SQL Server for the last 15. He has worked in a variety of settings, including 6 years as a Database Architect for Match.com, one of the largest and most successful dot-coms. He is currently the President and Principal Consultant for SQL Server Solutions Group LLC, a Utah-based SQL Server consultancy. A nationally known speaker and trainer, he has presented at numerous SQLSaturday, Code Camps, and user groups as well as the inaugural PASS SQLRally 2011 and SQLPASS Summit 2012.

22:00 UTC - SQL Server 2012 Column Store Index by Kevin Boles

Abstract

Take your relational data warehouse query performance all the way to ELEVEN!!  The Column Store Index is a new feature that allows for stunning performance.  We will cover how it works, why it is so fast as well as the v1.0 limitations and gotchas.

BIO

Kevin is a SQL Server expert, working exclusively with the product since version 6.5. With over 20 years of database experience and 40000+ man hours of SQL Server relational engine experience, he holds many SQL Server related certifications and is also an MCT and was a SQL Server MVP from 2007 to 2012. Kevin teaches occasionally and has been a very successful independent consultant for almost 15 years. His passion is the relational engine, especially scalability, performance analysis and tuning.

http://www.linkedin.com/in/thesqlguru
@TheSQLGuru

23:00 UTC - Virtualizing Business Critical SQL Servers by David Klee
 

Abstract

Everyone knows that SQL Server can be virtualized, but most are only virtualizing development and testing environments. Top-tier production workloads can be virtualized too, with all of the performance that you enjoy today, and David Klee (@kleegeek) will provide valuable insight into how to properly prepare for and implement a successful virtualization campaign for ALL of your SQL Server environments. Practical tips, tricks, and gotchas for designing for performance will be discussed in this session.

BIO

David Klee (@kleegeek) is a SQL Server performance and virtualization expert. With over fifteen years of IT experience, David spends his days virtualizing mission critical SQL Servers as a Solutions Architect for House of Brick Technologies. His areas of expertise are virtualization and performance, datacenter architecture, software engineering, security, and business process analysis.

 

 

cage-aids
cage-aids
cage-aids
cage-aids