Sales Ended

Improving the Performance of Third-Party Vendor SQL Server Databases

Event Information

Share this event

Date and Time

Refund Policy

Refund Policy

Refunds up to 1 day before event

Event description

Description

Microsoft Certified Master Bob Pusateri leads this full-day course on improving SQL Server performance for third-party vendor applications. 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 event runs in two four-hour windows, 1-5pm on Tuesday, July 18th and Wednesday, July 19th, so that data professionals can attend without having to take an entire day away from their ongoing responsibilities.

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

Attendees with the following experiences will benefit the most from this course:

  • Basic familiarity with the core components of Microsoft SQL Server
  • Experience with database table design and query construction
  • Exposure to Windows/SQL Server performance metric measurement and identification

A set of slides and relevant documentation will be provided to attendees to aid in performance tuning their own environments.

Date and Time

Refund Policy

Refunds up to 1 day before event

Save This Event

Event Saved