SQL Server Performance Forum – Threads Archive

triggering the profiler

All,
the idea of what i am trying to accomplish is to activate the profiler to record tsql and server performance activity for the last 10 minutes of every hour during business hours. i have looked at it extensively and am looking for a user sproc to start the profiler. details of what i want the profile trace to include is just tsql and basic server performance for starters. i also want to save it to a table. i’ve created a while..if..else loop to run a "sproc" for a specific amount of time. now i need to cretae the sproc to run the profiler and recodr to a table. if anyone has code or documentation for this ( besides BOL ) it would be greatly appreciated. I am drownding in event codes right now…. =) TIA Detroit

Check this link, this might help: http://www.winnetmag.com/Articles/Print.cfm?ArticleID=16078 Jon M

Also thishttp://www.informit.com/articles/article.asp?p=101395 link by Rahul Sharma. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

thanks guys. a very vast topic. these articles help.

]]>