Results 1 to 2 of 2

Thread: DBBC time

  1. #1
    Join Date
    Jun 2003
    Posts
    140

    Unanswered: DBCC time

    Hi All

    Is there any way to predict or pre calculate how much time
    DBCC checkdb and checkalloc options will take considering a
    a particular dbsize ?
    for ex. 100 tables on 20 GB db
    i want to know in advacance , the approx time DBBC checkdb and
    DBCC checkalloc (with fix and nofix option both) can take


    thx in advance
    perl
    Last edited by perl; 01-05-04 at 12:18.

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    G'day,

    Checkdb = Sum(checktable on all tables)

    Time it takes for checktable is roughly calculated =

    [time to do one I/O] * [number of rows in table] * [number of indexes on table]

    i/o is obntained from sp_sysmon.

    Tablealloc is quite difficult to estimate because of the nature of the allocation, locking scheme etc...

    You should check with Sybase Technical Support on that one and share it here if you indeed have an answer.

    Cheers,

    Willy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •