SQL Trace

  • Comments posted to this topic are about the item SQL Trace

  • It's like the question: What is the color of apples?

    a) some are red, some are green

    b) some are red, some are yellow

    c) partly red, partly green

    d) brown

    Which answer is 100% correct? None and all of them.

  • Can't but agree with you.

    "[...] If the disk fills while the database is online, the database remains online, but data cannot be inserted. [...]" (see http://msdn.microsoft.com/en-us/library/ms366198.aspx)

    So I guess it's one of those "you're basically right but you haven't got it right" things. 😉

  • With a server side trace you can choose the drive to which the trace goes. One of the benefits of doing that is that it won't fill up the drive where the OS resides. I would not choose the drive that the data files are on.

  • You are perfectly right and I fully agree.

    However, my comment was targeted at the way the question of the day was worded--there is no indication of where the trace would be stored and hence leaving room for actually 'check all that apply' and not just 'one correct' answer. Just as Robert pointed out in the first comment.

  • Sometimes, I think people think too hard with some of the questions.

    😎

  • Even if the disk fills up, data can be interested into a database provided it does not need to grow. Databases typically have free space in them, and if yours don't, I'd argue you aren't managing them well.

    The question is about trace, not about databases, and you're making assumptions that don't need to be made. The questions typically are based on a simple situation, not trying to cover all bases.

  • Apologies for my wholistic approach and for quoting MSDN.

  • You misquoted MSDN. The quote before that says IF the data files need more space and can't get it, a database engine error is issued. The quote misleads people to believe that SQL Server behaves like Word, Excel, Access, etc. in that every insert requires new disk space.

  • I think question is good and answer is also good.

    Out of space not stop your service, but it also not allow to continue your work

    😎

  • Good question. It like MS exams.

  • The only thing that you could say is that it was not 100% clear if the question was related to all server side traces, because with c2 audit mode, the server instance would actually stop. But if it would have been related to c2 auditing, it would have been mentioned most likely.

  • Mighty (9/22/2008)


    The only thing that you could say is that it was not 100% clear if the question was related to all server side traces, because with c2 audit mode, the server instance would actually stop. But if it would have been related to c2 auditing, it would have been mentioned most likely.

    I agree with that. All the nonsense comments about maybe you've also both run out of space in your database files and run out of space on the discs containing them so they can't be expanded are just so much hogwash, but because the C2 audit mode may have been switched on the right answer seems to be "it depends" (unless I'm misinterpreting BoL http://msdn.microsoft.com/en-us/library/ms191443%28v=SQL.100%29.aspx.

    Tom

Viewing 13 posts - 1 through 12 (of 12 total)

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