Most efficient proptocol to access a SQL2k on the same server?

  • Thread starter Thread starter mortb
  • Start date Start date
M

mortb

Hi

Our clients website is hosted by the same machine that runs their DBMS.
We have no network protcol (tcp | named pipes | etc..) defined in the
connection string.
Which method will be used accessing the database? Would it be more efficient
to specify the protocol and then which protocol should we use?

TIA!
mortb
 
Mortb,

If I understand you well, than has it all not much to do with each other.

Can you explain a little bit more what you want.

Cor
 
I'm asking what connection method the connection will default to (tcp |
named pipes | shared memory ... etc)
and what method I should use in the senario where the webserver and sql
server is on the same computer.

Any clearer ;)

/mortb
 
Hi Mortb,

If the app and the SQL server are on the same machine, and you're accessing
the machine with "." or "(local)", shared memory will be used. Of course,
shared memory is the most efficient way to access the database.

You can also specify the network protocol in the connection string. Please
check the following link for how to specify the network library.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/
frlrfSystemDataSqlClientSqlConnectionClassConnectionStringTopic.asp

Hope that helps.

Kevin Yu
Microsoft Online Community Support

============================================================================
==========================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
============================================================================
==========================

(This posting is provided "AS IS", with no warranties, and confers no
rights.)
 
Back
Top