-
Title
Toad hangs or takes long time to start with CPU spike (100%) on Windows Server 2008 and 2012 Virtual Machine. -
Description
Toad hangs, freezes, or takes a long time to startup or launch (or very slow to start up) with CPU usage spike increase of 100% on Windows Server 2008 VM and Windows Server 2012 VM.
Trying to start Toad for Oracle on a virtualized Windows Server VM. Remote Desktop Services (formerly known as Terminal Services), the CPU usage spikes to 99-100% and Toad hangs or takes a very long time to startup.
The message "reboot" may pop up and the machine says: "Programs need to be closed"
Virtualized server maybe VMware, Citrix, or MS Virtual PC.
-
Cause
The combination of virtualization, Windows Server 2008 or 2012, and Remote Desktop Services requires additional processing power to launch Toad for Oracle. Running the virtual machine with only 1 CPU causes a performance bottleneck for Toad.
-
Resolution
RESOLUTION 1:
Add a second CPU to the virtual machine settings (total of 2 CPU's). It depends on the scenario, you might need to add a third CPU.RESOLUTION 2:
Specifically for Windows 2012 Terminal server, this issue may occur due to the TSFairShare\Disk setting.
If it is set in the registry to: [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\TSFairShare\Disk]
"EnableFairShare"=dword:00000000 (disabled) it can improve the start time of the application.Disclaimer : Quest does not provide support for problems that arise from improper modification of the registry. The Windows registry contains information critical to your computer and applications. Make sure you back up the registry before modifying it. For more information on the Windows Registry Editor and how to back up and restore it, refer to Microsoft Article ID 256986 "Description of the Microsoft Windows registry": http://support.microsoft.com/default.aspx?kbid=256986