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
0
votes
4 answers

sql server profiler 2014 "failed to open a table"

I'm trying to replay SQL Server 2014 Profiler trace that I saved to a DB table. When I open I get "Failed to open a table" error message. There is nothing in the windows logs. I googled and this error used to happen when upgrading a SQL Server 2000…
Tom McDonald
  • 1,532
  • 2
  • 18
  • 37
0
votes
1 answer

SQL Profiler connection details

When you startup a standard trace the first settings you see will be the current database connections. In my case there is about 10 entries, all of whome are the same username, however some are dateformat dmy and some are mdy. The asp website seems…
Robert
  • 1,835
  • 4
  • 25
  • 30
0
votes
0 answers

Find all queries which returns a particular text in sql server

I am using sql server 2012. I want to search all the queries in all databases of a server which returns this text ("ca040"). I am using SQL Server Profiler with filtered TextData. But it is not showing any results. Have I gone for the correct…
nrvbha
  • 139
  • 4
  • 19
0
votes
0 answers

How to see stored proc/functions within stored proc in profiler

I hope this question is not a duplicate as I searched for it and didn't see many meaningful answers. Is it possible using profiler to see the calls being done for procedure and functions within a procedure? I am currently using a simple select…
AngelicCore
  • 1,413
  • 3
  • 22
  • 40
0
votes
2 answers

Debugging "Incorrect Syntax" Exception

I have recently been working with a COM+ component that processes an input XML file, and makes a number of database updates based on the supplied data. Running SQL Profiler with EventClass Exception, and User Error Message selected, I see: Exception…
MattH
  • 4,166
  • 2
  • 29
  • 33
0
votes
1 answer

How to determine which stored procedures are being executed (MSSQL 2008 R2)

I'm having a real problem with my application and SQL Server (2008 R2). I have a bug whereby a stored procedure is failing because of a misconfigured SQLCMD variable but the call to the stored procedure is in an assembly for which I don't have the…
serlingpa
  • 12,024
  • 24
  • 80
  • 130
0
votes
0 answers

SQL:batchcompleted has a long duration.

I have a problem with a program I am running, where a query sometimes take 10-30 seconds to complete. I thought about using the SQL profiler to help me identify the problem. The profiler definately shows that there is a problem, but I dont really…
Jesper Plantener
  • 229
  • 3
  • 16
0
votes
1 answer

How to find unique SQL queries out of SQL server trace log queries

I would like to process massive amount of SQL queries and only keep unique ones. I mean same queries with different parameters will be removed and only 1 signature query will be left for each unique query. Now what i am asking in this question is…
Furkan Gözükara
  • 22,964
  • 77
  • 205
  • 342
0
votes
0 answers

SQL Profiler Trace - why is function inside stored procedure listed twice as for Showplan XML and SP:Completed

I have probably very simple question. I've started to learn how to profile MSSQL databases and I've created a trace template. As test I've tried to call a simple stored procedure inside which is a one call for function. When I run the procedure and…
Emil
  • 306
  • 5
  • 16
0
votes
1 answer

SQL Profiler displaying stored procedure that doesn't exist

I have an automated service that runs 3 stored procedure namely sp_1, sp_2, sp_3. When I was running SQL Trace, it displayed the following results EXEC sp_1 EXEC sp_1 EXEC sp_2 EXEC sp_2 EXEC sp_4 EXEC sp_4 EXEC sp_2 EXEC sp_2 I don't know where…
deepz
  • 225
  • 3
  • 13
0
votes
0 answers

Are there any way to extract unique signatures from SQL server 2014 trace file?

I am capturing tuning trace via SQL server 2014 profiler Since my game is pretty active the file gets GBs in few minutes However there are so many duplicate queries So i want to extract unique signatures out of it So my question is how can i do it…
Furkan Gözükara
  • 22,964
  • 77
  • 205
  • 342
0
votes
0 answers

If a certain operation/operator appears in actual query plan then is it necessary that the operation has executed?

I have captured Showplan XML Statistics Profile event class and I got this plan . I have also captured Scan:Started event class. Here is a part of the plan that appears for Showplan XML Statistics Profile What took me by surprise is that although…
Sameer
  • 3,124
  • 5
  • 30
  • 57
0
votes
2 answers

Entity Framework 6 Log - SQL Profiler

I have enable EF 6 Log Functionality into my application: // Add loggin (DEVELOPMENT ONLY) DbContext.Database.Log = logInfo => System.Diagnostics.Debug.WriteLine(logInfo); Its working fine but I see like repeated SQL Queries in my Console, so I…
VAAA
  • 14,531
  • 28
  • 130
  • 253
0
votes
0 answers

How to check for hardcoded values in SQL Server Profiler?

To fight against SQL injection risks, I would like to check for hardcoded values (string, dates, boolean, numeric) in SQL statement using SQL Server Profiler 2012. The problem is that there is too much statements to read those one by one. Do you see…
NLemay
  • 2,331
  • 3
  • 29
  • 45
0
votes
4 answers

.net Integrating SQL Profiling

We have an .net enterprise application which backs onto an SQL Server backend. With some of our bigger customers now we are coming across some SQL based performance bottlenecks. We've applied as much global indexing that we can see which would…
Matt
  • 3,305
  • 11
  • 54
  • 98
1 2 3
…
24 25