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
10
votes
2 answers

Stored procedure output parameters in SQL Server Profiler

I've got a stored procedure with an int output parameter. If I run SQL Server Profiler, execute the stored procedure via some .Net code, and capture the RPC:Completed event, the TextData looks like this: declare @p1 int set @p1=13 exec…
Graham Clark
  • 12,886
  • 8
  • 50
  • 82
8
votes
1 answer

How initial startup for NHibernate Profiler

I have a Wpf application using Nhibernate. I want to see details of sent query to database by NHibernate Profiler. For initial startup, what should I do?
Ehsan
  • 3,431
  • 8
  • 50
  • 70
8
votes
1 answer

Can SQL Begin Try/Catch be lying to me (in the profiler)?

I'm calling a stored proc from BizTalk server and trying to debug it. 1) Use SQL Debugger when stored proc called by an external process 2) Getting sp_tracegenerateevent to work in a stored procedure I've been using SQL Profiler as my only tool to…
NealWalters
  • 17,197
  • 42
  • 141
  • 251
8
votes
2 answers

How to monitor transaction isolation level changes in SQL Profiler or in any other tool

I've successfully only been able to see transaction isolation level events in the Audit Login event. Are there any other ways to monitor the transaction isolation level changes using SQL Profiler or using some other tool? The reason I ask is because…
PussInBoots
  • 11,028
  • 9
  • 52
  • 84
8
votes
3 answers

How to find timed out statements in SQL 2005 profiler

I'm trying to find SQL statements that timed out using the SQL 2005 profiler. Is there a way to set such a filter?
Ron Harlev
  • 16,227
  • 24
  • 89
  • 132
8
votes
3 answers

Show Row Count in SQL Profiler

Is it possible to show a "Row Count" column in SQL Server Profiler? For example there are CPU and Duration columns but can it show how many rows a query returns?
Kobus Smit
  • 1,775
  • 2
  • 18
  • 30
8
votes
1 answer

Is there anyway for SQL Server Profiler to remember column widths?

I've setup SQL Server Profiler to only report events relevant to me and it works great. However, I think what sucks is that it doesn't remember the column widths. I could set them up properly and save it as a Profiler template, but the next time I…
AngryHacker
  • 59,598
  • 102
  • 325
  • 594
7
votes
1 answer

Reading SQL deadlock graph

Can someone please help me to read/understand this deadlock graph? I don't understand why process 75 is requesting a lock on an object that he has a lock on already?
Jacques
  • 747
  • 1
  • 8
  • 19
7
votes
1 answer

How to use SQL Server Profiler with an Azure SQL Server with AAD integrated security where AAD user is different from logged in desktop account?

Scenario: User logged in to desktop using domain account User has an Azure account in AAD which is different from the domain account Azure SQL database with AAD authentication configured for the Azure account How can user profile the SQL queries…
mark
  • 59,016
  • 79
  • 296
  • 580
7
votes
1 answer

How to "tag" Entity Framework Queries

I am helping improve the performance of a complex application with hundreds of Entity Framework queries scattered throughout the code base. One problem we have is that when we run the SQL Profiler and capture the Entity Framework queries it is very…
Toe Spam
  • 111
  • 4
7
votes
1 answer

Is it possible to capture a database trace on azure using T-SQL

I know one can't run SQL Profiler against azure databases. I recently learned that SQL profiler is really just a front end for functionality that is implicit to SQL Server i.e. SQL profiler doesn't really do any capturing, it just starts and stops…
user334911
7
votes
6 answers

How can i see what IP address made the request to SQL Server?

i need to clearly see what IP address made what sql query to SQL server. I am trying to use SQL Profiler, but it seems there is no way i can somehow to differentiate the machine (browser) where the query came from. It only has the communication…
HotFrost
  • 1,595
  • 4
  • 17
  • 25
7
votes
1 answer

MS SQL Server's equivalent to PostgreSQL's EXPLAIN

Is there a SQL Server equivalent to PostgreSQL's EXPLAIN command that I can run on SQL Server 2008 R2 Express (ie. without SQL Profiler)?
ajbeaven
  • 9,265
  • 13
  • 76
  • 121
6
votes
1 answer

Is my Entity Framework generated SQL executing twice?

I'm looking at analysing the performance of the SQL generated from Entity Framework 1, using MS SQL 2008. When I run a trace in SQL Server Profiler 2008, I noticed something that I didn't expect. For each query that gets executed, I get two…
Tr1stan
  • 2,755
  • 1
  • 26
  • 45
6
votes
1 answer

Why does SQL Server Profiler trace skip records?

I have a SQL Server Profiler trace and it's working for all commands. But the profiler skips one record like below:
Mahdi Rahimi
  • 564
  • 4
  • 22
1 2
3
…
24 25