Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
imax
Starting Member
1 Post |
 Posted - 2009-05-12 : 03:01:26
|
| Turning off the TCP chimney leads to completion of analysis without any function sequence error or any other database related error.The reason is that the n/w adaptor is not working properly under stress condition.To reassure that Network Interface card is causing the problem,NIC was disabled so that TCP is implemented thru MS TCP loopback interface.Running the analysis using MS TCP loopback interface did not give Function sequence error. Below are some of the details which helps in understanding the problem.This is what I could find after doing the research on this.1.The ODBC driver can use one of the following network library\protocol to connect to the server.1433 port is used by SQL SERVER for TCP/IP. To check the protocol used by a particular DSN,Open the ODBC Data Source Administrator->Select the DSN->Configure->Next->Client Configuration 2.To implement TCP/IP in a machine, we need MAC address which is obtained by NIC. This shows that TCP/IP depends or is implemented thru network controller irrespective of server being local or remote.3.The other way to implement TCP/IP in a local machine without using Network Interface Card is to use “Microsoft LoopBack Adapter”. In the QA machine, where this problem is occurring, there is a NIC and also Microsoft LoopBack Adapter running. If NIC is present, NIC takes priority over LoopBack Adapter.For reference:http://www.howtonetworking.com/Networking/ipconfig.htm#How%20to%20use%20TCP/IP%20without%20installing%20a%20NICHow to turn off /on the TCP Chimney for NVidia Network card1.Right Click My Computer2.Select Manage->Device Manager->Network Adapter->NVidia Nforce Networking Controller->Advanced3.Select Checksum Offload and change the value to Disable(to disable TCP Chimney) Select Segmentation Offload and change the value to Disable(to disable TCP Chimney) 4.Setting the values to “Enable” turns the TCP Chimney ON. |
|
|
dineshrajan_it
Posting Yak Master
217 Posts |
Posted - 2009-05-12 : 03:10:22
|
| Hi Network Admin,Wrong PlaceIam a slow walker but i never walk back |
 |
|
|
|
|
|
Function sequence error