sp_placeobject  sp_poolconfig

Chapter 1: System Procedures

sp_plan_dbccdb

Description

Recommends suitable sizes for new dbccdb and dbccalt databases, lists suitable devices for dbccdb and dbccalt, and suggests a cache size and a suitable number of worker processes for the target database.

Syntax

sp_plan_dbccdb [dbname]

Parameters

dbname

specifies the name of the target database. If dbname is not specified, sp_plan_dbccdb makes recommendations for all databases in master..sysdatabases.

Examples

Example 1

Returns configuration recommendations for creating a dbccdb database suitable for checking the master database. The dbccdb database already existed at the time this command was run, so the size of the existing database is provided for comparison:

sp_plan_dbccdb master
Recommended size for dbccdb is 4MB.
dbccdb database already exists with size 8MB.
Recommended values for workspace size, cache size and process count are:
dbname           scan ws    text ws    cache    process count
master           64K        64K        640K     1

Example 2

Returns configuration recommendations for creating a dbccdb database suitable for checking all databases in the server. No dbccdb database existed at the time this command was run:

sp_plan_dbccdb
Recommended minimum size for dbccdb is 4MB.
Recommended values for workspace size, cache size and process count are:
dbname           scan ws    text ws    cache    process count
master           64K        64K        640K     1
tempdb           64K        64K        640K     1
model            64K        64K        640K     1
sybsystemprocs  272K        80K        640K     1
dbccdb          128K        64K        640K     1

Example 3

Returns configuration recommendations for creating a dbccdb database suitable for checking pubs2:

sp_plan_dbccdb pubs2
Recommended size for dbccdb is 4MB.
Recommended devices for dbccdb are:
Logical Device Name      Device Size Physical Device Name
sprocdev                 28672      /remote/sybase/devices/srv_sprocs_dat
tun_dat                  8192       /remote/sybase/devices/srv_tun_dat
tun_log                  4096       /remote/sybase/devices/srv_tun_log
Recommended values for workspace size, cache size and process count are:
dbname     scan ws    text ws    cache    process count
pubs2      64K        64K        640K     1

Usage

Permissions

Only the System Administrator or Database Owner can execute sp_plan_dbccdb. Only the System Administrator can execute sp_plan_dbccdb without specifying a database name.

Auditing

Values in event and extrainfo columns from the sysaudits table are:

Event

Audit option

Command or access audited

Information in extrainfo

38

exec_procedure

Execution of a procedure

  • Roles – Current active roles

  • Keywords or options – NULL

  • Previous value – NULL

  • Current value – NULL

  • Other information – All input parameters

  • Proxy information – Original login name, if set proxy in effect

See also

Commands dbcc

System procedures sp_dbcc_evaluatedb





Copyright © 2005. Sybase Inc. All rights reserved. sp_poolconfig

View this book as PDF