Andrew Babiec Manager Development Services Tallan BIZTALK SERVER

Andrew Babiec Manager, Development Services Tallan BIZTALK SERVER 2006 HIGH AVAILABILITY, FAULT TOLERANCE, AND SCALABILITY

Tallan Company Overview Founded in 1985 Headquartered in Rocky Hill, CT Offices in Santa Ana, Manhattan, Tampa, and Boston Over 100 technology consultants with a wide range of expertise and knowledge Over 20 consultants located in the Southern California (LA/OC) area Emphasis on current technology trends and talent

Tallan Clients Since 1985, Tallan has worked at over 400 clients, including, Walt Disney Internet Group Ingram Micro Experian Oakwood Worldwide ING Bank of America Lincoln Financial • • • Talbots Best Buy Ann Taylor e. Bay Barnes & Noble CVS Columbia House Dell u. Bid. com

Tallan Solution Areas Custom Application Development J 2 EE and. NET Web Development Web 2. 0/Community/Social Media E-Commerce Internal System Development Business Intelligence (BI) SOA / BPM / EAI (Biz. Talk) Portals, Collaboration, and Content Management

Agenda High availability concepts Biz. Talk Server 2006 “Farm” demo Biz. Talk Server database disaster recovery Performance tips and best practices

Prerequisite Knowledge Microsoft® Biz. Talk® Server administration, development, and deployment Microsoft® Windows® security Microsoft® SQL Server™ administration

Biz. Talk Server High Availability Concepts and goals Fault tolerant server infrastructure Eliminate single points of failure High performance and scalability Avoid resource bottlenecks Security Reduce downtime due to breaches Backups and disaster recovery Recovering from catastrophic failures

Biz. Talk Server High Availability Distributed Architectures Purpose of Distributed Architectures (“Farms”) High availability High performance “Active-Active” configuration by virtue of use of the Biz. Talk Message. Box Messages and state are persisted at predetermined persistence points No Hardware affinity Microsoft Cluster Services support For very specific components MSMQ, MQ Series adapters Enterprise SSO redundancy Biz. Talk Server 2006 host process is cluster aware

Zero Availability Architecture Single Server

High Availability Architectures Small Biz. Talk Server deployment

SQL Server Cluster options

High Availability Architectures Medium-sized Biz. Talk Server deployment

High Availability Architectures Large scale Biz. Talk Server deployment

Multiple Message. Box Databases High Availability with SQL Clustering

Multiple Message. Box Databases Minimum of 3 – otherwise no benefit One Master messagebox Used for Routing Disable new message publication (be careful if using MSMQT) Multiple secondary messageboxes Used for Processing Load Balancing is automatic and handled by Biz. Talk automatically

Biz. Talk Server Farm Demo This demo assumes familiarity with Biz. Talk messaging and orchestration Biz. Talk MSI deployment procedures 2 Hosts running on a laptop 1 x SQL Server node 2 x Biz. Talk Servers (one in a VM)

Biz. Talk Server Farm Demo Scenario will illustrate Biz. Talk Server farm deployment Publish/subscribe and architecture of the Message. Box Hosts and host instances

Biz. Talk Server 2006 “Farm”

Providing High Availability for the BAM Databases Cluster the BAM Primary Import database and the BAM Analysis database Define an online window. Schedule DTS packages to run periodically Carefully choose small sets of data items (checkpoints), and avoid including unnecessary data items when defining an activity

Providing High Availability for the BAM Databases (continued) Understand the trade-offs between scheduled and real-time aggregations when you design your aggregations. If you choose scheduled aggregations, make sure you schedule the cubing DTS to run more frequently than the archiving DTS. Enable the BAM Event Bus Service in multiple computers to obtain failover functionality

Behavior of Biz. Talk Host Instances during SQL Server Failover Behavior of In-process host instances during SQL failover Will be recycled until the connection to the SQL Server is restored. Once restored, document processing resumes normally. Behavior of Isolated host instances during SQL failover Will pause and disable receive locations. Wehn databases become available, the receive locations will be automatically enabled.

SQL Server Database Mirroring Not supported Use log shipping instead.

Biz. Talk Database Disaster Recovery Steps Backup Configure Scheduled Backups Store Backup files offsite Log Shipping Configure destination (backup) SQL server Restore to SQL Server Reconfigure Biz. Talk Servers Test your restore procedures!

Troubleshooting Message. Box Latency Issues The Biztalk Host instance that has the "allow Host tracking" option set is stopped SQL Server Agent is not running or SQL Server Jobs are disabled Biz. Talk. DTADb database grows excessively Excessive Disk I/O Latency Retain minimal data in the Biz. Talk. DTADb database so that runtime performance is not sacrificed

Biz. Talk Server Administration Deployment Options Prescribed method: MSI Files Batch files and WMI scripts BTSTask (previously BTSDeploy) BTSDeploy will remain supported in 2006 forward compatibility 3 rd party and unsupported tools NAnt (http: //www. traceofthought. com) Biz. Talk Assembly Checker (ships with 2006) Community development (http: //www. gotdotnet. com/)

Biz. Talk Server High Availability Best Practices Design Robust Infrastructures Microsoft® SQL Server™ Cluster Biz. Talk Distributed Architecture (Farm) Multiple Message. Boxes for higher volumes Plan Hosts and host instances carefully Understand the Biz. Talk development life cycle Biz. Talk Server 2006 “applications” concept Allocation of Biz. Talk artifacts into separate assemblies

Biz. Talk Server High Availability Best Practices Plan and test your disaster recovery strategy Backing up your Biz. Talk Databases Biz. Talk Log Shipping Archiving and Purging Document Tracking DB Documentation Hardware Architecture Server Operations Implemented Solution Architectures Deployment procedures

Session Summary Role of the administrator High availability concepts Biz. Talk Server 2006 “Farms” – Scale Out! Biz. Talk Server Data DR – Test restores Best practices and recommendations

For More Information Read http: //www. microsoft. com/biztalk/en/us/white-papers. aspx http: //technet. microsoft. com/en-us/biztalk/default. aspx Biz. Talk Documentation (Help File) Learn http: //www. microsoft. com/biztalk/techinfo/virtual-labs. mspx Blogs and Newsgroups http: //blogs. msdn. com/Biztalk_Core_Engine http: //blogs. msdn. com/biztalk_server_team_blog/ http: //blogs. msdn. com/Biztalk_Core_Engine Community Developed Tools http: //www. gotdotnet. com/workspaces (search for “Biz. Talk”)

Contact Information Tallan Microsoft Gold Certified Partner Andrew Babiec Manager, Development Services Tallan ababiec@tallan. com

Q&A Thank You