Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Citrix XenApp 6.5 Datastore

Posted on 2011-10-12
Medium Priority
Last Modified: 2012-05-12
We are in the process of having a company upgrade our current Citrix XenApp farm from 4.5 to 6.5.  The old 4.5 farm utilized a SQL 2000 box that has since been virtualized.  We are implementing a physical SQL 2008 R2 Standard box to host a couple of other databases and it was my intention to host the new Citrix datastore on this box as well until I received the following from the consulting company doing the XenApp upgrade...

The Citrix datastore server is not just the database but a Citrix server (including RDS) that also happens to host SQL Server Express for the database.  This server is also the license server for both Citrix and RDS.  It is the primary server of the farm.

Before determining that you want to move that you need to confirm that the other applications you want to run will also play well with Citrix and vice versa.  In general though, Citrix likes to be its own thing because of all it runs.  Trying to run Citrix on a server that is tweaked to be a SQL Server likely won’t work well.  The functions would get in each other’s way.

I am not a Citrix engineer and would be interested in your thoughts as to the validity of the consultant's statement.

It would not be my intention to make the new SQL server a part of the farm but would instead host the database(s) for application(s) that would be on server(s) in the farm.

Your comments and opinions are much appreciated....
Question by:Indy_Admin
  • 4
  • 2
LVL 37

Expert Comment

by:Carl Webster
ID: 36959286
Citrix does not recommend that SQL Server be installed on a XenApp Server.

Citrix does not recommend that XenApp be installed on a SQL Server.


"Do not install XenApp on the SQL Server or Oracle database server."
LVL 11

Assisted Solution

KrAzY earned 400 total points
ID: 36960331
In an Evaluation/Proof of Concept, you can use the default install of XenApp that installs SQL Express, the License Server, and Web Interface on a single server.

But as CalWebster points out, that is not recommended for a production environment.  It also depends on how big your environment is, the specs of your VMs/Servers, and stability/high availability.

For example if that was all on one server and one of the components or the applications your publishing caused server instability or a BSOD, that wouldn't be good.

In large enterprise deployments you typically run the WI's, Datastore, and License Server on separate servers.  You can even go as far as running your ZDC's and XML's on separate servers.

Author Comment

ID: 36964060
Perhaps my ignorance of how Citrix works is getting in my way.

Regarding the Citrix datastore... Is that data being managed on a SQL server?  If it is, then does that need to be the SQL Express listed in KrAzY's post and should that be a seperate server?

My current environment/farm is:

XenApp 6.5 Server 1 (Hyper-V VM) Hosts all Citrix Applications (Office, Acrobat, etc.)
XenApp 6.5 Server 2 (Hyper-V VM) Hosts all Citrix Applications (Office, Acrobat, etc.)
XenApp database (Hyper-V VM) Hosting SQL Express (Datastore), WI's, and maybe the license server???.

I also have a seperate physical SQL 2k8 server.  My thought was to put the datastore on the physical SQL.  It is NOT my intention to install XenApp on the SQL server...

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

LVL 37

Expert Comment

by:Carl Webster
ID: 36964078
The data store can either be on SQL Server Express that runs on the XenApp 6.5 server or it can be on a separate full blown SQL Server.

Create a blank database on the SQL 2008 Server and during the configuration of XenApp 6.5 when you create your new farm, select the option to use a SQL Database.

Author Comment

ID: 36964122
Which scenario would provide better performance assuming the SQL server is enterprise class and can handle the load?
LVL 37

Accepted Solution

Carl Webster earned 1600 total points
ID: 36964200
Always SQL Server.
LVL 37

Expert Comment

by:Carl Webster
ID: 36964218
Should have added that SQL Server Express is limited to one CPU (or vCPU) and the RAM it can use.  SQL Server has no such limits.

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Quickbooks hosting can do wonders to your enterprise but considering the points elaborated in the article which will help you to better analyze the outcomes. So scan your business, its needs and then move to the new world of limitless benefits.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
How to install and configure Citrix XenApp 6.5 - Part 1. In this video tutorial we have explained step by step installation of Citrix XenApp 6.5 Server on Windows Server 2008 R2 is explained in this video. We have explained the difference between…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question