The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
48 views

Insert with different key values to avoid contraint violation

I have a set of Inserts traced of a database and I want to issue them into another similar one. The problem is that I'm getting contraint violation errors due the similar database already has the keys ...
1
vote
1answer
82 views

Sort Warnings, finding out the query behind them

I'm troubleshooting a SQL Server 2012 that has started timing out as of a few weeks ago. The server is filled with thousands of sort warnings, at a rate of about 15 warnings per minute. To get the ...
0
votes
1answer
78 views

How can it take longer to replay a captured trace than to capture it

I am attempting to use trace captures to determine how much of a performance issue was database related and how much was code related. However, the trace is taking longer to replay that it took to ...
2
votes
1answer
207 views

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 ...
0
votes
0answers
154 views

How to get session parameters changed by the user in Oracle?

Oracle 11.2.0.3 . I need to identify all "alter session" changed for a specific session. There is some v$session_* where I able to get this information? My objective is part of investigation what ...
2
votes
2answers
595 views

Importing Multipe Trace Files To A SQL Server Table

I am in the process of importing 200+ trace files (which are massive), and my current approach is to perform a loop and insert the trace data (see the below script). I looked around to see if there ...
4
votes
2answers
343 views

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 ...
0
votes
1answer
42 views

Apply profiler template to saved log

I need to check for deadlocks in my customer's system. He provided me with unfiltered logs. Can I filter them after running the trace somehow? (I don't have direct access to his server) It seems ...
3
votes
2answers
2k views

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. Are there any third ...
3
votes
2answers
429 views

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 ...
0
votes
2answers
391 views

Error using sp_trace_create with parameters [duplicate]

I'm running the following SQL on SQL Server 2000: exec sp_trace_create @options = 2, @tracefile = N'h:\\trace.trc', @filecount = 2 and am getting the following error and can't ...
2
votes
2answers
342 views

SQL Server Trace - Filter on System Processes

Is there a way to filter a (2008 R2) profiler trace on a specific system process? I don’t mean the usual server process (SPID), but the system processes that append “s” onto the end of a SPID (eg ...
4
votes
1answer
377 views

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 ...