September 2, 2008 at 1:03 am
Hi all.
i am using SQL server2005 ,presently i am working on SQL server profiler for performance monitoring using Trace. i am able to create new trace and able to capture the required events and save in a file now the problem is after saving the Trace results as .trc file how to analyze the results is there any other tool to do that.
how can we justify the performance by looking in to the trace results that i have save ,is there any standard metrics to compare with them .
i have done complete googling where i can only find Tracing and just saving the result but what next step after getting the Trace file data .
Any body please let me know the next step behind this .
Thanks
September 2, 2008 at 2:03 am
Use the fn_trace_getdata function to load the trace data into a SQL table. Then you can query the trace data to get your information.
The only metrics you can compare your trace data it is your own system. You need to establish a benchmark of how your queries typically run on your syste so that you can see when they're running faster/slower than normal.
Please in future put SQL 2005 posts into the SQL 2005 forums. Thanks
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply