• In response to the original question, yes I have had several clients run checkdb nightly on their TB+ databases. 3.5-4hrs was normal.

    There is a tweak that can be made to help it run faster by using resource governor to limit memory which helps checkdb run faster.

    http://www.sqlskills.com/blogs/jonathan/dbcc-checkdb-execution-memory-grants-not-quite-what-you-expect/

    Download a preso by Argenis Fernandez here.

    http://performance.sqlpass.org/Home.aspx?EventID=1047

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events