Created Date: 10th Nov 2014
Updated Date: 4th Aug 2017
Description
The tool provides guidance on the expected size of the XenDesktop 7.x site and monitoring databases. The tool should be used a guide, rather than an exact sizing, as various factors on the SQL server can impact the size. Specifically the level of fragmentation occurring within the database tables.
- //m.giftsix.com/blogs/2014/11/20/database-sizing-tool-for-xendesktop-7/
- //m.giftsix.com/blogs/2016/03/08/bugfix-for-database-sizing-tool/
Refer to the Knowledge Base Article for information about database sizing and major considerations to be taken into account whensizing databases to support XenDesktop 7.
Prerequisites
None
Installing XenDesktop Database Sizing Tool
The XD7DBSizing.msi file should be run.
How to Use XenDesktop Database Sizing Tool
If you start up the tool you’ll see a window appear with a section at the top which allows the input of parameters about the expected environment.
Below the input columns we can see dropdown to select Site or Montioring Database as well as different versions of Xendesktop.
Note: The enhancements and features mentioned below are available in XenDesktop 7.11 and later versions only.
There is one new input column called Policies. This column is for number of Policies created forProactive Alert and Notifications.
Click “Calculate”.
The produced data includes a row for each of the rows entered in the top section. The columns will indicate an approximate total size of Monitoring database at various points in time.
Select “Sizing by Table” to get size of individual table of Monitoring database to know which table may grow large over time and needs grooming.
Each tab corresponds each row of input given. There is Baseline Size i.e. fixed size, working day growth like connections etc., non-working day growth like historical trends data, weekly growth and monthly growth.
Note: Provide all column input per day basis. For example provide number of average users who would launch sessions per day instead of total users.
Result provided considers all Platinum features are enabled. Result does not include Process utilization.
Use Check Box to include the same in the result (Refer to the image below).
Fragmentation: This calculation does not consider space taken by fragmentation.
Rebuild Index: Rebuilding index once in a while would decrease considerable amount of space taken.
Exporting the data into Excel: To export any of the tables into Excel, click in the table, then press CTRL-A (Select All), then CTRL-C (Copy), you should then be able to paste the data into Excel for graphing or other analysis.
Security Permissions Required by XenDesktop Database Sizing Tool
The tool requires no special permissions to run. However, you will need admin rights to install the tool.
XenDesktop数据库修改的数据大小的工具
None
Uninstalling XenDesktop Database Sizing Tool
The tool appears within the standard windows “Programs and Features” and can be removed/uninstalled from there.
Contact Information
Questions? Concerns? Send any feedback for this tool tosupporttools@citrix.com, or leave comments to the author's blogs following links inDescriptionsection above.
Disclaimer
这些应用软件提供给你is with no representations, warranties or conditions of any kind. You may use and distribute it at your own risk. CITRIX DISCLAIMS ALL WARRANTIES WHATSOEVER, EXPRESS, IMPLIED, WRITTEN, ORAL OR STATUTORY, INCLUDING WITHOUT LIMITATION WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, TITLE AND NONINFRINGEMENT. Without limiting the generality of the foregoing, you acknowledge and agree that (a) the software application may exhibit errors, design flaws or other problems, possibly resulting in loss of data or damage to property; (b) it may not be possible to make the software application fully functional; and (c) Citrix may, without notice or liability to you, cease to make available the current version and/or any future versions of the software application. In no event should the code be used to support of ultra-hazardous activities, including but not limited to life support or blasting activities. NEITHER CITRIX NOR ITS AFFILIATES OR AGENTS WILL BE LIABLE, UNDER BREACH OF CONTRACT OR ANY OTHER THEORY OF LIABILITY, FOR ANY DAMAGES WHATSOEVER ARISING FROM USE OF THE SOFTWARE APPLICATION, INCLUDING WITHOUT LIMITATION DIRECT, SPECIAL, INCIDENTAL, PUNITIVE, CONSEQUENTIAL OR OTHER DAMAGES, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. You agree to indemnify and defend Citrix against any and all claims arising from your use, modification or distribution of the code.