RE: sp_trace_getdata SP – SQLServerCentral

SSC Guru

Points: 323504

October 23, 2012 at 2:49 pm

#1552073

sp_trace_getdata is used by SQL Profiler to read it's trace and return the results to the SQL Profiler GUI/application;

SQL Profiler is definitely known to have an impact on SQL server...it potentially can have a very severe performance impact if the trace is catching lots of events.

the way to deactivate it is to not allow anyone to run SQL Profiler;

you can see who's running it by running sp_who2, and find any thing that has ProgramName like SQL Profiler.

For that row(s) , look at the username and the hostname, so you know who is using Profiler, and at what machine, and make them stop using profiler.

if you need to trace something , make a server side trace and use that instead; SQL Profiler can make the trace definition for you.

a server side trace has a much much lighter impact on the server.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!