Database Limitations

The TWA is subject to the data limitations of the underlying database, as follows:

When using TWA and Microsoft SQL Server, the total length of one data transaction must not exceed 8060 bytes.
When using the dbload and pdm_load utilities, a load operation is restricted to 512 columns.
Oracle has a 1000-column limitation. If you customize CA CMDB, verify that the total number of attributes does not exceed 1000 across all families (both CA-supplied and user-defined).
SQL Server 2005 limitations as described in the following table.

Limitation Type	Limit (32-bit and 64-bit)
Columns per wide table	30000
Columns per base table	1024
Columns per SELECT statement	4096
Bytes per row	8060
Rows per table	Limited by available storage