Upcoming Events

Heraflux is a proud supporter of technical and business community events all over the world.
Loading Events

« All Events

  • This event has passed.

SQL Saturday Iowa City 2017 Precon – Improving the Performance of Third-Party Vendor SQL Server Databases

June 9, 2017 @ 8:00 am - 5:00 pm

Microsoft Certified Master Bob Pusateri leads this full-day course on improving SQL Server performance for third-party vendor applications in advance of this year’s SQL Saturday Iowa City. It’s not uncommon for applications to demonstrate lousy performance due to suboptimal schema design or poorly-performing database queries, and you know how to make it better. However, many vendors make it either impossible or outright forbidden to change that code. This all-day course will focus on the many options that Microsoft SQL Server offers to improve the performance of an application without altering its queries. Attendees will be exposed to numerous performance tuning practices at both the SQL Server and infrastructure levels, and will learn how to review key points of their stack to ensure optimal SQL Server performance for almost any vendor application.

The following topics will be addressed during the course:

  • Wait Statistics
  • Execution Plans
  • Query Store
  • Plan Guides
  • Monitoring
  • Blocking and Locking
  • Primary and Foreign Keys
  • Parallelism
  • Server Configuration
  • Indexing & Statistics
  • Routine Maintenance
  • Hardware & Infrastructure
  • Tools & Scripts

Upon completion of this course, attendees will be able to:

  • Monitor relevant metrics and calculate a performance baseline for an application
  • Review their own enterprise infrastructure for performance bottlenecks
  • Determine the optimal SQL Server configuration for best performance of an application

Details

Date:
June 9, 2017
Time:
8:00 am - 5:00 pm
Event Categories:
,
Event Tags:
,

Venue

University of Iowa – University Capitol Centre
201 S. Clinton Street
Iowa City, IA 52240 United States
+ Google Map