Transcript The Data Store and SQL Server Deployment Strategies and

The Data Store and SQL Server
Deployment Strategies and Troubleshooting
Frank Marzullo
Senior Escalation Engineer, Critical Situation response team
May 8, 2012
Tweet about this session with
hashtag #SUM305 and
#CitrixSummit
#CitrixSummit
2
Agenda
• XenApp Data Store deployments and challenges
• High Performance Vs. High Availability
• Tools and Troubleshooting Methodology
• SQL Replication and the identity crisis
• XenApp 6.5 Improved IMA performance
#CitrixSummit
3
XenApp Data Store
Deployments and Challenges
Quick Access
Where do I put my Data Store ?
&
Always Available
#CitrixSummit
5
IMA Communication
• IMA Ping – 20 byte per minute if no update data has been
received in the past 60 seconds.
• Read operations– happen via port 2512
• Write operations – happen via port 2513
• IMA Change notifications – also via port 2512
#CitrixSummit
6
IMA Change Notification
Data
Store
2512
2512
ZDC
Zone 1
Members
Zone 1
2512
2513
2512
2512
Member
Any Zone
#CitrixSummit
2512
ZDC
Zone 2
Members
Zone 2
7
What is IMA?
1011011010 SSL 1011011010 SSL 1011011010 SSL 1011011101101110 11
Data Store
#CitrixSummit
8
#CitrixSummit
9
What is the Data Store ?
#CitrixSummit
10
IMA access method
IMA
1011011010
ODBC
#CitrixSummit
1011011010 SSL 1011011010 SSL 1011011010 SSL 1011011101101110 11
Data Store
11
Pre – XenApp 6.0
Post– XenApp 6.0
Stored Procedures
Citrix Confidential - Do Not Distribute
What is a Schema ?
Citrix Confidential - Do Not Distribute
XenApp 5.0 & 4.5
#CitrixSummit
XenApp 6.0 & 6.5
14
Farm Data Sets
• Persistent Store
• Farm Data Base hosted on SQL or Oracle
• Local Host Cache (LHC)
• Dynamic Store
• Volatile data stored in memory on Zone Data Collectors or Controllers only.
#CitrixSummit
15
High Performance
Vs.
High Availability
Which do I choose ? Why can’t I have both ?
• Cost ?
• Infrastructure Requirements ?
• Infrastructure Management ?
• Complexity Vs. Simplicity ?
#CitrixSummit
17
SQL Options at a glance
Replication
Mirroring
• High Performance over WAN.
• Special considerations for high
latency WAN applications.
• Transparent to IMA
• Recommended for Geographically separated
XenApp Farms.
#CitrixSummit
• Transparent to IMA
• Recommended for –
Disaster Recovery scenarios.
18
Resources for SQL Replication & Mirroring
• XenApp 6 and 6.5 SQL Replication Important Considerations
• SQL Server 2005 Mirroring and Replication Caveats
• Data Store Replication with XenApp 5.0 using SQL 2008 with Windows
Authentication
• Datastore Replication with XenApp 5.0 using SQL 2005 SP2 with Windows
Authentication
• Database Mirroring Best Practices and Performance Considerations
• Using SQL Database Mirroring to Improve Citrix XenApp Server Farm Disaster
Recovery Capabilities
Citrix Confidential - Do Not Distribute
Options at a glance
Physical Server Clusters
Virtual Server Instances
• Very High TCO
• Lowest TCO with XenServer
• #1 HA solution for LAN’s
• Dynamic Server Provisioning
• Transparent to Application
• Fast recovery from Snap Shot
#CitrixSummit
20
Resources for virtualizing SQL on XenServer
• Virtualizing SQL Server 2008 with XenServer - Blog
• Virtualizing SQL Server 2008 with XenServer – White Paper
Citrix Confidential - Do Not Distribute
Deprecated features in SQL 2012
Deprecated Features of Transactional Replication - The following
transactional replication features were deprecated in SQL Server 2005 or SQL
Server 2008.
Updatable subscriptions including
immediate updating and queued
updating with snapshot and
transactional publications ¹
#CitrixSummit
(Microsoft) recommends that you use
peer-to-peer transactional replication
instead.
22
#CitrixSummit
23
Tools and Troubleshooting
Methodology
Tools and Troubleshooting Methodology
• Citrix Diagnostic Facility Trace (CDF)
• SQL Server Profiler Trace
#CitrixSummit
25
Tools and Troubleshooting Methodology
• Msg 548, Level 16, State 2, Line 134 The insert failed. It
conflicted with an identity range check constraint in database
'YourDB', replicated table 'dbo.yourTABLE', column 'nodeid'.
#CitrixSummit
26
SQL Replication and the
“Identity Crisis”
Unique Identifier
Track Changes
Added by SQL
#CitrixSummit
28
SQL Replication and the identity crisis
• What is the “Identity Crisis” ?
• Who does it affect ?
• How do I deal with it if it happens to me ?
#CitrixSummit
29
Resources
• CDF Trace - CTX111961
• SQL Profiler Templates for IMA issues
• SQL 2005 Template
• SQL 2008 Template
• Data Store Replication checker tools
• For XenApp 5.0 and earlier - CTX111656
• For XenApp 6 - CTX124815
• HOW TO: Troubleshoot Application Performance with SQL Server
• SQL Diag & SQL Diag configuration Tool
Citrix Confidential - Do Not Distribute
He who fails to plan
is planning to fail.
- Winston Churchill (WW II)
#CitrixSummit
31
Best Practice & Learning Resources
• Advanced Concepts - XenApp Farm Maintenance
• Best practices for creating the Citrix Presentation Server data store on SQL 2005
• Best Practices for XenApp Administrators
#CitrixSummit
32
Learning Resources
• SQL Back ups – recovery models
• Working with tempdb in SQL Server 2005
• SQL Server Index Fragmentation and Its Resolution
#CitrixSummit
33
XenApp 6.5 Improved IMA
performance
XenApp 6.5 Improved IMA performance
• XenApp 6.5 introduces the Dynamic Data Center Provisioning
• In XenApp 6.5, servers can be configured in Session-host mode
• By Default XenApp servers are configured as Controllers
• Session-only XenApp servers run in a light-weight mode whose sole function is
to host XenApp sessions and nothing more.
• Speeding up Farm Deployments with XenApp 6.5 – Part 1
#CitrixSummit
35
XenApp 6.5 Improved IMA performance
The table below shows the functionality of the Controller vs. Session-only roles.
#CitrixSummit
36
#CitrixSummit
37
One last resource
• XenApp 6.5 Enterprise Scalable XenApp Deployments
This Scalability Document created by our product engineering and test team
provides granular details regarding the test scenarios and results shared in
previous slide and new improvements seen during RTM testing of XenApp 6.5
Citrix Confidential - Do Not Distribute
Key session takeaways:
• XenApp Data Store deployments and challenges
• Tools and Troubleshooting Methodology
• XenApp 6.5 Improved IMA performance
Citrix Confidential - Do Not Distribute
Tools as a Service
http://Taas.Citrix.com/Beta
1
2
3
Data Collection
Quickly collect and
upload your data
#CitrixSummit
Auto analysis
health check
Recommendations
tailored to YOU
40
Tools as a Service
http://Taas.Citrix.com/Beta
Find out how to rev up environment maintenance
See your Citrix pit crew in the expo hall with the
checkered racing shoes
#CitrixSummit
41
We value your feedback!
Take a survey of this session now in the mobile app
• Click 'Sessions' button
• Click on today's tab
• Find this session
• Click 'Surveys'
#CitrixSummit
Before you leave…
• Conference surveys are available online at www.citrixsummit.com starting
Thursday, May 10
○
Provide your feedback and pick up a complimentary gift at the registration desk
• Download presentations starting Monday, May 21, from your My Organizer tool
located in your My Account
#CitrixSummit