Use standard template and check "Save to file" checkbox and specify a location where trace is going to be created. It's a good idea to create a new folder because most of the time multiple files will be created during tracing and ALL of them need to be collected.
2. Switch to the Events Selection tab.
Under TSQL: SQL:StmtCompleted,SQL:StmtStarting
This is how events will look if you uncheck "Show all events"
4. In case you have multiple databases on the SQL server, you can limit profiling to specific databases by enabling Column filter:
After the configuration is done, start the profiling by clicking Run button and repeat the operation causing the problem.
5. After the operation is completed, Stop profiling. Archive the folder where trace files were generated and collect for analysis.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center