Birds Fly South to MigrateBirds Fly South to MigrateA SASA SAS® 9.2 Migration Need Not 9.2 Migration Need Not

Session 286-2010

Maureen ChewPrincipal Software EngineerOracle Corporationmaureen.chew@oracle.com

Birds Fly South to MigrateA SAS 9.2 Migration Need Not

Maureen Chew

Principal Software Engineer

maureen.chew@oracle.com

SAS Global Forum 2010, Seattle, WA

Session 286-2010blogs.sun.com/MaureenChew

Agenda

SAS 9.2 Upgrade LandscapePromotion vs. Migration

Migration OverviewExport, import process

Migration in actionMigration Mistakes and MishapsCase Study Testimonial

Agile Deployment StrategiesVirtualization Made Simple with Solaris 10 ContainersZip-a-dee-doo-dah, zip-a-dee-ay, ZFS Clones are the way

Java Application Server Performance Case Study

SAS 9.2 Upgrade Landscape

Fresh startPromotionMigrationRequirements

Platform & deployment topology must remain the sameSupported in Maintenance 3

Can change Java application server ( Apache Tomcat → Oracle WebLogic)Must remain @ same deployment level ( Lev1 → Lev1)9.1.3 SP4 minimum + HotFixesXythos webdav version 4.0.48 or later

Exporting SAS 9.1.3 Contentsmu.sh ( SAS Migration Utility )

Metascript run on 9.1.3 system for data export

-outputdir houses AnalysisReport subdirectoryIncludes 2 files of interest

FullReport.html ErrorWarningReport.html

Migration Overview

$ ./smu.sh --target ./shrgen -- \-outputdir /export/home/users/sasmau/shrgenoutput \ -sasconfigdir /install/dashboard/SAS/Lev1 \-sasexedir /install/dashboard/software/SAS_9.1 \-metadatahost shrgen -davtier -user sas -password <password>

Importing Content to SAS 9.2

Use SAS Deployment Wizard (SDW) + Plan file to install and/or configure$SAS_CONFIG/Lev1/DocumentsDeploymentSummary.htmlInstructions.html

Post install, config, validation checklistExamples: How to start Metadata, Workspace, Connect, Share, … serversApp access points (WebReportStudio)

Migration in ActionMigration Mistakes and Mishaps

Lots of them possibleDon't install as rootWeb container (on Solaris) must be installed with 64-bit JVM supportsmu.sh version mismatch

Can't use 9.2M2 smu.sh with 9.2M3 install

Migration in Action Case Study Testimonial

Humana Healthcare - Don Kros, Lousiville, KY– SAS 9.2 Migration: ✓

Upgrade from SAS 9.1.3 to SAS 9.2 went very smoothlySmall pain points

Stored processesEM – custom codeCubes – required code to rebuild

ExportCube, ImportCube now available in M2Getting your Cubes from Here to There: Migration and Promotion of OLAP Cubes in SAS 9.2 paper 306-2010, Jana Van Wyk

Take away: “Don't upgrade development work”

Agile Deployment StrategiesVirtualization Made Simple with Solaris Containers

Consolidate Dev / Test / ProdSupport parallel 9.1.3 and 9.2 environmentsPromotion from Dev → Prod

Return of the Clones molly(9.1.2) → dolly1(9.2 test) → dolly2(9.2 prod)

Zip-a-dee-doo-dah, zip-a-dee-ay, ZFS clones are the way

Clones R Us Not to be confused with Solaris Container clones

ZFS Snapshots / ClonesQuick, easy, painless, economicalCan be used as integral part of backup, maintenance and upgrade deployment architectures

Working with ZFS Snapshots and ClonesZebra, Zamboni, Zen and the Art of ZFSBackup: When Disaster Strikes, What Will You Do?

Java Application Server Performance Considerations

Could be a week long case studyCase Study

Collaborative effort with SAS Enterprise Excellence CenterSun Fire Enterprise M90003 containers (OMR, Java app mid-tier, SAS Workspace services), Oracle 11gR2 data storeSAS 9.2 BIJeff Taylor bloghttp://blogs.sun.com/taylor22/entry/java_monitoring_and_tuning_example

Java Application Server Performance Considerations

SAS 9.2 Web Applications: Tuning for Performance and ScalabilityNo 1 size fits all set of Java options – the right set is a deployment fingerprint

Eden?Eden?

Tenured?Tenured?

Survivor?Survivor? Perm?Perm?

GC??GC??

????????????

Java Application Server Performance Case Study

Initial “Out of the doc Java parms”Heap management: not ideal, but not worth tweakingGoodness established

Increase loadBadness happens

TuningGoodness restoredDon't worry, Be HappySleepness In Seattle no more

Java Application Server Tuning

What's not to likeGC constantly runningSurvivor space unusedVery fast Eden GCsCMS not able to hold Old Gen down

Java Application Server Tuning

What we did

Tripled total heap to enable room for improvement -Xmx 2m->6m

Increased Eden max 6X; -XX:MaxNewSize= 1.5M

Added SurvivorRatio=4 to “promote” survivor space usage

Result: GC under control, workload tripled with no performance loss

Acknowledgements

A special thanks toBilly Dickerson, SAS R&DGreg Smith, SAS Enterprise Excellence CenterMarcus Heckel, Strategic Applications Engineering, OracleJeff Taylor, ISV Engineering, OracleSunil Gupta, Quintiles, SAS Global Forum Systems Architecture Chair

Birds Fly South to MigrateA SAS 9.2 Migration Need Not

Maureen Chew

Principal Software Engineer

maureen.chew@oracle.com

SAS Global Forum 2010, Seattle, WA

paper 286-2010