Questions tagged [trace]
The trace tag has no usage guidance.
75
questions
6
votes
1answer
462 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".
...
2
votes
0answers
27 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, ...
0
votes
1answer
41 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 ...
0
votes
0answers
17 views
SQL Profiler not capturing cross-database queries
It seems that SQL Server Profiler traces with a DatabaseName filter only capture queries made FROM a connection to the specified database. For example, if the filter is on "DatabaseA", a query such as ...
0
votes
1answer
153 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 ...
2
votes
1answer
25 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 ...
1
vote
0answers
101 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:\...
0
votes
1answer
1k 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 ...
0
votes
2answers
29 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 ...
0
votes
1answer
640 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 ...
1
vote
0answers
235 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 = ...
0
votes
1answer
27 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 ...
1
vote
2answers
349 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 ...
0
votes
0answers
62 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 ...
1
vote
0answers
167 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].[...
0
votes
1answer
181 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 ...
0
votes
1answer
783 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 ...
1
vote
0answers
82 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 ...
1
vote
1answer
90 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 ...
0
votes
2answers
221 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 ...
8
votes
2answers
13k 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?
3
votes
2answers
230 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 ...
2
votes
1answer
132 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 ...
5
votes
3answers
9k 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 ...
0
votes
1answer
129 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 ...
3
votes
2answers
194 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 ...
0
votes
1answer
330 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 ...
0
votes
1answer
862 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 ...
1
vote
1answer
400 views
Application queries are not getting generated in trace file in oracle [closed]
I am getting queries in trace file which are fired from Oracle SQL Developer IDE but I want to trace queries on Oracle database, which got fired from my java application.
I'm using ALTER SESSION SET ...
0
votes
1answer
32 views
Stopping multiple server side SQL Server traces immediately
A mistake in an audit script generated more than 100 traces. Is there a way I can stop all of them?
0
votes
2answers
106 views
Using LIKE with apostrophes
I have been running a server side trace in order to find out how a specific stored procedure is called within my database.
I am running the following query in order to get data from the trace file ...
0
votes
1answer
784 views
index-*.wt: encountered an illegal file format or internal - WT_PANIC: WiredTiger library panic - aborting after fassert() failure
One hypervisor went down for 7 seconds and afterwords I couldn't start mongod. See error. Replicaset with 3 nodes. I use /var/lib/mongodb-mms-automation/mongodb-linux-x86_64-3.2.8/bin/mongod. I fixed ...
1
vote
3answers
986 views
what are all possible filters to add to a server-side trace?
On this question you can see how to set up a filter on your trace.
this code below filters a trace file to capture only events that happen on database 'AdventureWorks'
-- Set the Filters
declare @...
0
votes
0answers
158 views
how to convert a profile trace into extended events?
I was having a look at this site:
Convert an Existing SQL Trace Script to an Extended Events Session
but still struggling to make the trace file below to work as an extended event.
-- Create a Queue
...
3
votes
1answer
1k views
Howto avoid textdata of trace gets truncated?
I have a trace file including the TEXTDATA column created by a server-side tracing.
Some of the traced queries are very long.
If I re-open the trace file on Profiler, the relevant long query is ...
0
votes
1answer
89 views
Howto transfer tracefile into a trace table without loosing the sort order?
I have traced some data into a trace table into Sql Server using the Profiler GUI. This table has the following structure:
It contains the SQL statements as well as execution plans in the TEXTDATA ...
2
votes
1answer
69 views
How to know which query is resulting in errors in the trace?
So, I got this:
A simple trace with user errors.
But, how can I know the query that has the problem listed here?
I don't think DBCC INPUTBUFFER(X) is appropriated to this.
EDIT 1:
Well, I'm using:...
2
votes
0answers
854 views
How can I have long waits on Tracewrite, when I haven't run Profiler?
I recently setup a SQL Server which is used only ot run a sharepoint Server.
I love to query my wait stats, just to see what we are waiting on.
Most of the wait stats are fine, and I know where they ...
0
votes
1answer
552 views
Append hint with autotrace
I'm doing a direct-path insert which executes successfully. When I try to autotrace the execution, I get the ORA-12838: cannot read/modify an object after modifying it in parallel.
SQL> insert ...
5
votes
2answers
215 views
SQL Server - Stopping a server side trace
I want to setup a server side replay trace and scripted out setting up the trace. However I want the trace to end either after 12 hours or once 10 1GB files have been created. Normally with a max file ...
0
votes
1answer
70 views
Replay trace file and filter on error>0?
I have captured a trace file using the replay template. It includes all columns available, of course including ERROR. When I replay this trace file, the "trace configuration" window pops up, I declare ...
4
votes
2answers
2k views
Find out what columns are in a trace file
while tackling and unexpected CPU spike that was happening every 10 min one of my colleagues prepared a server side trace as follows:
-- Create a Queue
declare @rc int
declare @TraceID int
declare @...
1
vote
2answers
6k views
Oracle Client trace not generating
I'm using Oracle Client 12.1.0.2 and I need to generate client trace because im unable to connect my sql developer to the database server. However, i'm unable to generate the trace.
Here is my sqlnet....
1
vote
0answers
332 views
How to trace an SSIS package using Extended Events?
I'm trying to figure out how to trace only SSIS packages accessing a database. I think one way (albeit probably not perfect) to find these queries using SQL are using sys.dm_exec_sessions and checking ...
1
vote
1answer
266 views
SQL Trace for compatibility check?
My idea is to trace a few days all statements (scripted the replay template) on a SQL Server 2008 r2 and replay those against a deployed version of the db on a newer version (SQL Server 2014).
Is a ...
6
votes
1answer
1k views
How to find the stored procedure which executed an event?
I have a problem where a certain stored procedure disappears occasionally and I need to find out which script deletes it. I found this piece of code which gives the events related to the deletion of ...
3
votes
2answers
2k views
Trace to find “error messages”( SQL Server 2008 R2 )
I'm using this config, trying to find error when a certain host executes a task ( it runs inside a software ):
The user says that the software is running, but it's not updating what it needs to ...
2
votes
1answer
58 views
Any merit to MSSQLSERVER Trace from logman as opposed to XEvent Package 0
The general understanding of monitoring SQL Server activity is that using SQL Profiler is very heavy, server side traces are less heavy, but extended events are even less heavy.
Today I discovered ...
2
votes
1answer
370 views
Why does DBMS_SESSION.session_trace_enable create multiple files?
I have a trace on a session configured like this:
execute immediate 'ALTER SESSION SET TRACEFILE_IDENTIFIER = ''TEST1''';
DBMS_SESSION.session_trace_enable (waits => TRUE,
...
9
votes
1answer
684 views
SQL Server trace based on client TCP port
I have a Windows terminal server with many different users logging in via RDP to run an application. The application makes one or more connections per user to a SQL Server 2008 R2 instance. All users ...
