Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by danny123, Sep 20, 2010.
Is there any way to find out if the profiler is already ON for a specific server?
How many users have ADMIN privileges on that server?
Did you check the active transactions on the server and see what is running?
I am the only admin and but we have several projects which are outsourced. Lately the project went live and we are working on the production issue.
So I want to make sure on my end that there is no other profiler running on the server.
This is more of a general question.
You should find Profiler in Task Manager if it is running.
for such doubts you can obtain the current execution status on SQL server to see if there are PROFILER :
SELECT * FROM sys.dm_exec_sessions where program_name like '%PROF%'
as behind every profiler there is trace so you can use :-
SELECT * FROM :: fn_trace_getinfo(default)
Separate names with a comma.