Seagate ST43401N/ND Informazioni Techniche Scaricare il pdf (Pagina 87)

Migrating to Sybase Adaptive Server Enterprise 11.5 6-7

Adaptive Server Enterprise 11.5 If Your Current Version is 4.x or 10.x

Troubleshooting

When

sp_who shows the status LOG SUSPEND, you know that users

are hung and have reached the last chance threshold. SQL Server

writes messages to the error log, listing the tasks that are sleeping

because the log is full.

You can change the last chance threshold behavior for a database to

the old behavior of “abort the transaction with an 1105 error” by

setting “abort xact when log is full” with

sp_dboption.

Tip for Bulk Copy Users

Bulk Copy handles input records in batches, whether or not the

bcp

inserts are logged. When loading a large number of records, use the

bcp ... in ... -b records batch option, and set the number of records to a

reasonable value, for example, 10,000. This reduces the chance that a

bcp command will hold a long transaction and block dump transaction

from clearing enough log space.

If Your Current Version is 4.x or 10.x

If your current version is SQL Server 10.x, begin with this section and

continue to the end of the chapter. If your current version is 4.x,

continue with this section.

This section covers the following issues:

• New Reserved Words in Version 11.0 6-7

• Conﬁguration Interface 6-8

• Databases Online / Ofﬂine 6-10

New Reserved Words in Version 11.0

The following words are reserved as of version 11.0 and can no

longer be used as database object, user, group, or role names:

Table 6-2: New reserved words in 11.0

max_rows_per_page

syb_terminate

partition

unpartition

1 2 ... 82 83 84 85 86 87 88 89 90 91 92 ... 171 172

Nessun commento

Seagate ST43401N/ND Informazioni Techniche Pagina 87