By default, five trace files are kept in the same folder as the SQL Server error log. Each file has a size limit of 20MB before it rolls over to the next file. After the fifth file is filled, the default trace rolls over to the first file, and so on. To confirm if the trace is...
1. Determine what version of SQL Server you have and double-click the link below to download the zip file of SQL templates. In the zip file, click on the TRACETMPL folder and double-click on the .tdf file for your version and SQL Profiler will automati...
In this article we will take a look at how to enable an index in SQL Server. This is a very useful feature which will help you enable an index which was disabled earlier to check whether the index was really useful or not without actually dropping the index. How to verify whether an i...
How to: Filter Events Based on the Event End Time (SQL Server Profiler) How to: Filter Server Process IDs (SPIDs) in a Trace (SQL Server Profiler) How to: Pause a Trace (SQL Server Profiler) How to: Stop a Trace (SQL Server Profiler) How to: Run a Trace After It Has Been Pause...
2. Enable Trace Flag 1222 - Here data is returned in XML Format. Also one can see the processes information also which are involved in deadlock. DBCC Traceon (T1222,-1) 3. Run SQL Profiler Trace to capture the Deadlock events.
Below are the steps to configure Sql*Net verbose Client side tracing: (1) Open the SQLNET.ORA file typically found in the installation location (or simply do a Search):(2) Add the following parameters at the end of the file:#CLIENT-SIDE SQL*NET TRACE PARAMETERS #=== TRACE_UNIQUE_CLIENT...
1: How do you enable trace for an API when executed from a SQL script outside of Oracle Applications ? -- enable trace ALTER SESSION SET EVENTS '10046 trace name context forever, level 12'; -- Set the trace file identifier, to locate the file on the server ...
Use the D: drive (the locally attached SSD) for TempDB files because TempDB is recreated upon server restart, so there's no risk of data loss Enable instant file initialization to reduce the impact of file-growth activities. Move trace file and error lo...
1. How do you enable trace for an API when executed from a SQL script outside of Oracle Applications ? 2. How to get the debug log for APIs when executed from a SQL script outside of Oracle Applications ? a) Inventory APIs b) Bills of Material and Engineering APIs c) Advanced ...
Sql server automatically creates the default trace into multiple files. These can be seen in the LOGS directory of sql server installation path. The sys.fn_trace_getinfo has a trace_id parameter which I'm not sure where I can find. How to view the trace_id of the default trace files?