Hello there!
We have sql server installed using default protocol TCP/IP. Now, we want to change the protocol from TCP/IP to Named pipes. What I want to know is in what circumstances Named Pipes will give better performance as compare to TCP/IP? e.g. when network traffic is not high?? or number of users is less?? or data transaction is not high or etc. etc.
I only know that if SQL-server client and server are installed on same machine, Named pipes is much much faster than TCP/IP. I know there are some more situations when it gives good or bad Results and Performance. I need to know these "WHEN" situations comparing to TCP/IP and "HOW" to achieve it.
Redirecting to any article with answers to my question will also be a help.
thanks
Nanda
We have sql server installed using default protocol TCP/IP. Now, we want to change the protocol from TCP/IP to Named pipes. What I want to know is in what circumstances Named Pipes will give better performance as compare to TCP/IP? e.g. when network traffic is not high?? or number of users is less?? or data transaction is not high or etc. etc.
I only know that if SQL-server client and server are installed on same machine, Named pipes is much much faster than TCP/IP. I know there are some more situations when it gives good or bad Results and Performance. I need to know these "WHEN" situations comparing to TCP/IP and "HOW" to achieve it.
Redirecting to any article with answers to my question will also be a help.
thanks
Nanda