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.

Sign in to Subscribe

Meeting Details

Summer Performance Palooza 2014

Thu, Jul 24 2014 15:00 UTC

11:00 AM EDT - What is a Latch, and Why Do I Care?

<B>Recording:</B> <a target=_blank href=""></a> <BR> <BR> Latching is a necessary function of the database engine. Although latching is a topic is normally presented only in expert-level sessions, a good grasp of the problems excessive latching exposes is important even for novice tuners. This session focuses on the PAGELATCH_* and PAGEIOLATCH_* wait types, explaining what is happening, why it is happening, and how to use the exposed information to tune queries and solve performance problems. If you've seen these wait types in Activity Monitor and wonder what they meant, then this session is for you!

Eddie Wuerch

Eddie Wuerch has 20 years of experience as a SQL Server specialist in a much-longer IT career. A Microsoft Certified Master, Eddie spends his days in the Salesforce Marketing Cloud, focusing on performance, scale, and uptime for the massive SQL Server backend. These SQL Servers churn billions of transactions daily against trillions of rows of data in a 24x7 continuously-available online system accessed by millions worldwide every day.

12:00 PM EDT - Configuration Option and Trace Flag Secrets: Surprising Behavior at the Flick of a Switch

<B>Recording: </B><a target=_blank href=""></a> <BR> <BR> If you’ve been a SQL Server DBA or Dev for any length of time, you’ve probably heard of various options that you can set at the instance- or database-level that can impact performance. Do you know what they are, when to use them, or what they do? And what about all of those trace flags? There are so many of them and many are undocumented. What gives? In this session, you’ll learn about a variety of ways to speed up IO, adjust memory, change plan and buffer cache behavior, debug the SQL query optimizer, and how to punch SQL Server in the face!

Kevin Kline

Kevin Kline is a database and industry expert serving as Principal Program Manager at SentryOne, the industry leading SQL Server database tools vendor. A Microsoft SQL Server MVP since 2003, he is a founder and former president of PASS. Kevin is an author of many books, blogger, columnist, and popular international speaker. Kevin’s best known book is the best-selling SQL in a Nutshell and contributes monthly to Database Trends & Applications magazine. He tweets at @kekline and blogs at

1:00 PM EDT - Infrastructure Tuning for SQL Server Performance

<B>Recording: </B><a target=_blank href=""></a> <BR> <BR> Mention SQL Server performance to any DBA, and the impulse is to dive headfirst into the database and queries. However, if the infrastructure underneath the data is your performance bottleneck, the time spent tuning at the database layer is usually in vain. Server hardware, operating system parameters, storage, interconnects, and networking will all be discussed in depth in terms that DBAs can relate to. Practical architecture guidelines and troubleshooting techniques will be presented so you can analyze your environments and see if your performance bottlenecks are where you think they are.

David Klee

David Klee is a Microsoft MVP and VMware vExpert with a passion for the convergence of infrastructure, cloud, and database technologies. David spends his days handling performance and HA/DR architecture of mission-critical SQL Servers as the Founder of Heraflux Technologies. His areas of expertise are virtualization and performance, datacenter architecture, and risk mitigation through high availability and disaster recovery. You can read his blog at, and reach him on Twitter at @kleegeek. David speaks at a number of national and regional technology related events, including the PASS Summit, VMware VMworld, SQL Saturday events, and SQL Server user groups.

2:00 PM EDT - Maintain SQL Server Performance Baseline with PowerShell

<B>Recording: </B><a target=_blank href=""></a> <BR> <BR> Maintaining a solid set of information about our servers and their performance is critical when issues arise, and often help us see a problem before it occurs. Building a baseline of performance metrics allows us to know when something is wrong and help us to track it down and fix the problem. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.

Allen White

Allen White is a Data Platform consultant. He has been both a developer and an administrator, so he understands both perspectives towards database technology, and loves sharing his experiences and helping people learn how to use SQL Server. Allen has spent over 40 years in IT, using SQL Server since 1992, and is certified MCITP in SQL Server and MCT. Allen has been awarded Microsoft’s MVP Award for the last 12 years, and was a PASS Director from 2016 - 2018.

3:00 PM EDT - Every Byte Counts: Why Your Datatype Choices Matter

<B>Recording:</B> <a target=_blank href=""></a> <BR> <BR> Ever encounter a table consisting only of BIGINT, CHAR(255), and NVARCHAR(MAX) columns? Did your gut tell you that this is bad, but you had difficulty explaining why? Did you know that these Datatype Choices can be a real performance killer? Attend this session, learn how database records are stored within SQL Server, and why all data types are not created equal. Armed with that knowledge, we will then explore several performance scenarios that may be impacting your systems right now! When you leave, you should be able to explain why datatype choices matter to your colleagues, assess your own systems, and implement some best practices to mitigate these performance killers.

Andy Yun

Once a DBA, Andy Yun is a Database Developer and self-proclaimed T-SQL performance junkie. Over the past decade, he has worked with SQL Server in highly transactional environments, in the trading and credit card industries. Leveraging knowledge of SQL Server Internals, Andy strives to make T-SQL leaner and meaner. He is very passionate about the SQL Server community, loves making new connections, and is excited to start presenting.

4:00 PM EDT - Virtualizing our Environment

<B>Recording:</B> <a target=_blank href=""></a> <BR> <BR> This session will describe our journey to convert our cluttered, underutilized, power draining physical hosts to a sleek virtualized environment. This session will also provide some VMware high level architecture, terms and concepts, and a look at vSphere (VMware admin console). I'll discuss the differences between virtual and physical host metrics and issues surrounding them. We'll discuss some virtualization shortcomings and then show a little about Confio's Ignite and how it can help DBAs achieve virtualization and not lose visibility of their physical layer.

Rob Mandeville

Rob Mandeville is a Senior DBA with over 15 years of broad experience in database technologies. He's served in many roles including production DBA, development DBA, and architect/data modeler on a variety of platforms. Before coming to SolarWinds, Rob worked in the aerospace, global technology, and geospatial industries. Rob also had the honor of teaching database related master level courses at Regis University.

5:00 PM EDT - Eating the Elephant: Introduction to SQL Server Table Partitioning

<B>Recording:</B> <a target=_blank href=""></a> <BR> <BR> Is your data fat? Do you run into challenges with large data sets and tables in your SQL Server database? As data volumes increase, database administrators and developers must find different approaches for managing their systems. Enter SQL Server Table Partitioning, an established part of the SQL Server platform that gives data professionals the tools to segment their data to assist with index maintenance, query performance, and storage management. In this technical presentation, you will be given an overview of what SQL Server Table Partitioning is, how to design and implement it, what sort of maintenance needs to be done, and how you can leverage partitioning to in your daily operations. Attendees will leave this session with the fundamental knowledge to plan and implement table partitioning in their own environments.

Mike Fal

Mike Fal is a musician turned SQL Server DBA, with 10+ years of experience as a database administrator. He has worked for several different industries, including healthcare, software development, marketing, and manufacturing and has experience supporting databases from 1 GB to 4 TB in size. Mike received his a Bachelor's Degree from the University of Colorado at Boulder in 1996 and has been caught playing trombone in public on more than one occasion.

6:00 PM EDT - Hardware 201: Selecting and Sizing Database Hardware for OLTP Performance

<B>Recording: </B> <a target=_blank href=""></a> <BR> <BR> The foundation of database performance is the underlying server hardware and storage subsystem. Even the best designed and optimized database application can be crippled by an inadequate hardware and storage infrastructure. Recent advances in new processors and chipsets, along with improvements in magnetic and SSD storage have dramatically changed the evaluation and selection process compared to the past. Many database professionals struggle to keep up with new technology and often simply let someone else make their hardware selection and sizing decisions. Unfortunately, the DBA usually gets the blame for any performance issues that crop up later. Don't let this happen to you! This session covers current and upcoming hardware from Intel and gives you the tools and resources to make better hardware selection decisions to support SQL Server OLTP workloads.

Glenn Berry

Glenn Berry works as a principal consultant at SQLskills in Elizabeth, CO. He is a former Data Platform MVP and has a collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests! His expertise includes DMVs, high availability, hardware selection, and storage subsystems. Glenn is also an adjunct faculty member at University College - University of Denver, where he has taught since 2000.

Back to Top