What is a profiler?

[samkud]

Hi Everybody,

Can anyone tell me what is a profiler in SQL server 7.0? What I exactly want to know is, in which practical situation u will find the profiler useful. Explaination with example will be appreciated.

Regards,

Samir.

[MAK]

SQL Profiler is like a Magnifying glass for sql server where you can see what is going on a SQL server box.

Example:
Transaction
1. you can see what SP, insert, update, delete statement has been executed in what database and by which user and how long did it take.

Security
2. What user has been logged in and from what machine and with what application and when he logged off.

[samkud]

Hi MAK,

Thank U very much for the reply. Can u please tell me more about it. Like is it used only for the Tracking purpose? Can I use the profiler data in my VB application.

Please help.

Thanx once again.

Regards,

Samir.

[MAK]

You can track some stored procedure or user or activitiy on a table etc.

you can store the collected value (in a table or file ) and analyse the data for index.

you can access the data (if stored in table) through vb or asp or asp.net or from any frontend etc.