Sybase Server Limit - URGENT

[niceboykunal123]

There is Application, which is accessing Sybase 15 Server. The application has 20,000 plus users.

So how do we find upper limits that the Sybase Server can handle ?

[sybanva]

try dbcc serverlimits...but first on dbcc traceon 3604 flag...

1> dbcc traceon(3604)
2> go
DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.
1> dbcc serverlimits
2> go
Limits independent of page size:
================================


Server-wide, Database-specific limits and sizes

Max engines per server :
128
Max number of logins per server :
2147516416
Max number of users per database :
2146484223
Max number of groups per database :
1032193
Max number of user-defined roles per server :
1024
Max number of user-defined roles per (user) session :
127
Min database page size :
2048
Max database page size :

[niceboykunal123]

This information is of which ASE version ?
ASE 12.5 or ASE15

And does it vary as per different versions......

(04-30-2010 08:28 AM)sybanva Wrote:  try dbcc serverlimits...but first on dbcc traceon 3604 flag...

1> dbcc traceon(3604)
2> go
DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.
1> dbcc serverlimits
2> go
Limits independent of page size:
================================


Server-wide, Database-specific limits and sizes

Max engines per server :
128
Max number of logins per server :
2147516416
Max number of users per database :
2146484223
Max number of groups per database :
1032193
Max number of user-defined roles per server :
1024
Max number of user-defined roles per (user) session :
127
Min database page size :
2048
Max database page size :

[niceboykunal123]

Also can someone please explain the [COLOR=#NaNNaNNaN][FONT=Verdana,sans-serif]server_name.cfg file in detail,[/FONT][/COLOR]
[COLOR=#NaNNaNNaN][FONT=Verdana,sans-serif][/FONT][/COLOR]
[COLOR=#NaNNaNNaN][FONT=Verdana,sans-serif];
[DEFAULT]
; This is the default section loaded by applications that use
; the external configuration (CS_EXTERNAL_CONFIG) feature, but
; which do not specify their own application name (CS_APPNAME).
; Initially this section is empty - defaults from all properties
; will be the same as earlier releases of Open Client libraries.[/FONT][/COLOR]
[COLOR=#NaNNaNNaN][FONT=Verdana,sans-serif][ANSI_ESQL]
; This section defines configuration which an ANSI conforming
; ESQL application should use to get ANSI - defined behavior
; from SQL Servers and Open Client libraries. This set of
; configuration properties matches the set which earlier
; releases of ESQL (version 10.0.X) automatically set for
; applications during execution of a CONNECT statement.
CS_CAP_RESPONSE = CS_RES_NOSTRIPBLANKS
CS_EXTRA_INF = CS_TRUE
CS_ANSI_BINDS = CS_TRUE
CS_OPT_ANSINULL = CS_TRUE
CS_OPT_ANSIPERM = CS_TRUE
CS_OPT_STR_RTRUNC = CS_TRUE
CS_OPT_ARITHABORT = CS_FALSE
CS_OPT_TRUNCIGNORE = CS_TRUE
CS_OPT_ARITHIGNORE = CS_FALSE
CS_OPT_ISOLATION = CS_OPT_LEVEL3
CS_OPT_CHAINXACTS = CS_TRUE
CS_OPT_CURCLOSEONXACT = CS_TRUE
CS_OPT_QUOTED_IDENT = CS_TRUE
; End of default sections[/FONT][/COLOR]
[COLOR=#NaNNaNNaN][FONT=Verdana,sans-serif]
; This is a sample section showing how you might alter configuration
; properties for you Embedded SQL application.
[SAMPLE_ESQL]
; use most of the ANSI properties defined above
include = ANSI_ESQL
; but override some default properties
CS_OPT_CHAINXACTS = CS_FALSE ; run in autocommit mode
[/FONT][/COLOR]