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
New York, NY
Los Angeles, CA
San Francisco, CA
Please view the complete logistics at: www.computationpress.com
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.
Please e-mail Susan Meyer at firstname.lastname@example.org to register for the event.
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