October 1, 2008 at 6:24 am
Hi All
I have installed Performance Dashboard on my 2005 production server, its enabled a default trace on my server, since its a server side trace, i am assuming that it doesn't contribute much load to the server ;), has any one faced any problems with performance dash board earlier???
Is there any way that i can change the default trace and include some trace events that i need, so i can create my custom reports 🙂
Cheers
🙂
October 1, 2008 at 7:52 am
You can modify the trace using the sp_trace_* procedures. You would need to get the trace id from sys.traces, stop the trace using sp_trace_setstatus, and then add and enable new events and columns using sp_trace_setevent.
My advice is to create a trace in profiler with just the events you want to add, save the trace defintion, and modify the sp_trace_setevent lines to use your trace id and just run that section of your script.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply