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

Welcome to the Performance Virtual Chapter

The Performance Virtual Chapter events are held on the 4th Thursday of each month at 2PM ET.  Every month there is a drawing for a $100 Amazon gift card sponsored by Confio.  To be eligible, you just need to attend our monthly webcast.  A winner will be randomly chosen from all those in attendance for the whole webcast who provide their email address. 



You can follow us on Twitter @SQLPASS_PVC

Join our Google Group Distribution List for the latest updates and meeting announcements.

Congratulations to the June Gift Card Winner...Will Lansing!

 

GoToWebinar requires registration through the RSVP link below.
Next Meeting

Thu, Jul 24 2014 11:00 Eastern Daylight Time


Summer Performance Palooza 2014

RSVP: None

Recording: None

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

RSVP: https://attendee.gotowebinar.com/register/1258931277819670017

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 is a Microsoft Certified Master SQL Server DBA, Certified Trainer, developer, and frequent speaker. He has specialized in SQL Server for fifteen of the twenty-five years he has spent in IT. Eddie is currently the Enterprise Database Architect the SalesForce-ExactTarget Marketing Cloud, a leading international SaaS company located in Indianapolis, Indiana. Eddie and his team manage the petabyte of 24x7 SQL Server clusters that form the foundation of the application.

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

RSVP: https://attendee.gotowebinar.com/register/3744115628639311873

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 is a database expert serving as Director of Engineering Services at SQL Sentry, a leading database tools vendor. A Microsoft SQL Server MVP since 2003, he is a founder and former president of PASS, author of over a dozen books, blogger, columnist, and popular speaker. Kevin has authored many books, including the best-selling "SQL in a Nutshell," and contributes monthly columns to SQL Server Pro and DBTA magazines. He tweets at @kekline and blogs at http://KevinEKline.com.

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

RSVP: https://attendee.gotowebinar.com/register/6901124673945219329

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, Microsoft MVP and VMware vExpert, is a SQL Server performance and virtualization expert. David spends his days handling performance and HA/DR architecture of physical and virtualized 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 davidklee.net, and reach him on Twitter at @kleegeek.

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

RSVP: https://attendee.gotowebinar.com/register/4499625252457046017

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 is the Practice Leader for UpSearch in Northeast Ohio. He's spent over 35 years in IT and has been using SQL Server since 1992. He is a certified MCITP in SQL Server and an MCT and has been awarded Microsoft’s MVP Award for the past 7 years. Allen is president of the Ohio North SQL Server User's Group. You can read his blog at http://sqlblog.com/blogs/allen_white/default.aspx.

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

RSVP: https://attendee.gotowebinar.com/register/3780275267713085442

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.


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

RSVP: https://attendee.gotowebinar.com/register/3502238463691789057

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 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 - Achieve Index Feng Shui in SQL Server

RSVP https://attendee.gotowebinar.com/register/8980944376372722434

Indexing is about balance not about black magic. The decision of Clustered vs. Non-Clustered indexes is only the first baby-step. In this session we complete that journey from index nightmares to index paradise. Leave this session knowing why indexes are just as important as table design and the confidence that on your first day back into the office that you have the skills to improve the performance of your database. We start with an understanding of the different index types and reviewing the common pitfalls of indexing. Then we quickly move to showing how you can identify index usage to determine if there are not enough, too many and even duplicates in the databases you manage. Our balance is achieved when we look at how SQL Server 2014 and the options provided. • Understand the foundation of indexing around clustered, non-clustered and column store indexes. • Know where and how to identify and prove those indexes that are causing harm than good. • See how additional indexing strategies such as covering indexes and filtered indexes are used to achieve a balanced database. • Become an index Feng Shui master by knowing what the differences are in SQL Server 2014 and how it benefits the performance of SQL Server.


Chris Shaw started his database career in 1993. Following the Marines, Chris continued working with databases for companies such as Wells Fargo, Pulte Mortgage, and Yellow Pages Inc. Chris has been writing and speaking about SQL Server for over 15 years at events such as SQL Connections, PASS Summit, and SSWUG Ultimate conferences. Chris received his 5th Microsoft MVP award.

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

RSVP: https://attendee.gotowebinar.com/register/8702206084103735298

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 works as a Principal Consultant at SQLskills in Parker, CO. He is a SQL Server MVP and has a whole 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, full text search, and SQL Azure. Glenn is also an adjunct faculty member at University College - University of Denver, where has been teaching since 2000, and has completed the Master Teacher Program at Denver University - University College. He wrote the book "SQL Server Hardware," and blogs regularly at http://sqlserverperformance.wordpress.com.