Questions tagged [trace]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
80 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 ...
SQL_NoExpert's user avatar
  • 1,039
0 votes
0 answers
45 views

What is difference between "Statement Cumulative Statistics" and "Statement Self Statistics" in reports generated by OraSrp tool

I have generated trace for single session in oracle database(Version 19c). Then used TKPROF and ORaSrp tool to read raw trace files. What I observed for same sql statement OraSrp tool gives two stats *...
Vimal's user avatar
  • 21
4 votes
2 answers
483 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 ...
Mainecoon21's user avatar
0 votes
1 answer
37 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 ...
variable's user avatar
  • 3,442
2 votes
1 answer
62 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 ...
variable's user avatar
  • 3,442
0 votes
1 answer
318 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(...
variable's user avatar
  • 3,442
0 votes
1 answer
67 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 ...
variable's user avatar
  • 3,442
0 votes
1 answer
265 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 ...
folow's user avatar
  • 327
0 votes
0 answers
338 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'...
user45867's user avatar
  • 1,651
0 votes
1 answer
159 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 ...
variable's user avatar
  • 3,442
0 votes
1 answer
75 views

XE ucs package events

Can anybody explain for what purposes exists ucs package {C0AB75C5-B1EA-445B-B7DF-F897686F94E7} "Extended events for Unified Communications Stack" I have tried to catch some events like ...
solovyevuv's user avatar
0 votes
1 answer
217 views

How can I turn on session trace in SQLPLus?

I've managed to start SQLPlus and have logged in successfully. I can run queries but I can't trace any of them since when I input @settrcon and it gives me the error SP2-0310: unable to open file &...
Andreas's user avatar
3 votes
1 answer
2k views

SQL profiler not showing incoming parameters of store procedure

My Task When user updates some values on the front end UI of an application, I want to know which SQL table/fields are updated, which SQL statements were executed, etc. My method Using SQL profiler, I ...
ppau2004's user avatar
  • 141
1 vote
2 answers
439 views

Server side tracing for SQL Server Analysis Services

We are looking to continuously run server side trace on Analysis Services and record its output in a table in database in the Database Services. There are tons of articles showing server side trace ...
soccer7's user avatar
  • 159
1 vote
1 answer
119 views

RECOVERY MODEL changed on a database, no record in Default Trace [closed]

I have a Log backup job running every hour via SQL Agent. This morning it failed at 3:00 AM with this error: The statement BACKUP LOG is not allowed while the recovery model is SIMPLE. But it ran fine ...
Todd Chittenden's user avatar
0 votes
1 answer
287 views

How to get syntax and logical ORA in a trace file?

there is an application with tons of queries and one of them cause ORA-1722 To check: I turn trace on session like: alter session set events '10046 trace name context forever, level 12' and say to ...
Mikhail Aksenov's user avatar
4 votes
1 answer
753 views

Problem with enabling System Audit (Firebird's Trace and Audit Services)

I would like to enable System Audit on my Firebird 2.5.9.27139 (x64) database (Windows 10), to inspect all queries performed on it. I've already read some docs about what the configuration file should ...
Adam Przedniczek's user avatar
0 votes
1 answer
827 views

How to Get All Server Side Traces in SqlServer from SSMS, stop it from SSMS and delete the log files

How to Get All Server Side Traces in SqlServer from SSMS(Active,Inactive), stop it from SSMS and delete the log files. I need all traces saving into file as well as table. I tried SELECT * FROM ...
abhay sreekumar's user avatar
0 votes
2 answers
786 views

What triggers the SSRS to generate a log file or modify a current one?

When running a trace on my new SSRS Reporting Services 2016, after troubleshooting some problems related to migrating from SSRS 2008, I find the following pattern running continuously: Here is the ...
Marcello Miorelli's user avatar
3 votes
1 answer
852 views

What is the impact of MAX_DISPATCH_LATENCY while configuring EXTENDED EVENT?

By default, MAX_DISPATCH_LATENCY is set to 30 seconds. I chose FILE as a target and write all captures there. I thought that if I write all captures into file, why would then I lower down ...
Rauf Asadov's user avatar
  • 1,253
1 vote
1 answer
167 views

fn_trace_gettable() reports an error

The following code returns some rows with [Error] = 2 SELECT v1.[name] as EventName, tr.TextData, tr.HostName, tr.ApplicationName, tr.LoginName, tr.SPID, tr.Duration, tr.StartTime, tr.EndTime, tr....
Yevgeni Grinberg's user avatar
1 vote
2 answers
953 views

how to find out how long the last DBCC checkdb took to complete?

In most of my servers I have dbcc checkdb scheduled to run. I can get the last known good DBCC Checkdb through DBCC DBINFO(). I can read the tracks left on the sql server log and I get something ...
Marcello Miorelli's user avatar
0 votes
1 answer
163 views

Chronological list of statements from Oracle trace

I'm using a trace in Oracle (11.2) to elucidate the behavior of a client application, and would like to view a list of all of the SQL statements that it submits, in the order in which they were ...
manniongeo's user avatar
6 votes
1 answer
521 views

Mysterious procedure calls without parameters - but no exceptions generated

I've been tracing a handful of stored procedures with EventClass RPC:Completed that are intermittently called from .Net SqlClient Data Provider without required parameters - just "exec SprocName". ...
Chris's user avatar
  • 63
3 votes
0 answers
128 views

Why execution plan could be skipped from XE session?

Got an issue, similar to this one: Why does SQL Server Profiler trace not capture SELECT operator in execution plans?. There was an advice to use XE instead of Trace, but it does not help. Thing is, ...
0wl's user avatar
  • 77
0 votes
1 answer
62 views

Find "Mystery processes" on a MS SQL Sever environment? (SSIS, databases, etc) [closed]

I inherited a collection of Instances/ MS SQL Databases/ SSIS scripts on a server. I am now the interim "accidental DBA." I thought I was familiar with everything there, but apparently not. It's all ...
user45867's user avatar
  • 1,651
3 votes
1 answer
24k views

Find queries executed by an user in sql server

I want to find all the queries executed by an particular user in a database over a period of time. I learnt about trace and XEvents, but these are not setup yet, Will i be still able to get the ...
Venkat's user avatar
  • 131
2 votes
1 answer
119 views

How do I keep a SQL Server Profiler trace from jumping to the bottom entry?

When monitoring a trace in SQL Server Profiler, is there a way to prevent it from jumping to the most recent event without pausing the trace? I'm often trying to scroll up and read descriptions of ...
Scotch's user avatar
  • 148
2 votes
0 answers
507 views

fn_trace_gettable empty default trace rollover files

For some time now I've been using fn_trace_gettable to automatically collect and report certain events on the server. Function is being called with following parameters: ::fn_trace_gettable('C:\...
AdamL's user avatar
  • 405
1 vote
1 answer
5k views

Check all enabled trace events [duplicate]

Recently on a database I enabled trace for event 12842 using the below statement in order to trace Oracle error ORA-12842 : Invalidated cursor. alter system set events '12848 trace name ERRORSTACK ...
Bibhuti Bhusan Padhi's user avatar
0 votes
2 answers
50 views

How can I track if a trace is executing?

I'm sure there's a trace here running and creating logs. I have no idea who did this in the past ( Its here since my first day in this company ). There's no trace of it on sp_whoisactive. Activity ...
Racer SQL's user avatar
  • 7,374
2 votes
1 answer
4k views

How to trace a query on Firebird?

With SQL Server we can trace for a period of time, to get what queries are running. How can I do this with Firebird? I'm reading something on their website but there's only user trace like if the ...
Racer SQL's user avatar
  • 7,374
1 vote
1 answer
1k views

SQL Server Trace Stopped Messages Displaying Random Login Name

When traces are started and stopped we get messages similar to the following in the SQL Server error log: SQL Trace ID 2 was started by login "DOMAIN\loginA". and SQL Trace stopped. Trace ID = ...
Alf47's user avatar
  • 951
0 votes
1 answer
89 views

SQL tracking number of Selects of a databases table row [closed]

Hello I'm trying to create a way in which I could track the number of times a certain column in a database table is selected. Is there something I could implement like a trigger that could increment a ...
ashtona's user avatar
1 vote
2 answers
2k views

how to use is_srvrolemember to list all server roles of a user

For dealing with server permissions I am currently using a procedure called sp_SrvPermissions V6.0 by Kenneth Fisher thank you Kenneth, however, while running a profile trace I often see the ...
Marcello Miorelli's user avatar
0 votes
0 answers
203 views

SQL Server 2012: How do I capture server activity during a specific time frame?

SQL Server Gurus, I have a situation on one of our servers. This server's sql agent job executes an SSIS flow every hour 24/7. The SSIS flow boils down to inserting/updating/deleting multiple tables ...
plditallo's user avatar
  • 157
1 vote
0 answers
292 views

why the queries run by a specific user are slow?

Here you can see how to save the contents of the default trace into a table. I have been saving the contents of the default trance into a table in my DBA database. The table is called [DBA].[dbo].[...
Marcello Miorelli's user avatar
0 votes
1 answer
322 views

ODBC SQL tracer file question marks

I have an MS Access query that connects to an Oracle Express database via an ODBC connection. I've figured out a way to trace the SQL that is sent from MS Access to the ODBC connection. This is what ...
User1974's user avatar
  • 1,447
3 votes
1 answer
2k views

Trace ODBC commands: What is the registry path for TraceSQLMode and where is SQLOUT.TXT?

In the Optimizing Microsoft Office Access documentation, it mentions that we can: ...edit a Microsoft Windows registry setting that allows you to see the commands that the Office Access database ...
User1974's user avatar
  • 1,447
1 vote
0 answers
118 views

Database performance stats

I have this request to collect some statistics on a database over a period of time. Unique entries of the queries being run on a database from a application server ( Can be done with running a Trace ...
Halt_And_Catch_Fire's user avatar
1 vote
1 answer
235 views

server trace naming convention

I wanted to extract some information from the server trace file that is generated after I send a connect statement to the database. I wanted to know the naming convention for the server trace file. I ...
Shekhar Kanodia's user avatar
0 votes
2 answers
519 views

Filter not working on Showplan XML in SQL Server trace

I have setup a SQL Server trace to capture long running queries on my SQL Server 2014 box and added Showplan XML event to capture the execution plan of the queries. The trace was created with duration ...
SQLPRODDBA's user avatar
  • 1,908
16 votes
2 answers
29k views

Duration unit in SQL Server trace file

I have generated a trace file in SQL Server 2012, not really sure about the unit of duration, it is measured by millisecond?
Sam's user avatar
  • 409
3 votes
2 answers
535 views

EventSequence in Trace using profiler

We have a stored procedure sp_foo that contains dynamic sql and at the end of sp_foo the dynamic sql is executed using EXECUTE (@query) While analyzing a trace profile i noticed that the Eventsquence ...
surfmuggle's user avatar
2 votes
1 answer
162 views

Send results of autogrowth from default trace to application event log

I've been asked to generate an entry in the event viewer, as opposed to an e-mail notification, whenever there is an autogrowth event. The problem I'm having is getting data from the default trace ...
repisntbackup's user avatar
6 votes
3 answers
20k views

Finding the application behind ".net sqlclient data provider"

I'm trying to find which application is opening various connections on the SQL Server, all named ".net sqlclient data provider". From system monitor I got the machine name; On the client with netstat ...
Ezeq's user avatar
  • 107
0 votes
1 answer
325 views

SERV_MOD_ACT_TRACE_ENABLE problem

SQL> EXECUTIVE DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE(service_name=>'ACC_SRV',waits=>TRUE,binds=>FALSE,instance_name=>'inst1'); Why this function need instance_name parameter? I think ...
shawn's user avatar
  • 201
3 votes
2 answers
313 views

A methodology for tracing a query that sporadically runs for hours instead of seconds

Once a few weeks or months, but always on the same weekday, one query from a stored procedure used in a daily batch job may visibly become stuck and run for about 200 minutes until the application ...
ajeh's user avatar
  • 911
0 votes
1 answer
465 views

Lots of small SQL statements in SQL Server and measuring network time between DB and Client

I am load testing an application and it appears from New Relic that each transaction executes a significant number SQL statements (approx 250). As we scale up, the service that makes these calls ...
user2064232's user avatar
2 votes
2 answers
2k views

Unable to remove trace from sys.traces

We recently discovered one of our drives was being filled up by audittrace files. One of our DBAs turned off C2 auditing which should normally stop the files filling up the drive. However, it appears ...
Geoff Dawdy's user avatar
  • 1,103