The SQL server 2000 process info monitor displays about 100 processes that use a mix of Named Pipes/TCP-IP and (integrated authenticated) users. I was wondering if:
disabling Named pipes - or - TCP-IP (so that all applications are forced to use a single protocol) would affect SQL server performance in anyway
using a single SQL server login instead of multiple windows login would affect SQL server performance in anyway (there is no real need for separate logins)
What I am saying is that if I consolidate all connections into few possible combinations as possible, do I get some performance benefit?