May 4, 2011 at 1:05 am
Hi All,
Below is one of the interview questions I faced:
TCP/IP, Named Pipes, VIA were disabled. Only Shared Memory was enabled. did you find anything difference ?
Also can you please let me know what is the use of specific protocol.
Thank You.
Regards,
Raghavender Chavva
May 4, 2011 at 5:24 am
Did I find any difference between what and what?
The right protocol is the one that supports your network. If you are on a network that doesn't have TCPIP packets (which would be pretty weird in this day & age) then you can't use TCPIP. It's that simple.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 4, 2011 at 10:41 pm
Raghavender (5/4/2011)
TCP/IP, Named Pipes, VIA were disabled. Only Shared Memory was enabled. did you find anything difference ?
When only Shared Memory is enabled, you can connect only from local machine. You cannot connect from remote machines.
Raghavender (5/4/2011)
Also can you please let me know what is the use of specific protocol.
TCP/IP - Widly accepted. You can connect from Unix machine also.
Shared Memory - already explained above
Names Pipes - Microsoft Windows only.
VIA - Used for special hardware
Refer BOL for more info.
May 4, 2011 at 11:01 pm
To add more on this TCP/IP is a widely used protocol for Internet and is often faster then Named Pipes.Named pipe could work only in LAN (Local N/W) and often performs poorly in slow N/Ws.
Moreover, Kerberos Authentication Protocol could be integrated with TCP/IP only so it is better for security perspective also.
Regards,
Sachin
May 6, 2011 at 10:51 am
Good explaination!!! 😀
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply