Easysoft ODBC-ODBC BridgeWhy are my connections to MS SQL Server so slow? |
|
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: