3 ms·
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 PeekNamedP
by 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 agoYeah 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