Stack Overflow
Stack Overflow

Questions tagged [sql-server-profiler]

SQL Server Profiler is a rich interface to create and manage traces and analyze and replay trace results. The events are saved in a trace file that can later be analyzed or used to replay a specific series of steps when trying to diagnose a problem.

SQL Server Profiler is a tracing tool provided by Microsoft since SQL Server 2000 version. It is used to trace activities and operations executed on a specific SQL Server database engine or Analysis Service to be analyzed later.

References and helpful links

366 questions
425
votes
6 answers

SQL Server Profiler - How to filter trace to only display events from one database?

How do I limit a SQL Server Profiler trace to a specific database? I can't see how to filter the trace to not see events for all databases on the instance I connect to.
G - M
186
votes
3 answers

What does "exec sp_reset_connection" mean in Sql Server Profiler?

Trying to understand what Sql Profiler means by emitting "sp_reset_connection". I have the following, "exec sp_reset_connection" line followed by BatchStarting and Completed, RPC:Completed exec sp_reset_connection SQL:BatchStarting SELECT…
Ray
  • 12,101
  • 27
  • 95
  • 137
109
votes
4 answers

What is "Audit Logout" in SQL Server Profiler?

I'm running a data import (using C#/Linq), and naturally I'm trying to optimize my queries as much as possible. To this end I'm running a trace on the DB using SQL Server Profiler, with my trace filtered by my SQL login name (it's a name that can…
Shaul Behr
  • 36,951
  • 69
  • 249
  • 387
85
votes
4 answers

SQL Profiler CPU / duration units

The output from a SQL Server trace in profiler contains the columns CPU and Duration (amongst others). What units are these values in?
PaulB
  • 23,264
  • 14
  • 56
  • 75
66
votes
2 answers

How to get SQL Profiler to monitor trigger execution

I have a trace setup for SQL Server Profiler to monitor SQL that is executed on a database. I recently discovered that trigger execution is not included in the trace. After looking through available events for a trace, I do not see any that look…
firedfly
  • 2,299
  • 2
  • 22
  • 20
65
votes
5 answers

Where is SQL Profiler in my SQL Server 2008?

I downloaded SQL Server 2008 and can't seem to find SQL Profiler anywhere. I believe I installed the SQL Server Enterprise Express/trial version? I guess it was Express and not Enterprise after all right?
mrblah
  • 99,669
  • 140
  • 310
  • 420
47
votes
4 answers

How to dump an output from SQL Server Profiler 2008 to a CSV-like file

I am debugging stored procedures, and right now I am interested in what ran in what order and which which parameters as opposed to how fast things ran and what may sneak in between and cause a slowdown. So, I captured a couple of minutes worth of…
Hamish Grubijan
  • 10,562
  • 23
  • 99
  • 147
33
votes
2 answers

Can SQL Profiler display return result sets alongside the query?

In SQL Profiler 2005, is it possible to capture a result set in a SQL trace, so that I could see corresponding queries with result sets? ...Or is it only a one way trace? Thanks! George
George Johnston
  • 31,652
  • 27
  • 127
  • 172
32
votes
1 answer

Unit of measurement for Duration column in SQL Profiler

What is the unit of the Duration column in SQL Profiler? I thought it was milliseconds but in the following Profiler row I found it contradicting with start and end time: spid=163 duration=11310646 starttime=2010-04-06…
Mubashar
  • 12,300
  • 11
  • 66
  • 95
27
votes
4 answers

SQL server profiler not showing LINQ To Sql queries

I am trying to view SQL generated by Linq to SQL in the SQL Server Profiler (2005). I can see the sql sent to the server from anything except for linq to sql. I'm betting that I need to change event selections for the trace, but not sure what else…
Ronnie Overby
  • 45,287
  • 73
  • 267
  • 346
24
votes
1 answer

SQL Server Profiler deprecation - Replacement?

I am developing ASP.NET and SQL Server applications, sometimes i am having trouble with a SQL Query, and i would like to see the SQL Servers "response" and not just the ASP.NET error message (Which is not always very helpfull) The Profiler.exe tool…
user1359448
  • 1,539
  • 3
  • 14
  • 23
23
votes
2 answers

How to filter SQL Server 2008 Profiler Output for a single database?

SQL Server 2008 Profiler always profiles all databases. I want to restrict profiling or output to a single database. How can that be done most easily?
usr
  • 168,620
  • 35
  • 240
  • 369
22
votes
2 answers

In SQL Server, how to move/import a multiple .trc files to a trace table

I have a set of rollover .trc files recorded with Sql Profiler. mytrace.trc mytrace_1.trc mytrace_2.trc mytrace_3.trc I can import the first one using this command: use [my-database] SELECT * INTO…
frankadelic
  • 20,543
  • 37
  • 111
  • 164
22
votes
4 answers

How do I get parameter values for SQL Server query in SQL Server Profiler

I'm trying to analyze a deadlock in SQL Server 2008 profiler. I know how to find the offending sql queries, but the collected queries do not include parameter values. I other words I can see something like this: DELETE FROM users WHERE id =…
Adrian Grigore
  • 33,034
  • 36
  • 130
  • 210
21
votes
1 answer

Change Application Name in Sql Server Profiler

When profiling a .Net Application in SQL Server Profiler the default Application Name is taken from the Data Provider. How can I change this to my own Application Name?
Daniel Stackenland
  • 3,149
  • 1
  • 19
  • 22
1
2 3
…
24 25