MSDE access over network slow for XP workstations, not Win2K

I've installed MSDE SP3a on a Windows 2000 Server, and the VB6 client
application on multiple workstations.
These workstations are either Win2000 Pro or WinXP Pro (both SP1 and SP2).
All workstations can access and ping the server under 1MS.
When the client application opens and reads data from the database server,
it takes a short time for this to be performed on the Win2000 Pro machines,
but all the XP machines take an abnormally long time to connect and to
retrieve the data.
The XP's do connect, but the retrieval is very slow, sometimes it timesout
during a retrieval.
This occurs even when nobody is connected to the database, so I've ruled out
the governer.
I'm using ADO to connect and all PC's have MDAC 2.7 or greater.
The install process only installed MDAC 2.7 if the current version is before
that.
Anybody have an idea what might be the problem?
All responses are welcome.
TIA
Jim K
Hi Jim,
Name resolution problems perhaps? Try connecting to the IP address instead
of the server name to find out.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Jim K" <krusej@.megsinet.net> wrote in message
news:enMo6BQ7EHA.1596@.tk2msftngp13.phx.gbl...
> I've installed MSDE SP3a on a Windows 2000 Server, and the VB6 client
> application on multiple workstations.
> These workstations are either Win2000 Pro or WinXP Pro (both SP1 and SP2).
> All workstations can access and ping the server under 1MS.
> When the client application opens and reads data from the database server,
> it takes a short time for this to be performed on the Win2000 Pro
> machines,
> but all the XP machines take an abnormally long time to connect and to
> retrieve the data.
> The XP's do connect, but the retrieval is very slow, sometimes it timesout
> during a retrieval.
> This occurs even when nobody is connected to the database, so I've ruled
> out
> the governer.
> I'm using ADO to connect and all PC's have MDAC 2.7 or greater.
> The install process only installed MDAC 2.7 if the current version is
> before
> that.
> Anybody have an idea what might be the problem?
> All responses are welcome.
> TIA
> Jim K
>
|||Thanks, I didn't think of that.
I have connected using the IP in other apps, but that was to the default
instance.
Since I have a named instance in this case, how would I format the IP and
instance?
Ex: default instance installed on server SERVER1, I can substitute the IP
for SERVER1
for named instance SERVER1/DB1, how would I format the IP? IP#/DB1 ?
Thanks!
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:u0zukkl7EHA.3124@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> Hi Jim,
> Name resolution problems perhaps? Try connecting to the IP address instead
> of the server name to find out.
> HTH,
> --
> Greg Low [MVP]
> MSDE Manager SQL Tools
> www.whitebearconsulting.com
> "Jim K" <krusej@.megsinet.net> wrote in message
> news:enMo6BQ7EHA.1596@.tk2msftngp13.phx.gbl...
SP2).[vbcol=seagreen]
server,[vbcol=seagreen]
timesout
>
|||Hi Jim,
I'd suggest setting a fixed port for the named instance, then just connect
to that port. Even set up an alias on the client boxes that knows about the
port. It would completely avoid the sql browser function that essentially
just maps your instance name to a port anyway. To do that:
1. Open svrnetcn.exe and for the named instance, uncheck the "dynamic port"
box and select your own port (ie 38474 or something).
2. Restart the instance.
3. On the client, run cliconfg.exe and set up an alias pointing to that port
on the server.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Jim K" <krusej@.megsinet.net> wrote in message
news:u6vH8Mo7EHA.2196@.TK2MSFTNGP11.phx.gbl...
> Thanks, I didn't think of that.
> I have connected using the IP in other apps, but that was to the default
> instance.
> Since I have a named instance in this case, how would I format the IP and
> instance?
> Ex: default instance installed on server SERVER1, I can substitute the
> IP
> for SERVER1
> for named instance SERVER1/DB1, how would I format the IP? IP#/DB1 ?
> Thanks!
> "Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
> news:u0zukkl7EHA.3124@.TK2MSFTNGP11.phx.gbl...
> SP2).
> server,
> timesout
>
sql

msde - uses too much memory and is getting very slow!

Juergen,
What else is this computer used for?
If only MSDE, then the system page file can be reduced to a minimum (or even
eliminated) -thereby reducing the memory 'pressure' on SQL Server (MSDE).
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Jrgen Strutzenberger" <stju@.gtech.at> wrote in message
news:eOxWF3zAHHA.996@.TK2MSFTNGP02.phx.gbl...
> hi newsgroup!
> we have already some msde databases installed and we didn't had any
> troubles until now!
> the OS is a Windows XP prof. SP2 with MSDE Version; msde desktop engine
> 8.00.7630SP3
> now our trouble is that the sqlserver.exe process is using more and more
> ram and the pagefile grows and grows!
> The PC (server) HP DL385 has 2 GB RAM so this shuldn't be the problem! So
> when the sqlserver.exe process is running about 2-3 days the amout of
> memory usages grows to 1,3GB and about this size the PC is realy getting
> slow, so you can't work anymore!
> The problem is solved when i start and stop the sqlserver, but this isn't
> how i will solve the problem!
> So does anyone have the some troubles, and does anybody now how to solve
> this problem?
> kind regards
> Juergen Strutzenberger
>
What has changed in the past short period of time? New VB.NET program?
Does the VB.NET program properly dispose of all connection objects created?
You may want to run performance monitor to discover what is using the cpu
cycles and the memory.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Jrgen Strutzenberger" <stju@.gtech.at> wrote in message
news:eaVNo1BBHHA.3396@.TK2MSFTNGP02.phx.gbl...
> we also run a selfe made programm, witch is programmed with VB.net!
> we already uninstalled some programs we didn't need!
> we also removed the Norton AV because we thought that this is using to
> much ressources and the pc is getting slow!
> bye
> juergen
> "Arnie Rowland" <arnie@.1568.com> schrieb im Newsbeitrag
> news:eSaidM1AHHA.4808@.TK2MSFTNGP03.phx.gbl...
>
|||What has changed in the past short period of time? New VB.NET program?
Does the VB.NET program properly dispose of all connection objects created?
You may want to run performance monitor to discover what is using the cpu
cycles and the memory.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Jrgen Strutzenberger" <stju@.gtech.at> wrote in message
news:eaVNo1BBHHA.3396@.TK2MSFTNGP02.phx.gbl...
> we also run a selfe made programm, witch is programmed with VB.net!
> we already uninstalled some programs we didn't need!
> we also removed the Norton AV because we thought that this is using to
> much ressources and the pc is getting slow!
> bye
> juergen
> "Arnie Rowland" <arnie@.1568.com> schrieb im Newsbeitrag
> news:eSaidM1AHHA.4808@.TK2MSFTNGP03.phx.gbl...
>
|||What has changed in the past short period of time? New VB.NET program?
Does the VB.NET program properly dispose of all connection objects created?
You may want to run performance monitor to discover what is using the cpu
cycles and the memory.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Jrgen Strutzenberger" <stju@.gtech.at> wrote in message
news:eaVNo1BBHHA.3396@.TK2MSFTNGP02.phx.gbl...
> we also run a selfe made programm, witch is programmed with VB.net!
> we already uninstalled some programs we didn't need!
> we also removed the Norton AV because we thought that this is using to
> much ressources and the pc is getting slow!
> bye
> juergen
> "Arnie Rowland" <arnie@.1568.com> schrieb im Newsbeitrag
> news:eSaidM1AHHA.4808@.TK2MSFTNGP03.phx.gbl...
>