-
Book Overview & Buying
-
Table Of Contents
Citrix XenDesktop Cookbook-Third Edition
By :
The evolution of the XenDesktop platform is not only in terms of Citrix core components, but also for collateral technologies used to implement its architecture. For this reason, we decided to implement all the latest releases of the software required by XenDesktop 7.6. This is also the case for the database component, which will be installed and configured in this recipe on Microsoft SQL Server 2012 edition.
Even if the latest release of the SQL Server product is 2014, we preferred to work on the more supported and documented 2012 version.
XenDesktop 7.6 supports the following versions of Microsoft SQL Server:
SQL Server high availability supported features are: clustered instances, mirroring, and AlwaysOn Availability groups.
How can we choose the right database version? It depends on the required level of performance and availability. For standalone installations (integrated with the XenDesktop Controller server) within a test or POC environment, the Express Edition should be the right choice. In the presence of a huge number of clients and users, with a great number of processed data, if you want to create a clustered database instance, you should implement the non-Express version of SQL Server.
For a separate database installation, we need to perform the common installation operations, as explained in the following section.
Perform the following steps to generate SQL Server Database, which will be used by XenDesktop:


|
Activity |
Server role |
Database role |
|---|---|---|
|
Database creation |
| |
|
Schema creation |
|
|
|
Controller addition |
|
|
|
Controller removal |
| |
|
Schema update |
|
Using a separate instance is not mandatory, but it is better (more isolation, more security).
We configured the most common format for the collation sequences (the same used by Citrix), and also restricted the way to log on to the database at Windows authentication, because XenDesktop does not support SQL or Mixed mode. For the collation, you are free to use not only the indicated version, but also the most important thing is that you will choose a version one that is member of the *_CI_AS_KS category (collation family is case and accent insensitive, but kanatype sensitive).
You must be careful when increasing the size of database logging; despite the normal data component (you should expect to have a database size of 250 MB with some thousands of clients), logs can unexpectedly increase in 24 hours in the presence of thousands of desktops. Based on the following table for MCS architectures, we will be able to calculate the database log and data files occupation:
|
Component |
Data/log |
Occupation |
|---|---|---|
|
Registration information |
Data |
2.9 kB per desktop |
|
Session state |
Data |
5.1 kB per desktop |
|
Active Directory computer account info |
Data |
1.8 kB per desktop |
|
MCS machine info |
Data |
1.94 kB per desktop |
|
Transaction log for idle desktop |
Log |
62 kB per hour |
For a more detailed SQL Server installation, please refer to official Microsoft online documentation at http://msdn.microsoft.com/en-us/library/ms143219.aspx.
In case of necessity to redeploy one or more Desktop Delivery Controller servers configured in your VDI infrastructure, the first action to perform is cleaning the XenDesktop configured database. To perform this task, you have to set all the Citrix components' database connection to null, using the custom PowerShell running the following commands:
Set-ConfigDBConnection -DBConnection $null Set-AcctDBConnection -DBConnection $null Set-HypDBConnection -DBConnection $null Set-BrokerDBConnection -DBConnection $null
Once you finished these operations, you can proceed with the manual deletion and the recreation of the SQL Server database.
Later in this book, we will explain how to use the PowerShell cmdlets available with XenDesktop 7.
Change the font size
Change margin width
Change background colour