Audit,Trace and Profiler.

Question

Dear Sir/Madam,

What is difference among audit, Trace and Profiler ?

kindly explain me briefly, I am totally confused among this three.

Thank You.

Answer 1

Hi,

Profiler is a tool created by Microsoft to audit and trace SQL Server.

By using Profiler you can audit performance (check your performance and what your SQL Server did in your environment), you may audit your login.

I think audit and trace like synonym words.

but always (As in my experience) when trace word use it means what is the effect done to our database by whom. I mean if there is change in our database (change value of col1 from 1 to 2) when want to now how did this.

check those links for more detials:

http://msdn.microsoft.com/en-us/library/ms190176.aspx

http://msdn.microsoft.com/en-us/library/dd392015%28v=sql.100%29.aspx

http://programming4.us/database/2956.aspx

 

 

I hope this is helpful.

 

Elmozamil Elamir

MyBlog

---

Please Mark it as Answered if it answered your question
OR mark it as Helpful if it help you to solve your problem
Elmozamil Elamir Hamid
http://elmozamil.blogspot.com

Answer 2

Hi Mr.Elmozamil Elamir,

 

Your reply helps me a lot.

One more clarification as u said TRACE will follows changes made in DB, then What is the use of DATABASE LEVEL AUDIT.

 

Thank You.

 

 

Answer 3

Hi,

I am not sure but I think in this case it is similar to trace, because you audit at DATABASE LEVEL and that means you trace your user modification on your database.

 

if it help you please mark it as answer, or helpful.

 

I hope this is helpful.

 

Elmozamil Elamir

MyBlog

---

Please Mark it as Answered if it answered your question
OR mark it as Helpful if it help you to solve your problem
Elmozamil Elamir Hamid
http://elmozamil.blogspot.com