The SQL PASS Performance Virtual Chapter has put together an exceptional event this week called the Summer Performance Palooza, an encore to the highly attended Winter Palooza held last December. The Palooza will take place this Thursday, June 27, with an all-star lineup of SQL experts that promises to deliver a full day of high quality SQL Server Performance sessions. The day begins with three morning sessions if you live in the Americas, starting at 10am Central Time/3pm GMT. These sessions, while not beginner level, cover foundational topics in SQL Server such as indexing, statistics and bad performance habits that are required knowledge for any DBA. Jes, Erin and Aaron will show you practices and techniques that you can put to use today to achieve top database performance.
10am Jes Borland Index Methods You’re Not Using
11am Erin Stellato Updates to Statistics and the Effect on Query Performance
12pm Aaron Bertrand 10 Bad Habits that can Kill Performance
These sessions are followed by Wendy Pastrick showing us how to use our old friend Performance Monitor in a virtualized environment. This is important for so many DBAs dealing with virtual databases today, and knowing how to interpret PerfMon data is vital to pinpoint virtual DB performance problems.
1pm Wendy Pastrick Using Performance Monitor for your Virtual Servers
The afternoon delivers three sessions that show you how to approach, attack, and solve SQL Server performance issues. Janis, Brian and Brent will take you beyond the obvious and get you digging into areas of SQL Server you may not have known existed.
2pm Janis Griffin Looney Tuner? No, there IS a method to my madness!
3pm Brian Flynn Pivoting Performance Data & Pinpointing Problems
4pm Brent Ozar How the SQL Server Engine Thinks
Finally, Todd Kleinhas shows us how to quickly and easily build a SQL Server Lab using virtual machines to help us solve our performance issues. Make sure to catch this session if you are in need of spinning up environments to run through specific scenarios or to facilitate repeatable testing.
5pm Todd Kleinhas How to Build an Affordable SQL Server Lab
The Performance VC wants to thank our sponsor Confio whose support as our sponsor has helped us get this done for you. Click here to go to the Performance Virtual Chapter web site and register. See you Thursday!