There are two applications, in the bar chart below, that have the biggest impact in the individual Office application start times, lower is better.
Lower is better
Both Outlook and Word are the culprits of the average high application start times. If we compare them in terms of seconds instead of percentages, starting from high to low: Outlook 2019 has an impact of 2 seconds and Word 2019 has an impact of 1 second in comparison to Office 2013 and 2016. But what if the trend line of Office 2019, without Outlook and Word, continues as shown in the bar chart above? Then there is a very good chance that Office 2019 will show faster average application start times compared to Office 2013 and 2016.
![Microsoft excel 2019 16 24 percent formula Microsoft excel 2019 16 24 percent formula](https://cdn.ablebits.com/_img-blog/show-percentage/apply-percentage-existing-values.png)
Based on the results so far, it’s unexplainable why only Outlook and Word show so much impact, this requires further investigation. The CPU results described earlier, are also reflected in the applications start times.
Conclusion
Based on the test results so far, upgrading or migrating to Office 2019 shows a measurable performance decrease. This can have an impact on the overall user capacity of your environment.
The new features and functionalities of Office 2019 require more resources and therefore the software requirements are higher compared to Office 2016 and 2013. The testing results also measured a performance difference between the individual Office applications. Word results with an observable difference in application start times measuring 95% greater resource consumption. In a distant second to Word is Outlook with a frequent occurrence difference of 158%.
The 10% CPU impact can be caused by the startup anomaly in Outlook and Word. However, this is only the case with Outlook and Word. The question is: do other people see this behavior too? This anomaly is hard to explain and may be worth a follow-up investigation.
The results prove it is recommended to validate the impact of Office with each upgrade. Especially with the (new) lifecycle management flow of Microsoft’s Office 365 and its continuously process changes in performance may be different in each update. And to avoid unexcepted performance or user experience issues, continuously validation is required. This is the only way to reduce the possible capacity impact of Office upgrades.
If you have any comments or questions, please leave them below.
Photo by Nastuh Abootalebi on Unsplash
Share this post:
by Omar Bouhaj
Table of Content
- The results
Microsoft Office is by far the most used productivity suite used by enterprises around the world. According to the latest #VDILIKEAPRO State of the Union survey, enterprises are using Office 2016 with an adoption of 30%. Office 2013 is not far behind with 25% and Office 2010 is still used in 15% of the environments.
Microsoft is continuously working on improvements and new features and released Office 2019 last month.
This blog post focuses on the performance and capacity impact of the three most recent Office versions in a VDI environment.
What’s new in Office 2019
Microsoft has always piqued the interests of its users by offering new features and improvements, such as:
- Word; Learning tools (captions and audio descriptions), speech feature (text-to-speech) and improved inking functionality
- Excel; Ability to publish to PowerBI, PowerPivot enhancements and PowerQuery enhancements
- PowerPoint; Zoom capabilities for ordering of slides within presentations, morph transition feature and the ability to insert and manage icons, SVG, and 3D models
- Outlook; Updated contact cards, focused inbox and travel and delivery summary cards
More information can be found here.
Office 2019 requirements
It is important to comply with the requirements specified by the vendor in order to make use of the latest features and functionalities. For Office 2019 the requirements are:
- Computer and processor; 1.6 gigahertz (GHz) or faster, 2-core.
- Professional Plus: 2.0 GHz or greater recommended for Skype for Business.
- Memory; 4 GB RAM; 2 GB RAM (32-bit)
- Hard disk; 4.0 GB of available disk space
- Display; 1280 x 768 screen resolution
- Graphics; Graphics hardware acceleration requires DirectX 9 or later, with WDDM 2.0 or higher for Windows 10 (or WDDM 1.3 or higher for Windows 10 Fall Creators Update).
- Professional Plus: Skype for Business requires DirectX 9 or later, 128 MB graphics memory, and 32 bits per pixel capable format.
- Operating system; Windows 10, Windows Server 2019
- Browser; The current version of Microsoft Edge, Internet Explorer, Chrome, or Firefox.
- .NET version; Some features may require .NET 3.5 or 4.6 and higher to also be installed
Microsoft’s announcement regarding Office 2019 is, it will only work on SAC (Semi-Annual Channel) and Enterprise Long-Term Servicing Channel (LTSC 2019 (or 1809)) for both Windows 10 and Windows Server 2019. Although Windows 7 has extended support that goes until early 2020 and Windows 8.1 until the year 2023, Microsoft will not support the latest version of Office on these operating systems.
While adding new features can improve the work productivity and user experience of the end-user, it might also impact compute resources. The software requirements are therefore important to note and used for sizing calculations.
More information can be found here.
The infrastructure used for the different scenarios are described in the following post and uses GO-EUC’s testing methodology posted here.
Three different scenarios were tested:
- Office 2013
- Office 2016
- Office 2019
Because of limitations on the required Azure AD and Office365 licenses, Office365 is not included in the test scenario.
The tests were configured to use non-persistent desktops with Citrix Virtual Desktops (MCS), including Citrix VDA 7.18, running Microsoft Windows 10 build 1803. Both Windows and Office are fully patched. Windows Defender was disabled, as this may influence the results with unexpected behavior.
Windows 10 was configured with the following specifications for each scenario:
- Microsoft Windows 10 Enterprise x64, 1803, build 17134.320
- 2 vCPU
- 4 GB RAM
Office 2013, 2016 and 2019 were configured with the following specifications for each scenario:
![Microsoft Excel 2019 16 24 Percent Microsoft Excel 2019 16 24 Percent](https://d13ot9o61jdzpp.cloudfront.net/images/date_time_formatting_1.png)
- Microsoft Office Professional Plus 2013 x64, 15.0.4569.1506
- Microsoft Office Professional Plus 2016 x64, 16.0.4266.1001
- Microsoft Office Professional Plus 2019 x64, 16.0.10827.20138
Office features enabled:
- Microsoft Excel
- Microsoft Outlook
- Microsoft PowerPoint
- Microsoft Word
- Microsoft Shared Features
- Microsoft Tools
Windows 10 was optimized with the default Citrix Optimizer 1803 template.
The results
Office 2013, depicted in blue, is the baseline reference (100%) for comparison against Office 2016 and 2019. The VSImax value refers to user capacity, higher is better.
Higher is better