Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Posts
    1

    Question Unanswered: How to speed dbcc

    I find dbcc 's process is very slow when check a big db, such as 40GB. Do you know how to speed the dbcc process?

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    Hiya rainbow_db,

    There are no shortcuts to running the older dbcc check's. Either you run all of them or you don't.

    Starting from ASE 11.9.2 you can run dbcc checkstorage. Checkstorage is a superset of the traditional dbcc's(except for checkcatalog) and can be run in multi-user mode.

    However checkstorage needs a bit of preperation prior to running against a database. Check your Admin Guide.

    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
  •