-
Title
User experiencing slow or poor performance in Toad for SQL Server. General tips on improving spee -
Description
User experiencing slow or poor performance in Toad for SQL Server. General tips on improving speed in Toad for SQL Server.
-
Resolution
RESOLUTION:
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:
Client
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)
Server
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.