SQL PROFILER

Question

SQL PROFILER

hasib1971

SSC Rookie

Points: 45
More actions
December 17, 2007 at 3:22 pm

#177637

I have mulitiple “instance names” and “database names” … how can I trace the following
“App Security Groups ”,
“User & Non-User IDs on App” ,
“ DB Security Groups” ,
and “ User & Non-User IDs on DB”
using SQL PROFILER
What events , data columns and filter should be set to find out above
Is there any way to automate the profiler trace for the multiple instances

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

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

thecosmictrickster@gmail.com SSChampion Points: 10386 More actions · Answer 1

What exactly are you wanting to trace? Login/logout/login failure by members of the groups? Object access by members of these groups? Profiler will track individual logins but not groups.

What do you mean by 'automate'? Are you wanting to have it scheduled to run at specified dates/times? Start if the server gets restarted? Or do you want to set it up once for one instance and be able to apply the same settings to the other servers?

Do you want to run this trace all the time or is it just a one-off thing for a few hours/days?

It seems like the best plan would be to setup a trace in profiler, export it out and run it as a server-side trace on each instance (tweak accordingly). Just bear in mind that the more you select, the bigger the trace file will be, the more disk I/O will be generated.

Scott Duncan

MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare

hasib1971 SSC Rookie Points: 45 More actions · Answer 2

Hi Scott

Thanks a lot to keep me in track, i was kind of lost in Profiler.

Actually i was trying to identify the groups in which the members belong to .. is there any other way to track the group since its not possible using the profiler for this.

And also how can i set up profiler once for one instance and be able to apply the same settings to the other servers?

Thanks in advance

Roy Ernest SSC-Dedicated Points: 38780 More actions · Answer 3

Hi Hasib,

you could always set up a server side trace as a job and copy the Job to different Servers with slight modification. Then have some reporting feature to get what you want.

-Roy