3 ms·

First thing I do with SQL Server setups - turn off named pipes :)

• giancarlostoro 5y ago
  Is there a reason you do this? Curious, I havent had to setup SQL Server myself in a while so I don't know what a reasonable reason would be.
  • tyingq 5y ago
    Named pipes are fast when the database is on the same box, but slower than a normal tcp connection when the database is remote. Something to do with PeekNamedPipe calls having to prepend reads.
    • hobs 5y ago
      Yeah one of my favorite SE posters talks a little more about it, generally the benefits are only there if you have app/db/sql server all on the same box. https://dba.stackexchange.com/a/24176/15642 https://dba.stackexchange.com/a/24176/15642