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
19
votes
3 answers

SQL Server Profiler - how do I find which database is being connected?

I've Googled this with no success. I'm using SQL Server Profiler for SQL Server 2008 R2, and I've ensured that for the 'Events Selection' of the trace: I'm reporting all columns for Security Audit > Audit Login + Audit Logout I'm reporting all…
Chris Halcrow
  • 28,994
  • 18
  • 176
  • 206
18
votes
4 answers

SQL Server profiler not filtering by TextData column filter

I have a stored procedure, let's call it 'MyStoredProc', which gets called every few seconds. I want to filter it because it's cluttering the view. The proc is called like exec sp_executesql N'Exec @Return = [dbo].[MyStoredProc].... I already have…
Tony_Henrich
  • 42,411
  • 75
  • 239
  • 374
16
votes
2 answers

Is there a way in SQL profiler to filter by INSERT statements?

I am trying to identify SQL INSERTS that occur when a record is viewed from a Windows application. In SQL Profiler I have a long list of stored procedures that fire when the record is viewed, however it is very cumbersome to identify the stored…
user53885
  • 3,809
  • 11
  • 33
  • 43
15
votes
2 answers

SQL Profiler (SQL Server 2000), how to filter only my activities?

We have a big system with several hundred concurrent users so sql profiler gives a bit too much information without appropriate filters. I'd like to see what SQL commands are run under my account and my account only. With account I mean the username…
Micke
  • 151
  • 1
  • 1
  • 3
15
votes
2 answers

SQL Server Profiler - Why are some calls RPC:Completed and Some Calls SQL:BatchCompleted

I will be the first to admit that I often get confused when I use SQL Server profiler. Having said that, I decided to fire it up to see the SQL that was being generated by experimenting with the Include method of a Db Set. I was going through the…
ek_ny
  • 10,153
  • 6
  • 47
  • 60
13
votes
1 answer

SQL Profiler not showing inserts/deletes/updates

When I run the profiler while running my application, it only seems to show SELECTs, not INSERTs or anything that changes the database. Yet my database is being updated, so those commands must be being executed. What do I have to do to get it to…
Cynthia
  • 2,100
  • 5
  • 34
  • 48
13
votes
5 answers

Is there a way to filter a SQL Profiler trace?

I'm trying to troubleshoot this problem using SQL Profiler (SQL 2008) After a few days running the trace in production, finally the error happened again, and now i'm trying to diagnose the cause. The problem is that the trace has 400k rows, 99.9% of…
Daniel Magliola
  • 30,898
  • 61
  • 164
  • 243
13
votes
2 answers

SQL Server Profiler - watch for permission denied on objects?

I'm using SQL Profiler to watch some database activity, and I'm interested in watching "Permission Denied" for various objects in the database. There are about 50 different items in the "Security Audit" category, but none that seem to display…
SqlRyan
  • 33,116
  • 33
  • 114
  • 199
12
votes
1 answer

SQL Server Profiler - How to filter trace to only display TSQL containing a DELETE statement?

I have a SQL Trace setup to monitor all TSQL being issued to a single database. However I only care about 'DELETE' TSQL statements being issued. Is there any way I can filter to just reporting these type of statements to the profiler? Thanks!
atconway
  • 20,624
  • 30
  • 159
  • 229
12
votes
2 answers

Can profiler templates be migrated to newer versions of SQL Profiler?

Is it possible to migrate Profiler templates to newer versions of SQL Server? In my case I want to take my SQL 2008 templates to 2012. I've tried (1) a straight file copy and (2) an export/import. In both cases the older templates run, but…
EBarr
  • 11,826
  • 7
  • 63
  • 85
11
votes
1 answer

SignInManager.PasswordSignInAsync generate many database access

In my application, I use ASP.NET Identity. Every thing is work fine but by testing, I found that the following command produces many database accesses: SignInManager.PasswordSignInAsync: var result = await…
Ahmed Shamel
  • 1,982
  • 3
  • 24
  • 58
11
votes
3 answers

SQL Server Profile - View Parameter Values?

In SQL Server Profile, I have it tracing SP:StmtStarting events. The "TextData" includes information like the following: EXEC MySortedProc @param, NULL, @param2, NULL What would I have to trace (or can I?) to view the value of those…
Tyllyn
  • 279
  • 1
  • 4
  • 12
11
votes
2 answers

How do I capture the data passed in SqlBulkCopy using the Sql Profiler?

I am using Sql Profiler all the time to capture the SQL statements and rerun problematic ones. Very useful. However, some code uses the SqlBulkCopy API and I have no idea how to capture those. I see creation of temp tables, but nothing that…
mark
  • 59,016
  • 79
  • 296
  • 580
10
votes
2 answers

SQL: How can I get the number of executed queries per database or hour or ...?

Is there any way to see how many queries are executed in like every hour, or per database / hour, or average number of queries on a day, or ...whatever is interesting? Just for statistics.. I like numbers. I can't just start a trace with Sql Server…
Erik Dekker
  • 2,395
  • 5
  • 33
  • 55
10
votes
3 answers

SQL Server: Event does not reference any tables (Tuning Advisor warning)

I have an application written in C# which uses Linq2SQL for communicating with the SQL Server. There are some queries that run a bit (very) slow, and I figure it probably need some indexes to speed things up. But I don't really know how to do that…
Svish
  • 152,914
  • 173
  • 462
  • 620
1
2
3
…
24 25