the data store and sql server deployment strategies and troubleshooting frank marzullo senior...
TRANSCRIPT
![Page 1: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/1.jpg)
The Data Store and SQL Server Deployment Strategies and Troubleshooting
Frank Marzullo
Senior Escalation Engineer, Critical Situation response team
May 8, 2012
![Page 2: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/2.jpg)
Tweet about this session with
hashtag #SUM305 and
#CitrixSummit
#CitrixSummit 2
![Page 3: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/3.jpg)
• 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
Agenda
#CitrixSummit 3
![Page 4: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/4.jpg)
XenApp Data Store
Deployments and Challenges
![Page 5: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/5.jpg)
Quick Access
&
Always Available
Where do I put my Data Store ?
#CitrixSummit 5
![Page 6: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/6.jpg)
• 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
IMA Communication
#CitrixSummit 6
![Page 7: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/7.jpg)
IMA Change Notification
Z D CZone 2
DataStore
MemberAny Zone
Z D CZone 1
2513
2512
2512
MembersZone 1
MembersZone 2
2512
2512
2512
2512
#CitrixSummit 7
![Page 8: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/8.jpg)
What is IMA?
Data Store
1011011010 SSL 1011011010 SSL 1011011010 SSL 1011011101101110 111011011010 SSL 1011011010 SSL 1011011010 SSL 1011011101101110 11
#CitrixSummit 8
![Page 9: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/9.jpg)
#CitrixSummit 9
![Page 10: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/10.jpg)
What is the Data Store ?
#CitrixSummit 10
![Page 11: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/11.jpg)
#CitrixSummit 11
Data Store
IMA access method
1011011010 SSL 1011011010 SSL 1011011010 SSL 1011011101101110 111011011010 SSL 1011011010 SSL 1011011010 SSL 1011011101101110 11ODBC
IMA
10110110101011011010
![Page 12: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/12.jpg)
Citrix Confidential - Do Not Distribute
Pre – XenApp 6.0 Post– XenApp 6.0
Stored Procedures
![Page 13: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/13.jpg)
What is a Schema ?
Citrix Confidential - Do Not Distribute
![Page 14: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/14.jpg)
XenApp 5.0 & 4.5 XenApp 6.0 & 6.5
#CitrixSummit 14
![Page 15: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/15.jpg)
• 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.
Farm Data Sets
#CitrixSummit 15
![Page 16: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/16.jpg)
High Performance
Vs.
High Availability
![Page 17: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/17.jpg)
• Cost ?
• Infrastructure Requirements ?
• Infrastructure Management ?
• Complexity Vs. Simplicity ?
Which do I choose ? Why can’t I have both ?
#CitrixSummit 17
![Page 18: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/18.jpg)
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
![Page 19: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/19.jpg)
• 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
Resources for SQL Replication & Mirroring
Citrix Confidential - Do Not Distribute
![Page 20: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/20.jpg)
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
![Page 21: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/21.jpg)
• Virtualizing SQL Server 2008 with XenServer - Blog
• Virtualizing SQL Server 2008 with XenServer – White Paper
Resources for virtualizing SQL on XenServer
Citrix Confidential - Do Not Distribute
![Page 22: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/22.jpg)
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
![Page 23: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/23.jpg)
#CitrixSummit 23
![Page 24: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/24.jpg)
Tools and Troubleshooting Methodology
![Page 25: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/25.jpg)
• Citrix Diagnostic Facility Trace (CDF)
Tools and Troubleshooting Methodology
#CitrixSummit 25
• SQL Server Profiler Trace
![Page 26: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/26.jpg)
• 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'.
Tools and Troubleshooting Methodology
#CitrixSummit 26
![Page 27: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/27.jpg)
SQL Replication and the
“Identity Crisis”
![Page 28: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/28.jpg)
Unique Identifier
Track Changes
Added by SQL
#CitrixSummit 28
![Page 29: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/29.jpg)
• What is the “Identity Crisis” ?
• Who does it affect ?
• How do I deal with it if it happens to me ?
SQL Replication and the identity crisis
#CitrixSummit 29
![Page 30: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/30.jpg)
• 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
Resources
Citrix Confidential - Do Not Distribute
![Page 31: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/31.jpg)
#CitrixSummit
He who fails to plan
is planning to fail.- Winston Churchill (WW II)
31
![Page 32: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/32.jpg)
• Advanced Concepts - XenApp Farm Maintenance
• Best practices for creating the Citrix Presentation Server data store on SQL 2005
• Best Practices for XenApp Administrators
Best Practice & Learning Resources
#CitrixSummit 32
![Page 33: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/33.jpg)
• SQL Back ups – recovery models
• Working with tempdb in SQL Server 2005
• SQL Server Index Fragmentation and Its Resolution
Learning Resources
#CitrixSummit 33
![Page 34: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/34.jpg)
XenApp 6.5 Improved IMA performance
![Page 35: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/35.jpg)
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
![Page 36: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/36.jpg)
XenApp 6.5 Improved IMA performanceThe table below shows the functionality of the Controller vs. Session-only roles.
#CitrixSummit 36
![Page 37: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/37.jpg)
#CitrixSummit 37
![Page 38: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/38.jpg)
• 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
One last resource
Citrix Confidential - Do Not Distribute
![Page 39: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/39.jpg)
Key session takeaways:
Citrix Confidential - Do Not Distribute
• XenApp Data Store deployments and challenges
• Tools and Troubleshooting Methodology
• XenApp 6.5 Improved IMA performance
![Page 40: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/40.jpg)
#CitrixSummit
Tools as a Servicehttp://Taas.Citrix.com/Beta
Auto analysis health check
2 3
40
Data Collection
Recommendations tailored to YOU
1
Quickly collect and upload your data
![Page 41: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/41.jpg)
#CitrixSummit 41
Tools as a Servicehttp://Taas.Citrix.com/Beta
checkered racing shoes
Find out how to rev up environment maintenanceSee your Citrix pit crew in the expo hall with the
![Page 42: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/42.jpg)
#CitrixSummit
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'
![Page 43: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/43.jpg)
#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
![Page 44: The Data Store and SQL Server Deployment Strategies and Troubleshooting Frank Marzullo Senior Escalation Engineer, Critical Situation response team May](https://reader030.vdocuments.us/reader030/viewer/2022012913/56649d9c5503460f94a84eaa/html5/thumbnails/44.jpg)