SQL - Fast LOCALHOST , Slow IP

15 Jan 2007 10:48 AM

Juano

We have developed an application that use .NET 2.0 and in the same
server are installed the SQL server. The problem is that when i use
"LOCALHOST" on the application everething works fine, but when i chage
it to the IP number the application works VERY SLOOOW.
Why? It must work both way...

Please help me...

15 Jan 2007 10:57 AM

Jens

See where the IP is routed through using TRCAERT x.x.x.x at the command
prompt.

HTH, Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---

15 Jan 2007 11:03 AM

Juano

Jens skrev:

> See where the IP is routed through using TRCAERT x.x.x.x at the command
> prompt.
>
> HTH, Jens K. Suessmeyer.
>
> ---
> http://www.sqlserver2005.de
> ---

The server is WIN 2003, and the command "TRCAERT" don´t seem to work

15 Jan 2007 11:25 AM

Jens

Sorry, its TRACERT (my typo)

15 Jan 2007 12:15 PM

Juano

Jens skrev:

> Sorry, its TRACERT (my typo)

if I do it from mi computer it´s says...
over a maximum of 30 hops:
1 < 10ms < 10ms <10ms servername [192.168.1.155]
trace complete

And if I do it from the server:
over a maximum of 30 hops:
1 < 1ms < 1ms <1ms servername [192.168.1.155]
trace complete

15 Jan 2007 1:49 PM

Robert Klemme

On 15.01.2007 13:15, Juano wrote:

> Jens skrev:
>
>> Sorry, its TRACERT (my typo)
>
> if I do it from mi computer it´s says...
> over a maximum of 30 hops:
> 1 < 10ms < 10ms <10ms servername [192.168.1.155]
> trace complete
>
> And if I do it from the server:
> over a maximum of 30 hops:
> 1 < 1ms < 1ms <1ms servername [192.168.1.155]
> trace complete

Maybe your app is doing a reverse lookup and DNS is somehow configured
badly?

robert

15 Jan 2007 2:01 PM

Juano

What can i do about it?

Plz

16 Jan 2007 2:31 AM

Sue Hoegemeier

What version of SQL Server? What MDAC version?
Using the IP address can be very slow on SQL 2000 with an
older service pack and an older MDAC - 2.6 I think is the
MDAC version with the problems. Try upgrading your MDAC
version and make sure you are current on your SQL Server
service packs.

-Sue

On 15 Jan 2007 06:01:11 -0800, "Juano"
<juan.chul***@gmail.com> wrote:

Show quote

>What can i do about it?
>
>Plz

16 Jan 2007 10:53 AM

Juano

WOW, thanks for the hekp
I will try and update, i notice you if this not work.
Thanks again