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
6
votes
1 answer

Logging erroneous queries only on SQL server

I have what would seem to be an easy goal to accomplish, yet I have not found a good solution. Google does not shed a light on it and I just hope that I have been looking for a solution in wrong places or just tried to use tools in a wrong way... Or…
Sebastian Zaklada
  • 2,308
  • 1
  • 14
  • 25
6
votes
2 answers

SQL Server Profiler: Get stored procedure name

I am running SQL Server Profiler (SQL Server 2008). Is there a way to see the name of the stored procedure that is executing? I am profiling SP:Started and SP:Completed. The TextData column hasn't been helpful as my stored procedures are encrypted…
JeredM
  • 897
  • 1
  • 14
  • 25
6
votes
1 answer

SQL Server Profiler not showing SQL statements embedded in ColdFusion components

In our ColdFusion 11 app with SQL Server 2008 R2. A .cfm file is using a CF component that is called with a syntax such as: objMyTable = createobject('component','components.myTable); qmyTable2list =…
nam
  • 21,967
  • 37
  • 158
  • 332
6
votes
1 answer

SQL Server Profiler showing SCOPE_IDENTITY() while ColdFusion code is not using it in any query

I am using SQL Server 2008 R2 Profiler to debug an issue on a ColdFusion 7 application - that was developed by someone else - running on Windows 7 with SQL Server 2008 R2 as a backend. The application was originally using MS Access 2003 as a backend…
nam
  • 21,967
  • 37
  • 158
  • 332
6
votes
4 answers

Reducing the overhead of a SQL Trace with filters

We have a SQL 2000 server that has widely varied jobs that run at different times of day, or even different days of the month. Normally, we only use the SQL profiler to run traces for very short periods of time for performance troubleshooting, but…
BradC
  • 39,306
  • 13
  • 73
  • 89
5
votes
1 answer

SQL Server Profiler : capture calls to your database's stored procs during SSRS report generation

Using SQL Server/SSRS 2008. With SQL Server Profiler, I've been unsuccessfully trying to trace SSRS (rdl) report generation calls to my database's stored procs i.e. so I can see what parameter values are being passed etc. What events should I be…
Moe Sisko
  • 11,665
  • 8
  • 50
  • 80
5
votes
1 answer

Why is NULL reads so high in my SQL trace?

I have inserted data from a sql trace in a table and I have a problem interpreting the data in table. In the attached image the reads related to my SP are very low but on the next line for a value of NULL in Text Data column the reads are very…
Pawan Pillai
  • 1,955
  • 5
  • 37
  • 64
5
votes
1 answer

SQL Profiler 2008 Deadlock Graph ToolTip Not Showing actual statements

In a deadlock graph, hovering over the deadlock ovals should produce the SQL statement. However, in SQL Profiler 2008, the ToolTip is either showing "Statement" or "Statement Proc" and not the statement itself. Does anyone ? Is there a workaround?
Jacques
  • 747
  • 1
  • 8
  • 19
5
votes
1 answer

What is the escape character for column filters using like in SQL Server Profiler?

I am trying to find an example of a specific exploit in our sql server traces and I want to filter the TextData column for '%' occurring three times: %%%. This means that I have to escape the special character %. One try was to use '\' as an escape…
Ovidiu Pacurar
  • 8,173
  • 2
  • 30
  • 36
5
votes
1 answer

C#, sp_executesql and Incorrect Syntax

I'm calling the code below. On the line (IDataReader dr = cmd.ExecuteReader()) sql barfs with an Incorrect syntax near 'CompanyUpdate'. using (SqlCommand cmd = new SqlCommand("CompanyUpdate")) { …
Christian Payne
  • 7,081
  • 5
  • 38
  • 59
5
votes
1 answer

SQL 'comment' that can be read in a sql profiler

I've tried several methods such as using double hyphens, i.e. --THIS IS A COMMENT but when the executed sql is read in a profiler the comment is stripped out leaving only raw SQL that is being performed. I want to do this to enable rapid…
Paul Zahra
  • 9,522
  • 8
  • 54
  • 76
5
votes
2 answers

Capture query results using SQL Server Profiler

It's possible to capture a query's result using SQL Server Profiler? i.e. the resultset generated by the query
SDReyes
  • 9,798
  • 16
  • 53
  • 92
5
votes
1 answer

Identifying Timeout Causes with SQL Server Profiler

We are experiencing seemingly random timeouts on a two app (one ASP.Net and one WinForms) SQL Server application. I had SQL Profiler run during an hour block to see what might be causing the problem. I then isolated the times when the timeouts were…
Andrew MacNeill
  • 390
  • 3
  • 8
4
votes
2 answers

How can I use SQL Server Profiler to view the TSQL ran in a CLR trigger?

How can I user SQL Server Profiler to view the TSQL ran in a CLR trigger? I have a CLR trigger in the a MS SQL Server DB, that checks the Inserts, Updates, Deletes on a table and then conditionally does inserts to another table. Is there a setting…
John Egbert
  • 5,496
  • 8
  • 32
  • 44
4
votes
1 answer

How to find out client process ID in SQL Server Profiler?

I am using SQL Server Profiler to view my database activities. In that, I want to find out which Client Process ID is associate with which machine (From where application is running). because there are multiple instance of my application are running…
Brijesh Patel
  • 2,901
  • 15
  • 50
  • 73
1 2 3
…
24 25