You are not logged in or registered. Please login or register to use the full functionality of this Website SybaseTeam.Com...
Hello There, Guest! (LoginRegister) Remember Me? Current time: 11-21-2014, 08:55 PM
   Home  |  About Us  |  Sybase Training  |  Synergy  |  Consulting  |  Job Openings  |  Tech Videos  |  Rules and Disclaimer  |  Search
Forum Tools
Sybase Server Limit - URGENT
04-30-2010, 03:09 AM
Post: #1
Sybase Server Limit - URGENT


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 ?


Find all posts by this user
04-30-2010, 08:28 AM
Post: #2
RE: Sybase Server Limit - URGENT


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 :



Regards,
AnVa
TechSupport-SeniorMember
Sybase Forum : Sybase Blog : Sybase Wiki
Synergy Project (SybaseTeam.Com)
Find all posts by this user
05-03-2010, 12:43 AM
Post: #3
RE: Sybase Server Limit - URGENT


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 :


Find all posts by this user
05-03-2010, 01:51 AM
Post: #4
RE: Sybase Server Limit - URGENT


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]


Find all posts by this user


Possibly Related Threads...
Thread: Author Replies: Views: Last Post
  ERROR WHILE CREATING SAP SERVER CONNECTION rajeshv 0 2,982 07-13-2011 08:17 AM
Last Post: rajeshv
  error in init the server in ASE 15 for linux htamayo 1 2,665 08-10-2010 04:40 PM
Last Post: Kishor
  Install and configure Sybase Adaptive Server Enterprise ASE 15 on Fedora Linux Joshi 0 6,556 04-28-2010 06:53 AM
Last Post: Joshi
  How to install a new Sybase ASE Server on Sun Solaris Unix Joshi 2 5,938 02-22-2010 09:39 PM
Last Post: techsupport
  Download Sybase Adaptive Server Enterprise (ASE) 15.0.3 Developer's Edition on Linux Nagendra 0 8,446 09-28-2009 07:11 PM
Last Post: Nagendra
  Download Sybase Adaptive Server Enterprise 15.0.3 Developer's Edition on Windows Nagendra 0 10,938 09-28-2009 07:08 PM
Last Post: Nagendra
  Download Adaptive Server Enterprise 15.0.3 Developer's Edition on Sun Solaris 64-bit Nagendra 0 4,195 09-28-2009 07:06 PM
Last Post: Nagendra
  Sybase Adaptive server enterprise ASE 12.5 and 15.0 Installation Checklist john 0 4,361 04-15-2009 06:28 PM
Last Post: john
  End of Life Support or Notice for Sybase Adaptive Server Enterprise(ASE) 12.5.x sybasegeek 0 7,321 04-12-2009 08:53 AM
Last Post: sybasegeek
  Top 10 Server Configuration Tips for a New ASE 15 Installation john 0 2,162 03-11-2009 08:44 AM
Last Post: john

Options:
Forum Jump:


Contact Us | SybaseTeam | Disclaimer & Rules | Return to Top | Return to Content | Lite (Archive) Mode | RSS Syndication