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 |
|
rajemessage
Starting Member
17 Posts |
 Posted - 2013-12-23 : 03:08:37
|
| Dear all,I am trying to use pro filer to create a trace,so that it can be used as workload in "Database Engine Tuning Advisor" for optimization of one stored procedure.latter i am planning to use the tamplet to capture the trace on production server.Please tel me about the Event classes which i should use in trace.The stored proc contains three insert queries which insert data into a table variable,Finally a select query is used on same table variable with one union of the same table variable, to generate a sequence for records based on certain condition of few columns.There are three cases where i am using the above structure of the SP, so there are three SPS out of three , i will chose one based on their performance.There are 200 to 450 cols in tables, which i am planning to normalize.but my question is specific to profiler tamplet in following conditions.I found there is "Tuning" template , but i want to make my own for following conditions.please suggest.1) There is only one table with three inserts which gets into a table variable with a final sequence creation block.2) There are 15 tables with 45 inserts , which gets into a tabel variable with a final sequence creation block.3)There are 3 tables with 9 inserts , which gets into a table variable with a final sequence creation block.In all the above case number of record will be around 5 lacks.Purpose is optimization of queries in SPlike which Event Classes i should use for finding good indexs and statistics for queries in SP.yours sincerely |
|
|
|
|
|
Which Event Classes i should use in profiler