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

Palooza 2015 - Register for each session below

Thu, Jul 23 2015 15:00 UTC

10:00 AM - Make Your SQL Server Queries Go Faster

Recording: <a href="https://www.youtube.com/watch?v=SdxE3NfWToM">https://www.youtube.com/watch?v=SdxE3NfWToM</a> <BR> <BR> Have you ever developed slowly running queries and wondered how to make your own SQL Server queries go faster? In this session you will learn some T-SQL performance tuning tips that can be used on Monday back at the office. You will learn how to identify top offender queries, be able to benchmark queries, and apply proper indexes while avoiding common mistakes. Finally we will cover coding patterns that are developer friendly but are not SQL Server database engine friendly and show you how to rewrite them so they can run faster.


John Sterrett

John Sterrett is an MCSE: Data Platform, Principal Consultant and the Founder of Procure SQL LLC. John has presented at many community events, including Microsoft Ignite, PASS Member Summit, SQLRally, 24 Hours of PASS, SQLSaturdays, PASS Chapters, and Virtual Chapter meetings. John is a leader of the Austin SQL Server User Group and the founder of the HADR Virtual Chapter.

11:00 AM - Building High Performance SQL Servers Virtual Machines on AWS and Azure

Recording: <a href="https://www.youtube.com/watch?v=GJ8Ovfdwsxs">https://www.youtube.com/watch?v=GJ8Ovfdwsxs</a> <BR> <BR> First we had bare metal, then virtualization took the world by storm. Now the cloud is set to change the data center once again with it's quick provisioning, on-demand utility model. But how do we pick out of all the choices on the different cloud providers? You might be required to specify the configuration you want for your SQL Server virtual machine and your organization is now making a move to Amazon's AWS or to Microsoft's Azure. Come learn about the recommended configurations, gotchas and real experiences from clients that have moved their high performance database workloads to the cloud.


Warner Chaves

Warner Chaves is a SQL Server MCM, MVP and SQL Server Principal Consultant at Pythian, a global Canada-based company specialized in DBA services. A brief stint in .NET programming led to his early DBA formation working for enterprise customers in Hewlett-Packard ITO organization. From there he transitioned to his current position at Pythian, managing multiple customers and instances in many versions and industries while leading a highly talented team of SQL Server DBAs.

12:00 PM - Performing a SQL Server Health Check

RSVP: <a href="https://www.youtube.com/watch?v=GgnsVdFUXkM">https://www.youtube.com/watch?v=GgnsVdFUXkM</a> <BR> <BR> How often do you review your SQL Servers for basic performance, security, and maintenance issues? If you say never, I'm not surprised - many of the servers I "inherit" as a managed services provider have many gaping holes. It is not unusual to find databases that are never backed up, constant login failures (is it an attack or a bad connection string?), and servers that need more RAM/CPU/etc. (or sometimes that have too much!) <P> Come learn how to use freely available tools to check your servers for basic issues like backups and CheckDB as well as for more advanced issues like page life expectancy and indexing and how they can affect your performance (and system viability). If you are responsible in any way for a Microsoft SQL Server (DBA, Windows Admin, even a Developer) you will see value in this session!


Andy Galbraith

Andy Galbraith a forty-something Microsoft SQL Server DBA of 14+ years, a devoted husband, and a father of three young boys (all aged five and under!) I have been a DBA at a public university, at a major bank, at a healthcare system, and I now work as a consultant with customers across the United States. I write and speak primarily about the tips and tricks that I discover along my SQL Server journey.

1:00 PM - Columstore Indexes - Questions and Answers

Recording: <a href="https://www.youtube.com/watch?v=sY7ed0sPYak">https://www.youtube.com/watch?v=sY7ed0sPYak</a> <BR> <BR> Columnstore is a very exciting technology that can boost the performance of your queries by orders of magnitude. However, like every technology, you have to use it the right way in order to achieve such a performance boost. <BR> <BR> We will start the session with a quick overview of the technology in order to bring everyone up to speed. After that, we will start asking questions that will help us understand how to master it and be successful when working with it. <BR> <BR> Among others, we will answer questions like: • When will a Clustered Columnstore Index boost performance by orders of magnitude, and when it won’t help so much? <BR>• How to defeat the “lazy” tuple mover? <BR>• How to increase segment elimination? <BR>• How to load data the right way? <BR>• Why is "batch mode" so much faster than "row mode"? <BR>• Is Nonclustered Columnstore still relevant? <BR> <BR> We will also go over the new Columnstore features that will be included in SQL Server 2016 and emphasize the performance gains we can get from them.


Matan Yungman

Matan Yungman is a Data Platform MVP, a senior consultant and the professional manager at Madeira Data Solutions. He has been working with SQL Server since 2002, and today he spends his time consulting, mentoring, teaching and speaking about SQL Server. Matan also co-hosts SQL Server Radio, a podcast for SQL Server professionals. He is passionate about SQL Server, technology and the SQL Server community.

2:00 PM - Performance Troubleshooting Using DMVs

Recording: <a href="https://www.youtube.com/watch?v=kLIys0IALS8">https://www.youtube.com/watch?v=kLIys0IALS8</a> <BR> <BR> Performance troubleshooting is a complex subject with many factors under consideration when you find poorly Performing SQL statements, using proven methodologies, and evaluating performance data available in the Dynamic Management Views and Functions. In this 1 hour session, we’ll go over a which key DMVs to use to identify those problematic statements for versions of SQL Server from 2005 – 2014.


Neil Hambly

Neil Hambly is a SQL Server consultant, founder and consultant at Datamovements, a Gold Microsoft Data & Analytics Consulting company. Neil has 20+ years in a variety of SQL Server roles and is an MCT. He is a regular presenter (200+ events) at user groups, and PASS events, including PASS Summit and SQLSaturday, and many UK events (SQLBits, SQLRelay). Neil is the leader of PASS London (UK), a Professional Development VC, a Melissa Data MVP, and a SQL Cruise Technical Lead, who loves Guinness, whisky, and dancing.

3:00 PM - Maximizing SSIS Package Performance

Recording: <a href="https://www.youtube.com/watch?v=B4HEWUpV32A">https://www.youtube.com/watch?v=B4HEWUpV32A</a> <BR> <BR> When reviewing your ETL processes, the No. 1 question is always, "Does it work as expected?" Closely following that question is the ubiquitous, "How fast does it run?" This session’s tips are targeted at improve the latter. <BR> <BR> In this session, we’ll focus on SSIS package performance, quickly reviewing 15 common hotspots for performance issues as well as recommended methods for maximizing throughput. You’ll walk away with some key design patterns and recommendations that you can use today to improve SSIS package performance.


Tim Mitchell

Tim Mitchell is a business intelligence consultant, author, and trainer. He has been working with SQL Server for over a decade, working primarily in business intelligence, ETL/SSIS, data quality, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas A&M at Commerce, and has been a Microsoft SQL Server MVP since 2010. Tim is an independent business intelligence consultant and a partner with Linchpin People, and is the principal at Tyleris Data Solutions. <BR><BR> As an active member of the community, Tim has spoken at international, regional, and local venues including the SQL PASS Summit, SQLBits, SQL Connections, SQL Saturday events, and various user groups and webcasts. Tim is coauthor of the book SSIS Design Patterns, and is a contributing author on the charity book project MVP Deep Dives 2. He is an active group member and speaker at the North Texas SQL Server User Group in the Dallas area. <BR><BR> You can visit his website and blog at TimMitchell.net or follow him on Twitter at twitter.com/Tim_Mitchell.

4:00 PM - Troubleshooting Seconday Replica Latency

Recording: <a href="https://www.youtube.com/watch?v=hLU1dMnYf18">https://www.youtube.com/watch?v=hLU1dMnYf18</a> <BR><BR> At times, you may experience latency on an AlwaysOn Availability Group (AG) Secondary Replica. Latency on an AG secondary replica can cause issues on the primary such as performance slow down on the primary (with SYNCHRONOUS secondaries), or excessive log file growth. This session will show you how to detect latency as well as discuss the main causes for latency. We will look at the performance counters typically used, as well as go through a demo or two showing both latency in “hardening” as well as latency in “REDO” operations.


Trayce Jordan

Trayce Jordan has been working with SQL Server for almost 20 years (since version 4.21 and 6.0 days). He is one of the first certified masters, holding an MCM for SQL 2005 and has been working at Microsoft since 2006. Prior to joining Microsoft, he worked for a major online travel company as well as financial institutions and has served as a consultant working with companies in many different industries. His specialties include database performance tuning, operations management and support, high availability and disaster recovery. Within Microsoft, Trayce has held several roles to include dedicated Senior Premier Field Engineer for DOD and intelligence agencies, as well as his current role as Senior Support Escalation Engineer.

5:00 PM - SQL Server Benchmarking: The Powershell Speedometer

Recording: <a href="https://www.youtube.com/watch?v=o5xs9pAjHsc">https://www.youtube.com/watch?v=o5xs9pAjHsc</a> <BR><BR> How fast do you think you were going? The only way to be sure is to have a reliable way to measure your performance. The challenge with SQL Server is that there are many aspects of your stack that you need to measure and understand. Powershell, with its ability to access and report on all these different levels, can give you a robust tool to benchmark your SQL Server. This session will cover benchmarking methodologies, the tools Powershell offers for capturing performance information, and will demonstrate how you can use them to measure performance statistics. After attending this session, you will understand how to effectively use Powershell to measure your database speed.


Mike Fal

Mike Fal is a musician turned SQL Server DBA, with 15+ years of experience as a database administrator. He has worked for many different industries, including healthcare, software development, marketing, and manufacturing and has experience supporting databases from 1 GB to 5 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.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids