Is profiler only one toool ..

Question

Is profiler only one toool ..

mohan.bndr

SSCrazy

Points: 2360
More actions
August 9, 2013 at 10:57 am

#281688

Can any one please clarify me here that .. Profiler is the only tool that has the ability to audit and identify DDL Events or any other to describe. Please suggest !!!!

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

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

Erland Sommarskog SSC-Insane Points: 24038 More actions · Answer 1

No, Profiler is not the only tool. To start with, Profiler is only a GUI to SQL Trace and any real tracing should be conducted server-side, particularly in production system. There is quite an overhead of running traces from Profiler. Profiler is good for quick things, but any long-term tracing must be performed server side.

Other alternatives are DDL triggers and event notifications. And in SQL 2008 Enterprise Edition, you can also use SQL Server Audit.

[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]

Jeff Moden SSC Guru Points: 1004577 More actions · Answer 2

There's also the default trace which also logs certain DDL events like dropping a table.

--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.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

mohan.bndr SSCrazy Points: 2360 More actions · Answer 3

Erland Sommarskog (8/9/2013)
No, Profiler is not the only tool. To start with, Profiler is only a GUI to SQL Trace and any real tracing should be conducted server-side, particularly in production system. There is quite an overhead of running traces from Profiler. Profiler is good for quick things, but any long-term tracing must be performed server side.
Other alternatives are DDL triggers and event notifications. And in SQL 2008 Enterprise Edition, you can also use SQL Server Audit.

Thanks for letting know and can you please elaborate about SQL Server Audit to understand more...!!!

Erland Sommarskog SSC-Insane Points: 24038 More actions · Answer 4

I you want to learn about SQL Server Audit, I suggest that you read about it in Books Online.

[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]

Is profiler only one toool ..

Cookies on SQLServerCentral