OPASS March Meeting with David Pless

Jack Corbett, 2010-03-08

March 9 6-8:30pm

This month’s meeting sponsored by Quest Software

Live Meeting: https://www.livemeeting.com/cc/usergroups/join?id=QFG3GW&role=attend

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.


  1. Build a repeatable performance base to verify I/O’s, identify missing indexes, identify out of date statistics, and more.
  2. 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.
  3. 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 webmaster@opass.org to RSVP.

For directions visit the OPASS web site.

Hope to see you there, either in person or virtually.





Related content

Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?

Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.

Robert Davis


1,567 reads

Networking – Part 4

You may want to read Part 1 , Part 2 , and Part 3 before continuing. This time around I’d like to talk about social networking. We’ll start with social networking. Facebook, MySpace, and Twitter are all good examples of using technology to let…

Andy Warren


1,530 reads

Speaking at Community Events – More Thoughts

Last week I posted Speaking at Community Events – Time to Raise the Bar?, a first cut at talking about to what degree we should require experience for speakers at events like SQLSaturday as well as when it might be appropriate to add additional focus/limitations on the presentations that are accepted. I’ve got a few more thoughts on the topic this week, and I look forward to your comments.

Andy Warren


360 reads