Seagate ST43401N/ND Informações Técnicas descarregar pdf (Página 99)

Migrating to Sybase Adaptive Server Enterprise 11.5 6-19

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

➤

Note

Parallel processing of inserts is not currently supported.

See the Performance and Tuning Guide for in-depth information about

parallel processing.

dbcc checkstorage Disk Space and Memory

A new

dbcc function, dbcc checkstorage, provides the functionality of

dbcc checktable and checkcatalog, without some of the drawbacks, such

as poor performance and occasional spurious errors, of these earlier

commands. Most system administrators will want to use the

new tool.

dbcc checkstorage requires resources not needed by earlier dbccs. A new

system stored procedure,

sp_plan_dbccdb, is provided to estimate the

required size of dbccdb and memory resources, as well as suggesting

suitable devices. You should run this stored procedure before

creating the database to get the most meaningful results. The

information provided in the following sections is to help you

estimate your resource needs for planning purposes.

◆ WARNING!

The sizes given here are approximate and are for reference only.

Disk Space

The database dbccdb should be placed on its own physical device and

never on the master device.

The size of dbccdb depends on the size of the scan and text workspace

stored within it. Space requirements for the workspaces are

approximately:

• Scan — 1.2% of the target database size

• Text—25% of scan size

The minimum size of dbccdb is 4MB, including a 2K log placed on a

separate device. You can increase database size if you want to store

fault and statistics data from more than ﬁve runs of

dbcc checkstorage

or run the procedure on more than two user databases at the same

time.

1 2 ... 94 95 96 97 98 99 100 101 102 103 104 ... 171 172

Sem comentários

Seagate ST43401N/ND Informações Técnicas Página 99