SQL Server Performance Workshop

SQL Server Performance Workshop: ERP & CRM

This two day Microsoft taught workshop covers the specifics of how the Oracle application (Siebel, PeopleSoft, JD Edwards) 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.

 

Cities Taught In

Zurich, Switzerland

Tallinn, Estonia

Stockholm, Sweden

New York, NY

Los Angeles, CA

San Francisco, CA

Please view the complete logistics at: www.computationpress.com

 

Abstract

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

Working knowledge of SQL Server is encouraged.

 

Event Registration

Please e-mail Susan Meyer at v-sumeye@microsoft.com to register for the event.

 

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