Advanced Concepts

Database sizing tool for XenDesktop 7

Database sizing for XenDesktop 7 relies on your ability to interpret and to understand the database sizing KB article CTX139508. The article’s guidelines may not help if you know you have a variation on the listed environments. To help, one of our principal software engineers, Chris Gilbert, created a simple tool that can help generate customized sizing information.

Why a tool?

Many customers asked for an Excel file or a simple formula to work out database sizing, but these methods aren’t optimal because of the complexity involved.

The tool hides the complexity of the calculations and allows for differences between XenDesktop 7.5 and 7.6. The data it consumes and displays is rather raw, but feedback for improvements is welcomed.

Download information

The tool is a zipped MSI file, so it’s easy to install and uninstall. The tool’s only dependency on .Net 4.0. It doesn’t need any part of XenDesktop.

Download the tool from CTX209080.

How to use the tool

When you start the tool, you see a window appear. The window has a section at the top, that allows you to input parameters about the expected environment. The default sets are VDI and HSD of various sizes and look similar to the following screenshot:

Spreadsheet output from database sizing tool

You can either update one of the rows, or start typing numbers into the blank bottom row, and it adds more rows.

When you choose the database type and the XenDesktop version and then click Calculate, the program runs the math and produces sizing guidance as seen in the bottom section of the preceding screenshot.

The produced data includes a row for each of the rows entered in the top section. The columns indicate an approximate size at various points in time. For Site databases, the size tends to reach a max size and stay there, as it doesn’t accumulate data. For monitoring, the database will get bigger over time, depending on configured grooming settings for monitoring. This is also dependent on licensing (for example, only Platinum customers can configure the grooming interval to longer than seven days).

So, for monitoring, the data looks as follows:

Monitoring data from database sizing tool

Table details

For details of which tables are actually consuming the space, click the Sizing by Table tab, inside which there’s a tab for each calculation:

Database sizing tool table details

This more detailed view shows you which tables may become large so you can possibly tune the monitoring grooming to keep certain areas smaller. The breakdown covers the baseline size (such as fixed size). Generally, tables based on users or machines grow every day (historical load balancing info) and grow only on working days (connections and sessions). These are then rolled into a weekly growth column (assumes five working days in a seven-day week) and then into the monthly column.

Exporting the data into Excel

To export any of the tables into Excel, simply click in the table, select and copy all the content, and then paste it into Excel.

This article was modified from a blog post written by Chris Gilbert. You can find the original post, read the comments, and post feedback here: https://www.citrix.com/blogs/2014/11/20/database-sizing-tool-for-xendesktop-7/.

Database sizing tool for XenDesktop 7