Questions tagged [trace]
97 questions
16
votes
2 answers
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
- 417
- 1
- 7
- 16
13
votes
2 answers
Are there any third party tools that can read and/or analyze SQL Profiler trace (.trc) files
I have a .trc file from a trace that a DBA did on one of my databases. I don't have the SQL profiler tool installed on my PC so I can't view the contents and analyze the trace log. How do I read this file without SQL profiler installed on my PC?
Shane Wealti
- 503
- 2
- 7
- 14
11
votes
2 answers
Default trace enabled but not active
When I query the configuration of the default trace, it shows enabled:
exec sp_configure 'default trace enabled';
-->
name minimum maximum config_value run_value
default trace enabled 0 1 1 …
Andomar
- 3,505
- 25
- 32
9
votes
1 answer
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 access the same database using the same SQL…
Bryan Voss
- 93
- 7
9
votes
3 answers
Trace flag and which need to be turned off and Why
In SQL server there are so many trace flags. Why some of them need to be turned off. Some where i saw that trace flag 8017 need to be turned off. So i want to know which trace flag need to be tuned off and Why?
IT researcher
- 3,168
- 15
- 59
- 82
7
votes
3 answers
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 -a -b -o | Find "SQLServer", I have found 4…
Ezeq
- 117
- 1
- 3
- 8
6
votes
1 answer
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".
If I manually call them as they appear in the…
Chris
- 63
- 4
6
votes
1 answer
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 this stored procedure.
DECLARE @path…
AnOldSoul
- 471
- 1
- 11
- 22
5
votes
1 answer
Finding exact statement causing error 3930
Lately I've been seeing errors in the SQL Server Log.
Code:3930 Description:"The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction."
Using SQL Profiler, how can I find the…
SomeGuy
- 2,053
- 8
- 35
- 48
5
votes
2 answers
Is it possible to determine what part of a stored procedure is currently executing?
Say I have a stored procedure like this (assume that the table schemas are fine):
CREATE PROCEDURE p_MyProc
AS
INSERT MyTable SELECT Col1 FROM Table1
INSERT MyTable SELECT Col2 FROM Table2
INSERT MyTable SELECT Col3 FROM Table3
Assuming that…
squillman
- 1,227
- 1
- 13
- 23
5
votes
1 answer
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 displayed completely - it has 340 rows of text and…
Magier
- 4,827
- 8
- 48
- 91
5
votes
2 answers
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 count, the system deletes the oldest file and…
Tim J
- 163
- 1
- 8
4
votes
1 answer
Interpretation of a column in SQL Server profile trace
In a trace table generated by Profiler I tried to determine the origin of a lock using the column ObjectID2 joined to sys.allocation_units.
The results are not good. It identifies many tables that are NOT on the query that generated the…
Fabricio Araujo
- 957
- 7
- 14
4
votes
2 answers
Pulling autogrowth events by file name from default trace
I use below query to get auto-growth event occurred to databases in a sql server.
DECLARE @trcfilename VARCHAR(1000);
SELECT @trcfilename = path FROM sys.traces WHERE is_default = 1
SELECT COUNT(*)as no_of_autogrowths,
sum(duration/(1000*60)) as…
IT researcher
- 3,168
- 15
- 59
- 82
4
votes
2 answers
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 grouped together. My code:
exec sp_trace_setfilter 2,…
Mainecoon21
- 175
- 9