Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Performance Under W2003 Server

6 posts in Networking Last posting was on 2005-02-21 18:40:58.0Z
David Ray Posted on 2005-02-04 02:16:02.0Z
From: "David Ray" <david@timecalc.com>
Newsgroups: advantage.networking
Subject: Performance Under W2003 Server
Date: Thu, 3 Feb 2005 20:16:02 -0600
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: 206.255.61.130
Message-ID: <4202dbc5@solutions.advantagedatabase.com>
X-Trace: 3 Feb 2005 19:19:49 -0700, 206.255.61.130
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!206.255.61.130
Xref: solutions.advantagedatabase.com Advantage.Networking:501
Article PK: 1131926

Have just installed Medisoft on W2003 Server and the performance is really,
really bad. While we are running some workstations over a WAN, the
performance of LOCAL workstations, too, is really bad.

Just opening up a record for an insert requires 8-10 seconds, an operation
that is < 1 second under NT on our old Pentium 550MHz server. This is a
high-end Dell server that definitely should be much faster.

Wondering if anyone else has seen this kind of problem?

TIA

David


Mark Wilkins Posted on 2005-02-04 15:42:20.0Z
Message-ID: <8914632431030929548507@solutions.advantagedatabase.com>
From: Mark Wilkins <mwilkins@extendsys.com>
Subject: Re: Performance Under W2003 Server
Newsgroups: Advantage.Networking
References: <4202dbc5@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Reader 381.17
NNTP-Posting-Host: 198.102.102.86
Date: 4 Feb 2005 08:42:20 -0700
X-Trace: 4 Feb 2005 08:42:20 -0700, 198.102.102.86
Lines: 28
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!198.102.102.86
Xref: solutions.advantagedatabase.com Advantage.Networking:502
Article PK: 1131927

Hello David,

It's likely you have checked the obvious thing, but is Advantage actually
running on the server? And if so, are the clients getting connections to
ADS, or is it possible that they are scaling back to local server? From
what you are describing, it sounds like ADS is not actually being used.
Using local server over a WAN could lead to the performance you are describing.

Mark Wilkins
Advantage R&D

> Have just installed Medisoft on W2003 Server and the performance is
> really, really bad. While we are running some workstations over a
> WAN, the performance of LOCAL workstations, too, is really bad.
>
> Just opening up a record for an insert requires 8-10 seconds, an
> operation that is < 1 second under NT on our old Pentium 550MHz
> server. This is a high-end Dell server that definitely should be much
> faster.
>
> Wondering if anyone else has seen this kind of problem?
>
> TIA
>
> David
>


David Ray Posted on 2005-02-04 16:17:20.0Z
From: "David Ray" <david@timecalc.com>
Newsgroups: Advantage.Networking
References: <4202dbc5@solutions.advantagedatabase.com> <8914632431030929548507@solutions.advantagedatabase.com>
Subject: Re: Performance Under W2003 Server
Date: Fri, 4 Feb 2005 10:17:20 -0600
Lines: 55
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: 206.255.61.130
Message-ID: <4203a10a@solutions.advantagedatabase.com>
X-Trace: 4 Feb 2005 09:21:30 -0700, 206.255.61.130
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!206.255.61.130
Xref: solutions.advantagedatabase.com Advantage.Networking:503
Article PK: 1131928

Thanks for the reply.

By looking at the configuration utility it appears we ARE getting the
connections.

This is my first experience with ADS, and I'm wondering if there is anything
in particular in the W2003 environment that could be causing this? We have
not made any particular port settings in the configuration, essentially just
install & go.

Any other suggestions you could make would be helpful. We did try taking
the T1 down altogether yesterday and it seemed to not have any impact at
all.

Any further suggestions will be appreciated.

Thx..

David

"Mark Wilkins" <mwilkins@extendsys.com> wrote in message
news:8914632431030929548507@solutions.advantagedatabase.com...
> Hello David,
>
> It's likely you have checked the obvious thing, but is Advantage actually
> running on the server? And if so, are the clients getting connections to
> ADS, or is it possible that they are scaling back to local server? From
> what you are describing, it sounds like ADS is not actually being used.
> Using local server over a WAN could lead to the performance you are
describing.
>
> Mark Wilkins
> Advantage R&D
>
> > Have just installed Medisoft on W2003 Server and the performance is
> > really, really bad. While we are running some workstations over a
> > WAN, the performance of LOCAL workstations, too, is really bad.
> >
> > Just opening up a record for an insert requires 8-10 seconds, an
> > operation that is < 1 second under NT on our old Pentium 550MHz
> > server. This is a high-end Dell server that definitely should be much
> > faster.
> >
> > Wondering if anyone else has seen this kind of problem?
> >
> > TIA
> >
> > David
> >
>
>


David Ray Posted on 2005-02-05 05:52:38.0Z
From: "David Ray" <david@timecalc.com>
Newsgroups: Advantage.Networking
References: <4203a10a@solutions.advantagedatabase.com> <8921632431096437121073@solutions.advantagedatabase.com>
Subject: Re: Performance Under W2003 Server
Date: Fri, 4 Feb 2005 23:52:38 -0600
Lines: 56
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: 206.255.61.130
Message-ID: <42045ffa@solutions.advantagedatabase.com>
X-Trace: 4 Feb 2005 22:56:10 -0700, 206.255.61.130
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!206.255.61.130
Xref: solutions.advantagedatabase.com Advantage.Networking:506
Article PK: 1131931

Thanks for your replies.

Problem turned out to be a defective switch.

Duh.

"Mark Wilkins" <mwilkins@extendsys.com> wrote in message
news:8921632431096437121073@solutions.advantagedatabase.com...
> Hello David,
>
> I am not aware of any specific Windows 2003 settings that would need to be
> changed. In fact our Windows 2003 test server runs Advantage extremely
well.
> I remember doing some concurrency testing at one point and concluded
(unscientifically)
> that Windows 2003 Server handled thread scheduling and networking much
better
> than NT or Windows 2000. I didn't set up that machine, but I do not
recall
> hearing that we had to do any tweaking after the installation.
>
> I'm drawing a bit of a blank at the moment on things to try. Maybe others
> reading this have some clever ideas. It might be useful to run Advantage
> Data Architect and just run some SQL SELECT statements to pull some data
> from the server and see how it behaves. This might help isolate what is
> actually slow.
>
> Mark Wilkins
> Advantage R&D
>
>
> > Thanks for the reply.
> >
> > By looking at the configuration utility it appears we ARE getting the
> > connections.
> >
> > This is my first experience with ADS, and I'm wondering if there is
> > anything in particular in the W2003 environment that could be causing
> > this? We have not made any particular port settings in the
> > configuration, essentially just install & go.
> >
> > Any other suggestions you could make would be helpful. We did try
> > taking the T1 down altogether yesterday and it seemed to not have any
> > impact at all.
> >
> > Any further suggestions will be appreciated.
> >
> > Thx..
> >
> > David
> >
>
>


CheGueVerra Posted on 2005-02-21 18:40:58.0Z
From: "CheGueVerra" <brent_remov_@notgtechna.com>
Newsgroups: Advantage.Networking
References: <4203a10a@solutions.advantagedatabase.com> <8921632431096437121073@solutions.advantagedatabase.com> <42045ffa@solutions.advantagedatabase.com>
Subject: Re: Performance Under W2003 Server
Date: Mon, 21 Feb 2005 13:40:58 -0500
Lines: 12
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 207.35.125.42
Message-ID: <421a2c54@solutions.advantagedatabase.com>
X-Trace: 21 Feb 2005 11:45:40 -0700, 207.35.125.42
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!207.35.125.42
Xref: solutions.advantagedatabase.com Advantage.Networking:528
Article PK: 1131953


> Problem turned out to be a defective switch.
>
> Duh.

Euh, could you enl;ighten us, by telling us which switch etc... we are
looking for ways to improve our performance as well

TIA

CheGueVerra