Sybase 12.5 Database Statistics (Maximum)

Answer Posted / prabhu

Databases per Adaptive Server Enterprise - 32,767
Server Size - 8 terabytes
Database size - 4 terabytes
Page Size - 2K, 4K, 8K, 16K
Databases spanned by one update 16
Databases opened by one transaction 16
Tables in a query 50
Logins per server 2,147,516,416
Users per database 2,146,484,223
Groups per database 1,032,193
Columns per table 1024
Arguments to stored procedure 2048

Is This Answer Correct ?    6 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the stored procedure to view current lock and processes respectively?

531


List some of the products of sybase.

488


How would you configure identities in sybase?

512


How to check database size in sybase iq?

534


How to connect sybase database from python?

480






Can I use a named pipe to bcp/dump data out or in in sybase?

589


How configure sybase odbc connection?

469


What are the important features of sybase?

480


There is no space in file system and you need to take a back up. What will you do?

451


How does partition assignment relate to transactions in sybase?

469


What is sybase ?

497


How to manually drop a table in sybase?

452


Explain tds (tabular data streams).

504


How do you use workspace in sybase?

509


What you need to do is issue an ase kill command on the connection then un-suspend the db?

531