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.

User Connections for ASE 11.9.2 under Windows NT 4.0 SP4

3 posts in Windows NT Last posting was on 2000-04-21 03:00:55.0Z
Brad McLeod Posted on 2000-04-11 20:00:55.0Z
From: "Brad McLeod" <brad.mcleod@worldnet.att.net>
Subject: User Connections for ASE 11.9.2 under Windows NT 4.0 SP4
Date: Tue, 11 Apr 2000 15:00:55 -0500
Lines: 14
X-Newsreader: Microsoft Outlook Express 4.72.3155.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0
Message-ID: <oQdvgG$o$GA.202@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: ailsa-ded.webzone.net 208.152.102.253
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2334
Article PK: 1089764

I am trying to configure user connections for an ASE 11.9.2 database under
Windows NT 4.0 SP4. According to the documentation, each user connection
typically required between 40-60K of memory. Although there are formulas
for doing this for Unix and OpenVMS, I can't seem to find the same
information for NT. The online documentation says to refer to "Managing and
Monitoring Sybase Adaptive Server Enterprise Using Sybase Central" I can't
find this document either. Any clues?

TIA

Brad McLeod
StoneHenge Partners, Inc.


Eric Trexler Posted on 2000-04-20 22:21:19.0Z
From: "Eric Trexler" <etrexler@earthlink.net.nospam>
References: <oQdvgG$o$GA.202@forums.sybase.com>
Subject: Re: User Connections for ASE 11.9.2 under Windows NT 4.0 SP4
Date: Thu, 20 Apr 2000 18:21:19 -0400
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <3HYK2exq$GA.204@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: etrexler-nt.sybase.com 157.133.40.186
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2277
Article PK: 1089709

Brad,

What are you attempting to do? Are you trying to increase the number of
user connections, or figure out how much ram each connection is using? Try
sp_configure to increase the number of connections. From Sybase Central you
can right click on the server in question and then select configure. Look
up "number of user connections" in the list. Same thing as using
sp_configure.



Eric Trexler

Brad McLeod <brad.mcleod@worldnet.att.net> wrote in message
news:oQdvgG$o$GA.202@forums.sybase.com...
> I am trying to configure user connections for an ASE 11.9.2 database under
> Windows NT 4.0 SP4. According to the documentation, each user connection
> typically required between 40-60K of memory. Although there are formulas
> for doing this for Unix and OpenVMS, I can't seem to find the same
> information for NT. The online documentation says to refer to "Managing
and
> Monitoring Sybase Adaptive Server Enterprise Using Sybase Central" I can't
> find this document either. Any clues?
>
> TIA
>
> Brad McLeod
> StoneHenge Partners, Inc.
>
>


Brad McLeod Posted on 2000-04-21 03:00:55.0Z
From: "Brad McLeod" <brad.mcleod@worldnet.att.net>
References: <oQdvgG$o$GA.202@forums.sybase.com> <3HYK2exq$GA.204@forums.sybase.com>
Subject: Re: User Connections for ASE 11.9.2 under Windows NT 4.0 SP4
Date: Thu, 20 Apr 2000 22:00:55 -0500
Lines: 50
X-Newsreader: Microsoft Outlook Express 4.72.3155.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3155.0
Message-ID: <YGBDC6zq$GA.298@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: ailsa-ded.webzone.net 208.152.102.253
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2276
Article PK: 1089706

Eric -

I am trying to figure out how much RAM each user connection is using and
thereby configure my 'max_user_connections' to an appropriate value!

TIA

Brad McLeod

Eric Trexler wrote in message <3HYK2exq$GA.204@forums.sybase.com>...
>Brad,
>
>What are you attempting to do? Are you trying to increase the number of
>user connections, or figure out how much ram each connection is using?
Try
>sp_configure to increase the number of connections. From Sybase Central
you
>can right click on the server in question and then select configure. Look
>up "number of user connections" in the list. Same thing as using
>sp_configure.
>
>
>
>Eric Trexler
>
>
>
>Brad McLeod <brad.mcleod@worldnet.att.net> wrote in message
>news:oQdvgG$o$GA.202@forums.sybase.com...
>> I am trying to configure user connections for an ASE 11.9.2 database
under
>> Windows NT 4.0 SP4. According to the documentation, each user connection
>> typically required between 40-60K of memory. Although there are formulas
>> for doing this for Unix and OpenVMS, I can't seem to find the same
>> information for NT. The online documentation says to refer to "Managing
>and
>> Monitoring Sybase Adaptive Server Enterprise Using Sybase Central" I
can't
>> find this document either. Any clues?
>>
>> TIA
>>
>> Brad McLeod
>> StoneHenge Partners, Inc.
>>
>>
>
>