Processing times for SQL procs called through VB.net application

[Lokean]

Hi all.

Here is my problem.

We have a SQL procedure that we were calling in a development environment, no problem... ran fairly fast.... no difference between the time it took to run in SQL server management studio and the VB app.

We move it to a staging environment...

The proc takes a few seconds longer to process on SQL Server, (about 12 seconds) but it takes about 3 minutes to process through Visual studio.net.

The only thing I changed was the server name in the connection string.

Does anyone know what could do this?

[shweta123]

Hi,

If your Sql server is Remote then it will take the time to run the procedures.
On local server , it will run the queries fast.

Hi all.

Here is my problem.

We have a SQL procedure that we were calling in a development environment, no problem... ran fairly fast.... no difference between the time it took to run in SQL server management studio and the VB app.

We move it to a staging environment...

The proc takes a few seconds longer to process on SQL Server, (about 12 seconds) but it takes about 3 minutes to process through Visual studio.net.

The only thing I changed was the server name in the connection string.

Does anyone know what could do this?

[radcaesar]

Yes, Like Shwetha said, Since its remote, the call will took time based on your network speed.

[Shashi Sadasivan]

your development server might only be running the DB, and visual studio,
however when it comes to a live server, it may be more than just a DB server, and since it would take simulatneous connections the speed will reduce...!
Increasing the RAM on it sometimes makes it faster (avoiding paging as much as possible)

[Lokean]

To all:

Thank you for your advice.

I have found the problem.

There was a problem with the index in the staging environment that was causing the trouble.

The DBA just got back to me with the details.

I appreciate you all taking the time to answer me, you are most kind.


-Lokean.