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 |
|
thbaig1
Starting Member
8 Posts |
 Posted - 2011-10-12 : 10:47:52
|
| Hi,RDBMS : MSSQL 2005I have executed trace on some performance criteria(ShoePlanAll,XMLPlan etc). I have saved the results to file and table as well.Now I can read the traces and can see graphical plan one by one on clicking the XML option.I want to know ,Is there some option exist in MSSQL profiler to generate report on trace? or is there some other way to generate report to see as a group of trace results?thank youtanveer |
|
|
Cindyaz
Yak Posting Veteran
73 Posts |
Posted - 2011-10-16 : 16:20:59
|
| You can always query the table where you have saved the trace data and generate reports.To query the file you can use the function fn_trace_gettable. Search BOL for more details. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Sql trace analyzer