Trace - to Capture all or most queries

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Trace - to Capture all or most queries

Trace - to Capture all or most queries

Rate Topic

Display Mode

Topic Options

Author

Message

balasach82

Posted Monday, March 18, 2013 8:49 AM

Old Hand

Group: General Forum Members
Last Login: Monday, May 13, 2013 8:55 AM
Points: 307, Visits: 743

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.

Post #1432216

Lowell

Posted Monday, March 18, 2013 9:49 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 11:42 AM
Points: 11,633, Visits: 27,705

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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #1432238

Jeff Moden

Posted Monday, March 18, 2013 9:18 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 9:57 PM
Points: 32,906, Visits: 26,790

Which company asked these as interview questions?

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1432457

balasach82

Posted Monday, March 25, 2013 8:39 AM

Old Hand

Group: General Forum Members
Last Login: Monday, May 13, 2013 8:55 AM
Points: 307, Visits: 743

These arent interview questions. While reading about blackbox trace, default/blackbox were used interchangebly which led to the confusion.

Post #1434945

Jeff Moden

Posted Monday, March 25, 2013 7:52 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 9:57 PM
Points: 32,906, Visits: 26,790

Ah. Understood. In that case, Lowell hit the nail on the head across the board.

--Jeff Moden

Post #1435222

« Prev Topic | Next Topic »

Permissions