March 9 6-8:30pm
This month's meeting sponsored by
Speaker: David Pless
David has been a Senior Premier Field Engineer with Microsoft for three years. As a PFE he performs health checks, conducts chalk talks, and full training workshops. He also works on reactive and proactive engagements on SQL Server 2005 and 2008. He mainly supports the Southeast focusing on Florida, but can be anywhere in the world.
Core areas are performance tuning and optimization, mirroring, Reporting Services (SSRS), and Integration Services (SSIS) and other areas suchas consolidation, table partitioning, resource governor, performance data warehouse, SQL Server auditing and more.
Prior to working for Miscrosoft David was a freelance consultant and also worked for Intellinet as an MCS Partner Consultant starting the SQL Server practice at the Atlanta based consulting form. PRior to Intellinet David was a DBA for CheckFree Corpportation in Norcross, Georgia for over 6 years. David has worked with SQL Server since version 6.5 and has been an active member of the SQL Server community for years.
Topic: SQL Server 2005/2008 Performance Tuning and Optimization Techniques
This discussion will cover how to troubleshoot performance issues on SQL Server 2005 and 2008. It will cover performance impact analysis using DMVs, Set Options in SQL Server, and Profiler and perfmon anlaysis. It also includes SQLNexus, PAL (Performance Analysis of Logs), RML Utilities, SQLDiag, and other tools. Finally we will discuss reading graphical query plans and what you can learn from reading the XML plans.
If time permits we will also cover Performance Data Warehousei n SQL Server 2008, new features in 2008 regarding missing indexes, viewing query plans, and Extended Events.
- Build a repeatable performance base to verify I/O's, identify missing indexes, identify out of date statistics, and more.
- Become aware of new SQL Server tools that help the DBA better analyze and attack performance issues such as SQL Nexus, PAL, RML Utilities, XML Notepad to read XML Plans, and more.
- As tim epermits to be aware of new features in SQL Server 2008 to get a handle on perfomance such as Perfomance Datawarehouse, changes to SQL Server Management Studio, Resource Governor, and Extended Events
Please email firstname.lastname@example.org to RSVP.
For directions visit the OPASS web site.
Hope to see you there, either in person or virtually.