1 / 44

The Data Store and SQL Server Deployment Strategies and Troubleshooting

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. 2. Agenda. XenApp Data Store deployments and challenges

mimir
Télécharger la présentation

The Data Store and SQL Server Deployment Strategies and Troubleshooting

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May 8, 2012

  2. Tweet about this session with hashtag #SUM305 and#CitrixSummit #CitrixSummit 2

  3. 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

  4. XenApp Data Store Deployments and Challenges

  5. Quick Access & Always Available Where do I put my Data Store ? #CitrixSummit 5

  6. 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

  7. IMA Change Notification 2512 Data Store 2512 Z D C Zone 1 Members Zone 1 2512 2513 2512 2512 2512 Member Any Zone Z D C Zone 2 Members Zone 2 #CitrixSummit 7

  8. What is IMA? Data Store #CitrixSummit 8 1011011010 SSL 1011011010 SSL 1011011010 SSL 1011011101101110 11

  9. #CitrixSummit 9

  10. What is the Data Store ? #CitrixSummit 10

  11. IMA access method IMA 1011011010 ODBC Data Store 1011011010 SSL 1011011010 SSL 1011011010 SSL 1011011101101110 11 #CitrixSummit 11

  12. Pre – XenApp 6.0 Post– XenApp 6.0 Stored Procedures Citrix Confidential - Do Not Distribute

  13. What is a Schema ? Citrix Confidential - Do Not Distribute

  14. XenApp 6.0 & 6.5 XenApp 5.0 & 4.5 #CitrixSummit 14

  15. 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

  16. High PerformanceVs.High Availability

  17. Which do I choose ? Why can’t I have both ? • Cost ? • Infrastructure Requirements ? • Infrastructure Management ? • Complexity Vs. Simplicity ? #CitrixSummit 17

  18. SQL Options at a glance Replication Mirroring High Performance over WAN. Transparent to IMA Recommended for -Geographically separated XenApp Farms. • Special considerations for high latency WAN applications. • Transparent to IMA • Recommended for – Disaster Recovery scenarios. #CitrixSummit 18

  19. 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

  20. Options at a glance Physical Server Clusters Virtual Server Instances Very High TCO #1 HA solution for LAN’s Transparent to Application • Lowest TCO with XenServer • Dynamic Server Provisioning • Fast recovery from Snap Shot #CitrixSummit 20

  21. 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

  22. 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. #CitrixSummit 22

  23. #CitrixSummit 23

  24. Tools and Troubleshooting Methodology

  25. Tools and Troubleshooting Methodology • Citrix Diagnostic Facility Trace (CDF) • SQL Server Profiler Trace #CitrixSummit 25

  26. 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

  27. SQL Replication and the “Identity Crisis”

  28. Unique Identifier Track Changes Added by SQL #CitrixSummit 28

  29. 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

  30. 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

  31. He who fails to planis planning to fail. - Winston Churchill (WW II)

  32. 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

  33. Learning Resources • SQL Back ups – recovery models • Working with tempdb in SQL Server 2005 • SQL Server Index Fragmentation and Its Resolution #CitrixSummit 33

  34. XenApp 6.5 Improved IMA performance

  35. 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

  36. XenApp 6.5 Improved IMA performance The table below shows the functionality of the Controller vs. Session-only roles. #CitrixSummit 36

  37. #CitrixSummit 37

  38. 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

  39. Key session takeaways: • XenApp Data Store deployments and challenges • Tools and Troubleshooting Methodology • XenApp 6.5 Improved IMA performance Citrix Confidential - Do Not Distribute

  40. http://Taas.Citrix.com/Beta Tools as a Service 1 2 3 Data Collection Quickly collect and upload your data Auto analysis health check Recommendations tailored to YOU

  41. http://Taas.Citrix.com/Beta Find out how to rev up environment maintenance See your Citrix pit crew in the expo hall with the Tools as a Service checkered racing shoes

  42. 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'

  43. 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

More Related