User experiencing slow or poor performance in Toad for SQL Server. General tips on improving speed in Toad for SQL Server.
1. Be sure to be running the newest version of Toad for SQL Server. The latest is available at http://support.quest.com.
2. Check to make sure you meet the minimum system requirements:
PC with 233 MHz minimum, 300 MHz or higher recommended
512 MB RAM minimum, 768MB recommended
82MB of disk space for installation
Windows 2000 SP4/XP/Windows Server 2003
Microsoft .NET Framework version 2.0
Microsoft Data Access Components (MDAC)
Microsoft Internet Explorer 5.01 or later
VGA monitor with a minimum resolution of 800x600, 1024x768 recommended
Client connectivity and configuration for each database (pre-requisite for connecting)
Microsoft SQL-DMO version 8.0 (included if client connectivity is installed)
SQL Server 2000, all editions
SQL Server 2005, all editions
SQL Server Debugging - SQL Server 2005, and SQL Server 2000 with sp3
3. Make sure the prerequisite software is installed. The prerequisite SQL-DMO and .NET Framework are available here: http://toadsoft.com/toadsqlserver/pre_down.htm
Here are some other helpful hints for improving speed. They can be found by going to Tools | Options:
Browser: Select to fetch data in background
Editor: Uncheck Statement Completion.
Editor | Tools: Turn off Navigation.
Database: Disable all caching. Also choose to clear all existing cache. (This will probably take several minutes)
WebBrowser: No not display web page.