Post reply

QOD 11-5 Key info missing.

  • November 5, 2003 at 4:43 am

    #160084

    Needs to have under SQL 2000 as SQL 7 doesn't produce the same results the file generated cycles on itself keeping only so much info, 2000 generates the 5 MB files. (Note: I have done my best here not to give away the answer just point out the missing info needed by some for a proper answer.)

  • November 5, 2003 at 8:31 am

    #480917

    I need another bit of key info: What is a blackbox

    Data: Easy to spill, hard to clean up!

  • November 5, 2003 at 10:53 am

    #480958

    stubob,

    Go to BOL, use Index tab, enter SP_TRACE_CREATE. One of the options for that procedure is TRACE_PRODUCE_BLACKBOX.

    -SQLBill

  • November 6, 2003 at 2:01 pm

    #481161

    Except I am missing something are you saying that if you run 100 queries there will be 500M of trace (from the answer)

    Produce 5MB trace files with each query run against the SQL Server.

    Mike

  • November 7, 2003 at 4:42 am

    #481201

    It only stores the trace info (T-SQL Statements, Errors and bits of other info). 100 quiries on either 7 or 2000 would be under 5MB. With 7 thou only the last 100 are stored but with 2000 it stores all until the file blackbox.trc reaches 5 MB then it rolls to a new file blackbox_1.trc and once ite reaches 5mb it goes back to blackbox.trc switching back and forth providing a lot more info. (Note: I seem to recall that before SP3 it just created new file after new file until the drive filled up instead of the swapping, can someone confirm as I don't have an unpatched server, the thing is if the drive fills up the server will stop with this, I could be wrong thou).

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply