Questions tagged [trace]
The trace tag has no summary.
99 questions
1
vote
1
answer
27
views
Question about using trace files with DMA during SQL Server migration assessment
When using Data Migration Assistant (DMA) for a database migration assessment, there’s an option to provide trace files from the source server for further analysis.
I’m wondering — is there a real ...
0
votes
0
answers
28
views
DEA 2.6 Startup Error – MEF GetExportedValue Prerequisite Import Failure
Installing Microsoft Database Experimentation Assistant (DEA) v2.6 on Server 2022 fails to start with:
System.InvalidOperationException: GetExportedValue cannot be called before prerequisite import '...
0
votes
0
answers
19
views
RML Utilities – DTCTransaction EndTime Column Missing in Trace
While learning RML Utilities, I’m trying to generate an .RML file using ReadTrace. The tool fails because the trace must include the DTCTransaction event and its EndTime column, but EndTime is not ...
0
votes
1
answer
123
views
Why don't I see my statements in the SQL Server trace file?
I've written a SQL-Server Profiler script file in order to see why some database actions are unsuccessful. The idea behind the script is:
Show me the starting statements (where an application starts ...
- 609
0
votes
1
answer
174
views
File *.trc is not a recognizable trace file
I am getting the following alert only for one trace file:
File 'xxx.trc' is not a recognizable trace file.
I can select from all other trace files using fn_trace_gettable.
Is it safe to delete this 0 ...
- 447
0
votes
1
answer
172
views
Sql Server - analyze sql script changes on a Database
Need your insights. Thank you for taking time and sharing.
Context
We have a 10 sql scripts which has more than 10000 lines of code and most of them are scripts and some code in each script are ...
0
votes
0
answers
302
views
SQL Default trace not deleting files above the max no of trace files
We have a Sql server 2016 Sp2. Noticed the trace file path D:\Data\MSSQL13.MSSQLSERVER\MSSQL\Log\log_298.trc is getting filled with trace files and the files are more than 2 months old. To my ...
- 1,117
4
votes
2
answers
760
views
Why am I unable to create a filter on a trace in SQL Server?
Because of an outdated SQL Server version I have to use server-side traces to collect some information, but if I try to implement it I get the error Filters with the same event column ID must be ...
- 185
0
votes
1
answer
69
views
How to time the database backup of a production db for trace replay?
I am exploring the SQL trace replay feature.
My IT admin has given me a replica of the production SQL server (without network access) to perform some testing. I intend to perform the patching and ...
- 3,610
2
votes
1
answer
107
views
What is the extended events equivalent of the default sys trace security audit events?
I am exploring the default sys trace and it contains various records for the security changes on the SQL server (event record examples are shown in screenshot below).
Since the trace feature can be ...
- 3,610
0
votes
2
answers
842
views
Why does fn_trace_gettable with the DEFAULT parameter not roll over all trace log files?
These are my SQL default trace files:
To review the trace logs I run the following query:
SELECT min(tf.StartTime) MIN_STARTTIME, max(tf.StartTime) MAX_STARTTIME
FROM ::fn_trace_gettable(CONVERT(...
- 3,610
0
votes
1
answer
161
views
How to view the trace_id of the default trace files?
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 ...
- 3,610
0
votes
1
answer
494
views
Db2 CLI trace produces no output
On Db2 v11.5.7.0 I would like to enable CLI trace and perform some tests.
From official IBM documentation, CLI tracing can be done in two ways:
a) dynamic
b) with db2clini
A. DYNAMIC
According to CLI ...
- 550
0
votes
0
answers
619
views
Alter Trace (SQL Server Profiler) security risks?
SQL Server database -- a read only node specifically (not exactly sure how that works).
Our database keeps crashing due to memory issues - various error messages indicate this. It's hard to tell if it'...
- 1,739
0
votes
1
answer
314
views
What is the use of trace captured via Profiler?
I am learning about capturing trace via profiler.
I understand that the purpose of capturing trace via profiler is to log events happening on the sql server without impacting performance, because ...
- 3,610