dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

Number of connection to Linked Server - sqlserver-odbc

This is a discussion on Number of connection to Linked Server - sqlserver-odbc ; Hi, Following is our different database infrastructure. Server1 on NetwrokDomain1 SQL Server 2000 Server2 on NetwrokDomain2 SQL Server 2000 The database on Server2 is being used by third party clients and database on Server1 is used by us. We want ...


Home > Database Forum > Microsoft SQL Server > sqlserver-odbc > Number of connection to Linked Server

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 10-14-2008, 09:00 AM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Number of connection to Linked Server

Hi,

Following is our different database infrastructure.

Server1 on NetwrokDomain1
SQL Server 2000
Server2 on NetwrokDomain2
SQL Server 2000

The database on Server2 is being used by third party clients and
database on Server1 is used by us.

We want to get information from databases on Server2 on Server1. To
accomplish this, we had created a Linked Server Connection on Server1
to Server2 and created certain views on Server1 which then used within
SPs on Server1. The requests are coming from Web application by many
user to Server1.

Does anyone got any idea on how many number of connection will be
created between Server1 and Server2 per request? Will there be
different connection created for each request or it will utilise the
same connection (connection created while creating the linked server)?

It would be very helpful if anyone can point me to a correct
direction.

Any help is appreciated.

Thanks

-pb-

Reply With Quote
Reply

Thread Tools
Display Modes



All times are GMT -4. The time now is 09:30 AM.