General discussion

Locked

Named Pipes vs. TCP/IP

By mrkellam ·
Are there any performance differences between using TCP/IP vs. Named Pipes in a client application connecting to a SQL Server?

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Named Pipes vs. TCP/IP

by rickh9 In reply to Named Pipes vs. TCP/IP

Named Pipes is definately slower than TCP/IP due to added encription features etc. However the difference is usually slight and other factors such as database design, indexes etc. tend to have more of an effect. There are some documented bugs (access) that will slam your network, as well as several security issues when using named pipes. A quick search on microsoft technet should return a few articles on the known issues.
As far as real world goes, we do use a few minor apps in which named pipes has been left the default. On our primary Client\Server App we were forced to change to TCP due to periodic network crashes and poor performance in general. Since this was an app. that we have no design control over it was much simpler to drop the pipes. Crashes gone and about a 20% overall improvement in performance.

Collapse -

Named Pipes vs. TCP/IP

by mrkellam In reply to Named Pipes vs. TCP/IP

The question was auto-closed by TechRepublic

Collapse -

Named Pipes vs. TCP/IP

by Not_a_geek In reply to Named Pipes vs. TCP/IP

Funny you should ask that question. We are currently working with Microsoft on a really strange problem that has plagued us since we upgraded our customers to SQL Server 7. All of a sudden, TCP/IP has slowed down and the short term fix has been to switch all of our clients to Named Pipes. By doing so, we get a 70% boost in end-user performance.

Collapse -

Named Pipes vs. TCP/IP

by mrkellam In reply to Named Pipes vs. TCP/IP

The question was auto-closed by TechRepublic

Collapse -

Named Pipes vs. TCP/IP

by mrkellam In reply to Named Pipes vs. TCP/IP

This question was auto closed due to inactivity

Back to Networks Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums