Easysoft ODBC-ODBC Bridge

Why are my connections to MS SQL Server so slow?

Article:
00109
Last Reviewed:
19th July 2005
Revision:
1

Microsoft introduced changes to MS SQL Server 7.0 which can cause connections to an OOB Server and MS SQL Server and subsequent operations to be very slow. These settings elevate the priority of SQL Server to such an extent that other processes on the machine do not get a look in. (e.g. when someone is issuing a query, TaskManager even stops displaying). If you are running MS SQL Server 7 and the OOB Server is running on the same machine as SQL Server you should try the following:

  1. The settings are available from the properties menu of the Enterprise Manager. The settings are "Boost SQL Server Priority on Windows NT" and "Use NT fibres". When these are set NT is so busy servicing SQL Server, the accept() in the OOB Server can take some time due to NT not scheduling any other process.
  2. Move your OOB Serverto another machine where MS SQL Server is not running.
Applies To

Knowledge Base Feedback

* Did this content help you?
* Please select one option based on your first choice:

(* Required Fields)


Oracle is a registered trademark of Oracle Corporation and/or its affiliates.