sql 2005

[davep]

new bie....i have a server
for best preformance should i
set protocols to tcpip only or
tcpip, named pipes and tcpip over named pipes

thanks
dave

[Jonathan Roberts]

davep wrote:

new bie....i have a server
for best preformance should i
set protocols to tcpip only or
tcpip, named pipes and tcpip over named pipes

thanks
dave

How do you connect from your application(s)?

[davep]

I have tcpip enabled....not a problem
i was just wondering if is should also
Enable Named pipes

with tcpip over named pipes

Basicly Because i do not know....
What is the best Performance and or Practices

tia
Dave

"Jonathan Roberts" <gr*******@diynics.comwrote in message
news:kL*****************@newsfe22.lga...

davep wrote:

>new bie....i have a server
for best preformance should i
set protocols to tcpip only or
tcpip, named pipes and tcpip over named pipes

thanks
dave

How do you connect from your application(s)?

[Jonathan Roberts]

davep wrote:

I have tcpip enabled....not a problem
i was just wondering if is should also
Enable Named pipes

with tcpip over named pipes

Basicly Because i do not know....
What is the best Performance and or Practices

tia
Dave

I would turn it off if you don't need it.

[Greg D. Moore \(Strider\)]

"davep" <dv*****@sbcglobal.netwrote in message
news:GQ****************@newssvr11.news.prodigy.net ...

>I have tcpip enabled....not a problem
i was just wondering if is should also
Enable Named pipes

with tcpip over named pipes

Basicly Because i do not know....
What is the best Performance and or Practices

Best practice, optimize your queries. Return only the data that is needed.
Avoid stuff like select * from FOO.

Network protocol will be one of the smaller performance tweaks you can make.

>
tia
Dave

"Jonathan Roberts" <gr*******@diynics.comwrote in message
news:kL*****************@newsfe22.lga...

>davep wrote:

>>new bie....i have a server
for best preformance should i
set protocols to tcpip only or
tcpip, named pipes and tcpip over named pipes

thanks
dave

How do you connect from your application(s)?

[davep]

Thanks all
dave

"davep" <dv*****@sbcglobal.netwrote in message
news:gq******************@newssvr14.news.prodigy.n et...

new bie....i have a server
for best preformance should i
set protocols to tcpip only or
tcpip, named pipes and tcpip over named pipes

thanks
dave