473,372 Members | 1,011 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,372 software developers and data experts.

Local & remote db server - the differences... please help!

Hi everyone,
Hope you can help me with this one. We are doing a batch process on
both a local server and remote. By local I mean the db server is on
the same box and by remote I mean the db server is on another computer
(but in the same room, so not too far away). The db is: Microsoft SQL
Server 2005 - 9.00.3042.00
We have noticed that the remote server takes a lot longer that the
local. A lot longer. We are trying to think of the different ways that
could account for this. Essentially identify the difference between
local and remote connections in ASP.NET 3.0.
Yes, I know what your thinking - its the network. No, the network is
fine - its massive.

I would greatly appreciate any suggestions/comments/ideas/
possibilities code-diagnostics that you may be able to offer. i'm
really stuck. Cant't figure out why its taking so long...
Could it be a paremeter or somethign in the connection pool or is the
connection pool the same for local and remote. These are the things i
don't know about...

Thanks,
Al.
Jun 27 '08 #1
3 1825
On May 6, 9:27 am, "almu...@altavista.com" <almu...@altavista.com>
wrote:
Hi everyone,

Hope you can help me with this one. We are doing a batch process on
both a local server and remote. By local I mean the db server is on
the same box and by remote I mean the db server is on another computer
(but in the same room, so not too far away). The db is: Microsoft SQL
Server 2005 - 9.00.3042.00

We have noticed that the remote server takes a lot longer that the
local. A lot longer. We are trying to think of the different ways that
could account for this. Essentially identify the difference between
local and remote connections in ASP.NET 3.0.
Yes, I know what your thinking - its the network. No, the network is
fine - its massive.

I would greatly appreciate any suggestions/comments/ideas/
possibilities code-diagnostics that you may be able to offer. i'm
really stuck. Cant't figure out why its taking so long...
Could it be a paremeter or somethign in the connection pool or is the
connection pool the same for local and remote. These are the things i
don't know about...

Thanks,
Al.
I would start off by ruling out the network.
does your batch process involved a lot of data?
what does the batch process do? is it .net app or a sql job?
you can try to run the batch prcess locally on the remote machine. it
it works fine then it means that "remote" thingy has got something to
do with it.

what about the two dbs? are they same? do they have the same data? are
the indices up to date? on both?
Jun 27 '08 #2
al*****@altavista.com wrote:
Hope you can help me with this one. We are doing a batch process on
both a local server and remote. By local I mean the db server is on
the same box and by remote I mean the db server is on another computer
(but in the same room, so not too far away). The db is: Microsoft SQL
Server 2005 - 9.00.3042.00

We have noticed that the remote server takes a lot longer that the
local. A lot longer. We are trying to think of the different ways that
could account for this. Essentially identify the difference between
local and remote connections in ASP.NET 3.0.
Yes, I know what your thinking - its the network. No, the network is
fine - its massive.

I would greatly appreciate any suggestions/comments/ideas/
possibilities code-diagnostics that you may be able to offer. i'm
really stuck. Cant't figure out why its taking so long...
Could it be a paremeter or somethign in the connection pool or is the
connection pool the same for local and remote. These are the things i
don't know about...
Even though the network is fine, then going out on the wire would be
expected to be slower than something that is all happening in memory
(I don't know to what extent Windows TCP/IP optimizes local connections
but I am sure that it is faster).

Arne
Jun 27 '08 #3
If you could explain what are you doing and what is the environment in which
the application/set of code runs, that would enable us on helping you.

<al*****@altavista.comwrote in message
news:fb**********************************@l42g2000 hsc.googlegroups.com...
Hi everyone,
Hope you can help me with this one. We are doing a batch process on
both a local server and remote. By local I mean the db server is on
the same box and by remote I mean the db server is on another computer
(but in the same room, so not too far away). The db is: Microsoft SQL
Server 2005 - 9.00.3042.00
We have noticed that the remote server takes a lot longer that the
local. A lot longer. We are trying to think of the different ways that
could account for this. Essentially identify the difference between
local and remote connections in ASP.NET 3.0.
Yes, I know what your thinking - its the network. No, the network is
fine - its massive.

I would greatly appreciate any suggestions/comments/ideas/
possibilities code-diagnostics that you may be able to offer. i'm
really stuck. Cant't figure out why its taking so long...
Could it be a paremeter or somethign in the connection pool or is the
connection pool the same for local and remote. These are the things i
don't know about...

Thanks,
Al.

Jun 27 '08 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: steve | last post by:
Hi, I finally figured out the best way to synch local and remote script folders, containing many php script files. What I used to do before was try to ftp all the changed files, etc. which was...
9
by: Greg Gursky | last post by:
Hello: I'm doing some planning on a potential project with which I need some help. The database at the focus of this question is a MS Access database that is currently accessed by DAO from a...
3
by: Julia | last post by:
Hi, I have a windows application which create a singleton remote object And a net application which call the remote object both on the same machine(windows 2000,iis 5.0) here is the code...
1
by: Leonid | last post by:
Hello I have VC++ .NET 2003 ATL Server project. In one of its method I need to write some information in a local txt file. This txt file and this ATL Server are on the same ‘C: \’ drive. When...
6
by: Brad | last post by:
I have a win2003 server workstation with multiple webs, each web has it's own ip address. In VS2005, if I select to open an existing web site, select Local IIS, the dialog correctly displays a...
1
by: pmz | last post by:
Dear Group, I'm currently developing a simple Windows application in C#, which is supposed to upload images - through 'WebClient' - into remote (FreeBSD/Apache/PHP) server. What is...
1
by: RashmiKulki | last post by:
hi all, please let me know how access a .aspx file from a remote system,when the client system does not have .NET framework & at the server side the website is running on the ASP.NET web...
1
by: lauralucas | last post by:
Hello I'm using ASP.NET 1.1, Visual Studio 2003, IIS 5.1 and windows XP as development machine. I can work in this machine locally and create web apps that I can access via localhost. No problem...
7
by: RN1 | last post by:
Is it possible to connect to my local SQL Server 2005 database from a remote web server? If yes, what ConnectionString do I use? Thanks, Ron
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.