Summer Performance Palooza 2013
UTC : Thu, Jun 27 2013 15:00 - 23:00
Local Time: Thu, Jun 27 2013 15:00 - 23:00
15:00 - How the SQL Server Engine Thinks
Abstract: When you pass in a query, how does SQL Server build the results? We'll role play: Brent Ozar will be an end user sending in queries, and you'll be the SQL Server engine. Using simple spreadsheets as your tables, you'll learn how SQL Server builds execution plans, uses indexes, performs joins, and considers statistics. This session is for DBAs and developers who are comfortable writing queries, but not so comfortable when it comes to explaining nonclustered indexes, lookups, and sargability.
Brent Ozar specializes in making SQL Server faster and more reliable. He's a Microsoft Certified Master of SQL Server and MVP, and he has over a decade of experience. He coauthored Professional SQL Server 2008 Internals and Troubleshooting, and he loves sharing knowledge at BrentOzar.com.
16:00 - Updates to Statistics and the Effect on Query Performance
Erin Stellato, Senior Consultant SQLskills.com
Abstract: Someone comes up to you and says “my query is slow.” Where do you begin? Do you start with the query itself? The query plan? SQL Server DMVs? There are many areas to investigate and one common area of focus is statistics. Statistics are an easy target for blame when performance is poor, and updating statistics without sufficient background information is a popular response as a “quick fix”. But what does updating statistics really do to your query plans? And is that the right solution? While updating statistics may solve your problem in the short-term, it may bury the true root cause. If you’re not familiar with what happens to query plans when you update statistics, then don’t miss this session. We’ll set the stage with a review of what statistics are, how the optimizer uses them, and discuss the various ways you can update them. Then we’ll explore what happens to plans when you do update statistics, and you’ll see why that might not always be the right long-term solution.
Erin Stellato is a senior consultant with SQLskills and lives in Cleveland, OH. She has over 12 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include internals, performance tuning, and high availability and disaster recovery.
Erin is a SQL Server MVP and an active member of the SQL Server community. She is involved with the Ohio North SQL Server User Group and blogs at SQLskills.com/blogs/erin. You can find her on Twitter at @ErinStellato.
17:00 - 10 Bad Habits that can Kill Performance
Aaron Bertrand, Senior Consultant SQL Sentry, Inc.
Abstract: Bad habits: we all have them. SELECT * is the obvious one; but in this session you will learn about various other habits and why they can be bad for performance. Come learn how these habits develop, what kind of problems they can lead to, and how you can avoid them.
Aaron Bertrand is a senior consultant for SQL Sentry, makers of performance monitoring and event management software for SQL Server, Analysis Services, and Windows. He blogs at sqlperformance.com and sqlblog.com, has been an MVP since 1997, will soon be a three-time SQL Cruiser, and speaks frequently at various community events. You can find his MVP profile at https://mvp.support.microsoft.com/profile/Aaron.
18:00 - Using Performance Monitor for your Virtual Servers
Wendy Pastrick, Consultant BlueGranite
Abstract: Your SQL Servers have now been virtualized, and you are monitoring them successfully. Do you know what the performance is like on the host, though? Using Performance Monitor (perfmon) we will look at the counters you need to have in place to know if your host is performing well. Set up the counters, collect the data and have meaningful conversations with your Virtualization or Infrastructure team.
Wendy Pastrick is a consultant in Chicago with BlueGranite, a Business Intelligence firm. She has been working with SQL Server since 2001 and specializes in server maintenance, migration and upgrades as well as architecting for high availability and disaster recovery. Wendy is an active member of the PASS organization, currently serving on the Board of Directors and often speaks at local user groups and SQL Saturday events. She has recently been awarded an MVP from Microsoft for SQL Server.
19:00 - Looney Tuner? No, there IS a method to my madness!
Janis Griffin, Senior DBA Confio Software, Inc.
Abstract: SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL Diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.
Janis Griffin has over 25 years of DBA experience including design, development and implementation of many critical database instances. Her primary focus has always been database performance. Before coming to Confio, she held many DBA positions, primarily in the Telecom/Network Industry, working with real-time network / OLTP databases. At Confio, her primary focus is assisting customers in finding and fixing database performance issues.
20:00 - Pivoting Performance Data & Pinpointing Problems
Abstract: Got performance problems? Struggling crack the case? Whether the problem is SQL Server, Windows, IIS or anything else. I've got a technique for logging and analyzing performance data using tools you probably have. Using these tools I have been able to find needles in haystacks and effectively communicate the nature of the problems to people at all levels. You don't need an expensive 3rd party product if you've got elbow grease and the code I'll give you. In this session, I'll demonstrate how I capture and analyze DMV and WMI counters. I'll tell some stories how this helped me solve some mysteries. You could use this pattern for any counters you can get your hands on. Join me for some mystery SQL theatre!
Brian Flynn has been working in IT since his college days in 1995, beginning as a desktop support technician. Since graduating with a Computer Science & Mathematics degree from SLU in 1999, he has served in many roles such as web and database development, administration and system engineering of multiple disciplines including web, database, mail and networking. He has been functioning in management capacities since 2008 and enjoys promoting social interaction and team building among I.T. pros.
21:00 - Index Methods You’re Not Using
Jes Borland, Consultant Brent Ozar Unlimited
Abstract: There are index methods in SQL Server that can enhance the performance of your queries - but most likely, you aren't using them! Using examples, I'll show you how indexed views, filtered indexes, and compressed indexes work; how they can improve performance; and what situations each is best used in. If you have a solid knowledge of index basics and want to add to your collection, this is the session for you!
Jes Schultz Borland is a consultant with Brent Ozar Unlimited and a Microsoft SQL Server MVP. She holds an AAS - Programmer / Analyst degree and has worked with SQL Server as a developer, report writer, DBA, and consultant. She is an active member of PASS, President of FoxPASS in northeast Wisconsin, founder of Tech on Tap, and a LessThanDot.com blogger. Jes frequently presents at user groups, SQLSaturdays, and other community events. She is also an avid runner and chef.
22:00 - How to Build an Affordable SQL Server Lab
Todd Kleinhas, Senior SQL Server DBA consultant Datavail
Abstract: Do you have an affordable lab set-up running SQL Server 2012 on Windows 2012 to learn and play with? In the 70-462 Administering Microsoft SQL Server 2012 Databases Training Kit, you will need six (!) machines on their own domain to complete the exercises. Using VMWare Workstation 9 ($250), Todd will show how to set up your lab environment on a ~$500 laptop running Windows 7 64-bit, 8GB of RAM, and an SSD drive using less than 40GB of space for the six virtual machines! Using free iso(s), we will run through several of the set-up exercises from the 70-462 Training Kit in order to build out the training lab. Participants will leave with enough knowledge and links to resources to build their own affordable SQL Server 2012 lab.
Todd Kleinhans has been working with SQL Server since 1999. He has worked as a dba, developer, data architect, manager, and consultant. He is currently a Senior SQL Server DBA consultant at Datavail. Todd is also the current VP of Marketing for the Denver SQL Server User Group. He has presented at user groups, SQL Saturdays, and the Rocky Mountain Trifecta.