March 18, 2013 at 8:49 am
A. Are black box and defaula traces same?
B. Is it possible to capture all the queires in the black/default trace, if it does not degrade sql performance.
March 18, 2013 at 9:49 am
balasach82 (3/18/2013)
A. Are black box and defaula traces same?
Yes, but that trace only captures changes realted to DDL operations, ie CREATE TABLE/ALTER TABLE etc.
B. Is it possible to capture all the queires in the black/default trace, if it does not degrade sql performance.
with the default trace, no.
With your own trace to capture DML statements, then possible, yes; but on a busy server, though you could generate gigs of logs you really don't care about, and those logs could fill up the disk and shut down your server. a trace should be targets to what you really need to capture, and not an everything trace. also note there are a lot of other functionality to consider that might accommodate whatever you are tryingh to do:
a third part log reader, extended events, SQL audit, SQL Change Data capture, adding custom triggers, adding your own custom trace, and probably more functionalities i couldn't think of offhand.
Lowell
March 18, 2013 at 9:18 pm
Which company asked these as interview questions?
--Jeff Moden
Change is inevitable... Change for the better is not.
March 25, 2013 at 8:39 am
These arent interview questions. While reading about blackbox trace, default/blackbox were used interchangebly which led to the confusion.
March 25, 2013 at 7:52 pm
Ah. Understood. In that case, Lowell hit the nail on the head across the board.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy