Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
alejo46
Posting Yak Master
157 Posts |
 Posted - 2012-10-22 : 12:22:15
|
| In a production system i've seen a store procedure running all the timeexec [master].dbo.sp_trace_getdata 8even thouh i kill the proccess 1 minute later it shows uo again could anybody tell me what it does and if this SP produces an overhead to the system?Is there any way to know who or which client application is triggerring thas SP (Maybe a SQL Profiler) ?If this SP produce an overhead how can i deactivate this SP ?Thanks in advanced |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-10-22 : 12:24:14
|
| it might be sql profiler . you need to stop trace from running.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
alejo46
Posting Yak Master
157 Posts |
Posted - 2012-10-22 : 12:52:34
|
| OK thanks,but i dont konw much about SQL Profiler, so how can i stop it from running from SQL PROFILER ?secondly this SP prodice overhead to the system ? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-10-22 : 13:27:14
|
| its definitely an overhead but whether its a concern depends on how see performance impact.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
sp_trace_getdata store procedure