Invitation

SQL Server Performance Workshop: New York City

Executive Summary

On February 4 & 5, the Microsoft Oracle Center of Excellence will be hosting a SQL Server Performance Workshop at the Microsoft office in New York. This workshop is free to all customers.

The content focuses on how to run a high performance SQL Server environment with ERP & CRM software, with specific focus on Siebel, PeopleSoft, and JD Edwards.

Workshop Content

There are many classes that cover SQL Server. There are also just as many that cover Oracle Applications… but very few cover the intersection of the two.

This two day workshop covers the specifics of how the Oracle application interacts with SQL Server and how to architect a scalable and highly available solution. Its focus starts at the ODBC level and goes down to the disk.

Emphasis is on isolating issues, finding problems before they happen, and performance tuning. The goal of the workshop is to move beyond "my system's slow" into WHY it's slow and how to fix it. We'll cover: what to look at, what it means, and what "good" & "bad" look like on a wide variety of platforms.

While the workshop is in lecture format, real world examples are used exclusively in the form of perfmon and profiler traces in addition to numerous trip reports and health checks that have been done with customers over the last 5 years. We'll use out of the box tools and basic scripts to gather up information and apply common sense techniques to come up with answers.

Skills learned in this workshop can also be applied to other enterprise applications in your landscape.

Target Audience: DBAs, Siebel/PeopleSoft/JD Edwards Administrators, Consultants

Topics Covered

·         Top Reasons for SQL Server 2005/2008

·         Query Repro: Reproducing Problem Queries Outside of the Application and Tools to Fix Them

·         Performance Tuning Methodology: A Repeatable Process

·         Hands on Performance Tuning Lab

·         Databases & Disk Drives: Architecting a Scalable Solution

·         SQL Server Settings

·         Case Study Handouts

·         Architecting for RSCI

·         SQL Server Compression

·         Hyper-V and Virtualization

Location & Registration

The workshop will be held at the Microsoft office in New York City:

February 4 & 5

9:00 - 16:00

Microsoft Corporation

1290 Avenue of the Americas, Sixth Floor

New York, NY 10104

Phone: (212) 245-2100

Fax: (212) 245-3290

To register for the event, please email Susan Meyer.

Local Contact:

Harv Sidhu

harvs@...

Additional details are available by contacting Harv Sidhu, MOCE Database Evangelist.

For a complete list of all workshops in Europe & United States locations, abstract, workshop & lab content, and logistics, please click on the following link for our newsletter: MOCE Events 2009 Q1.

To Register for the event, contact Susan Meyer. For more information, contact Harv Sidhu.