Post reply

How to kill the profiler process?

  • December 12, 2003 at 12:25 am

    #160303

    Could someone point me on how to kill the Profiler Process. I am only using SQL/server for hosting purposes, I don't see a need for it. I have been getting "time out" lately, so I am trying to kill all unecessary processes to free up some resources for SQL/Server database.

    I did look under services but I couldn't see the Profiler process..

    Any input would be helpful.

    Thank you.

    aadba

  • December 12, 2003 at 5:14 am

    #485913

    There is a green arrow button to start profiler and a red square button to kill it.

    Let me know if I am missing something please

    Mike

  • December 12, 2003 at 8:33 am

    #485962

    If you are trying to kill it manually from on the server: task manager will show a profiler.exe, in control panel - admin tools - services you will not see anything to stop/start. Through profiler, see previous persons reply... stop/start inside application.

    If someone else is running it and you want to see who before you kill it look at:

    through Query Analyzer

    sp_who2 or select spid, program_name, loginame, * from master..sysprocesses order by program_name desc

    Then you can manually kill the running process by running: kill spid#

    Be sure to know what you are doing by running this command b/c killing the wrong process could have implications.

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

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