Office of Administration Enterprise Server Farm

1
Office of AdministrationEnterprise Server Farm

• March 2006 Briefing

2
Agenda

• Server Refresh
• Database update
• MS SQL 2000 SP4
• Veritas i3 DB tool
• Oracle upgrade to 9.2.0.7
• Livestats update
• Hosting Solution Engine
• DSView 3.0 upgrade
• ESF general updates

3
Managed Services - Server Refresh

• Vincent Cheong

4
Server Refresh

• Background
• Various hardware reaching end-of-life and
  warranty
• Implementing new IBM hardware
• Servers utilizing old ESF Base Build
• Latest configuration standards
• Upgrading from Windows 2000/IIS 5.0 to Windows
  2003/IIS 6.0
• Better performance and security enhancements

5
Server Refresh

• Phase I - DSF Only
• Phase II - DSF with Custom Applications
• Phase III Custom Web and Application Servers
• Phase IV - Database Servers
• Phase V - Active Directory

6
Server Refresh

• Status of Phase I DSF Only
• Migrated Portal, Governor, DLI, IES, DSF
  Training, etc.
• Issues identified
• DSF functionality, e.g. routing approval.
• DSF - SQL Scheduled tasks, e.g. cut page
  (resolution identified and code being updated by
  Cimbrian)

7
Server Refresh

• Schedule
• Phase I Q4 2005/Q1 2006
• Phase II Q2 2006
• Phase III Q3 2006
• Agency software compatibility sign off before Mar
  31st https//www.esftools.state.pa.us/SoftwareCo
  mpatibility/
• Phase IV Q4 2006
• Phase V Q4 2006

8
Database update

• Eric Eyster

9
MS SQL 2000 SP4

• All SQL servers upgraded successfully except the
  Enterprise SQL database cluster.
• Estimated timeline for SQL Cluster
• Staging - April 10th
• Production April 23rd

10
Veritas i3 DB tool

• Optimize SQL response time by proactively
  monitoring, analyzing, and tuning SQL Server
  environment
• Provide a complete view of application
  performance by capturing, measuring, and
  correlating performance metrics
• Timeline Q2

11
Oracle upgrade to 9.2.0.7

• Background 
• Current Oracle version in ESF 9.2.0.5
• Oracle released Critical Patch Updates
• These patches are not supported for current
  version in ESF

12
Oracle upgrade to 9.2.0.7

• Pending agencies and vendor sign off for
  application compatibility
• Tentative schedule - Q2 2006
• Staging upgrade
• Agencies test and sign off
• Production upgrade
• Agencies test and sign off

13
Livestats update

• Eric Eyster

14
Livestats Update

• Some agencies reported errors with page and watch
  data
• ESF Worked with DeepMetrix support to
  troubleshoot issue
• Resolution and recommendation was to run the SQL
  database on the application server

15
Livestats Update

• Completed and tested in staging
• Completed in production
• Currently testing with agencies
• If you have any issues regarding data
  inconsistencies, please notify the ESF

16
Hosting solution Engine

• Robb Ritchey

17
Hosting Solution Engine

• What is HSE?
• Web interface for managing Hardware load-balanced
  servers
• Selectively suspend services to your web servers

18
Hosting Solution Engine

• Benefits of HSE
• Ability to perform server maintenance without
  affecting availability (Load balanced environment
  only)
• Ability to stop and start services by the
  agencies
• Provides real-time status of service health
• Accessible 24/7
• Only needed by Co-location customers

19

• Hosting Solution Engine

• Accessing HSE
• https//hse.oaesf.state.pa.us
• Login with CWOPA credentials
• Available only from MAN or via Dialup/VPN

20
Hosting Solution Engine

• Activate Real Activate and suspend services at
  the server level
• Activate Virtual Activate and suspend services
  for all servers associated with a Virtual IP

21
Hosting Solution Engine

• Services can be activated or suspended on the fly
• No traffic is sent to services having a weight of
  0

22
Hosting Solution Engine

• Clear Connections must be checked in order to
  delete existing connections to the server.

23
Hosting Solution Engine

• Real Time Stats will poll the load-balancer for
  live status information. This can be useful as
  the HSE only updates periodically every 30 secs

24
Hosting Solution Engine

• Agency Next Steps
• Create CWOPA group(s)
• Format AA-HSE_XXXXX
• Create ticket with ESF Technical Ops Team
• Request latest version of Co-location Doc
• Update ESF Co-location Document
• New Template _at_ http//www.oit.state.pa.us/esf/cwp/
  view.asp?a1q182423esfNav8041
• Submit updated doc for HSE Access

25
DSView 3.0 Upgrade

• Matt Wentling

26
DSView 3.0 Upgrade

• V3.0 Features
• New User Interface
• Hub and spoke server architecture for redundancy
• Exit macros log out or lock each user when a
  session window is closed
• Email notifications when selected events occur

27
DSView 3.0 Upgrade

• Impact to Customers
• Web browser interface
• Eliminates need for Citrix and Avocent specific
  client application
• Higher color resolution and faster screen scans
  to improve speed
• More intuitive interface
• Available from MAN or via Dialup/VPN
• Only affects Co-location customers
• Tentative Schedule Q2 2006

28
DSView 3.0 Upgrade Demo
29
ESF General Updates

• Steve Dunn

30
ESF General Updates

• Crystal Enterprise Upgrade
• Upgrade from CE ver 10 to CE ver 11
• CE10 support ends in June 8, 2007
• CR10 support ends Jan.7, 2007
• Migrate before end of life to avoid support
  issues
• Tentative schedule Q4 2006

31
ESF General Updates

• Enterprise Portal
• BEA Aqualogic Ver 6.0
• Architecture implemented
• Development, Staging, Production
• Governance and ROE document in progress
• Tentative Go-Live April 2006
• Contact Mark Rogers (OA)

32
ESF General Updates

• Interim Site Update
• Disaster Recovery Plan
• Committee established
• ESF Managed Services
• JNET
• GIS
• Exchange
• Phased approach based on funding

33
ESF General Updates

• Help Desk Process
• Initiation
• Remedy Ticket
• Call Center [phone] Option1
• OA ESF Application Management Team (MS)
• OA ESF Technical Operations Team (Co-lo)
• Ticket Details
• Detailed problem description
• Valid Contact information
• Phone and email
• Ensure requestor is available for call back for
  urgent or high tickets.

34
ESF General Updates

• Help Desk Process
• Priorities
• Urgent
• Production Application unavailable
• High
• Critical Portions of Production Application
  unavailable
• Medium
• Minor issue not requiring immediate attention
• Low
• Question or Informational Request
• Escalation
• Timeframes and Contacts defined in Document
• Process Document
• http//www.oit.state.pa.us/esf/cwp/view.asp?a7Q
  125093esfNav

35
Resource Links

• ESF Web Site
• http//www.oit.state.pa.us/esf
• Windows 2003 compatibility sign off
• https//www.esftools.state.pa.us/SoftwareCompatibi
  lity
• Help Desk
• [phone] Option 1
• http//www.oit.state.pa.us/esf/cwp/view.asp?a7Q
  125093esfNav
• HSE Reference Document
• http//www.oit.state.pa.us/esf/lib/esf/hosting_sol
  ution_engine_usage_guide.pdf

36
Thank You!Questions?