SQL Server Performance

Named Pipes vs TCP/IP performance

Discussion in 'General DBA Questions' started by kenp2600, Jun 15, 2007.

  1. kenp2600 New Member

    I have a new SQL 2000 Server I'm about to roll into production. My IIS web server (ASP.NET Application) will be communicating with the SQL server. Is there a performance difference between Named Pipes and TCP? Should I address the server via IP address or Computer Name?

    Thanks
  2. MohammedU New Member

    Check the following...
    http://msdn2.microsoft.com/en-us/library/ms187892(SQL.90).aspx

    You can use either IP or name...there is no perfomance difference...



    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  3. satya Moderator

    Unless you have a naming resolution issue within the network, IP Adress fetches better performance.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  4. kenp2600 New Member

    Thank you for the information!
  5. joechang New Member

    i seem to recall that named pipes requires 2 network round trips
    not one for ip

    whoever did document 187892 did not do a proper test
    if you just do a simple test a query on a local network, it seems like there is no difference, but if you examine the network packets you will notice the difference in traffic
    and then if you do a proper saturation test there is a difference
  6. satya Moderator

    Agree on using NP in SQL 2005 too, now and then we see lot of issues, never had such when using TCP.IP.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page