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

Understanding SQL Profiler trace

I'm currently experiencing some problems on my DotNetNuke SQL Server 2005 Express site on Win2k8 Server. It runs smoothly for most of the time. However, occasionally (order once or twice an hour) it runs very slowly indeed - from a user perspective…
Stuart
4
votes
4 answers

Is it possible to automate SQL Server 2008 profiler?

There was a post regarding useful SQL tricks. Here I was going to mention the SQL Server Profiler tool, as it has helped me write less SQL. I would write SQL that would interrogate, understand or second guess the databases business logic. Profiler…
Ferdeen
  • 21,332
  • 6
  • 29
  • 31
4
votes
6 answers

SQL Server Profiler showing EF queries against master database?

What am I missing here? The queries I see in SQL Server Profiler are all targeted against the master database, which makes it difficult to filter by database name ... which event or events should I be watching so I can filter by database name. The…
mattruma
  • 16,589
  • 32
  • 107
  • 171
4
votes
1 answer

capture flow of execution in SQL Server

I am very new to Microsoft SQL server. I am wondering if it is possible to capture a trace of the sql query on a database executed from an external program while ignoring the actions caused by trigger. I used SQL profiler and choose to capture the…
defoo
  • 5,159
  • 11
  • 34
  • 39
4
votes
3 answers

How to profile Entity Framework activity against SQL Server?

It's easy to use SQL Server Profiler to trace stored procedures activity. But how to trace SQL queries issued by LINQ via Entity Framework? I need to identify such queries (LINQ code) that consume a lot of time, are called most frequently and…
Vlad
  • 1,977
  • 19
  • 44
4
votes
3 answers

LINQ + TransactionScope will not change isolation level in SQL Server Profiler

I'm using the following format for commiting changes to my db using linq. Begin Transaction (Scope Serialized, Required) Check Business Rule 1...N MyDataContext.SubmitChanges() Save Changes Done In Previous Query To Log File End…
Dasith Wijes
  • 1,328
  • 12
  • 22
4
votes
1 answer

SQL Server 2005 -Seeing SPs executing inside SPs

I am wondering if it is possible to see stored procs that are being executed by other stored procs in Sql Server Profiler, is it possible, and if so how?
CSharpAtl
  • 7,374
  • 8
  • 39
  • 53
4
votes
3 answers

Where can I find Microsoft Sql Profiler 2005?

Is there a way to get the profiler without installing Microsoft Sql Server? If the answer is no, which edition do I need to get the profiler? Do I need the Developer Edition?
Kevin
  • 3,574
  • 10
  • 38
  • 43
4
votes
2 answers

Is it possible to write code which can not be traced from SQL profiler?

I have a third party application developed in C# running as Windows service, I wanted to trace all SQL code that the application fired to the backend (SQL server). so started SQL profiler and collected all the trace steps. After investigating each…
user3412047
  • 53
  • 5
4
votes
2 answers

NHibernate taking a long time to run query

This is being done using Fluent NHibernate I've got a NHibernate lookup that is retrieving data from one table. If i take the generated sql and run it through query analyzer, it takes ~18ms to run. Using NHProfiler, i'm getting the duration of this…
dave clements
  • 1,505
  • 2
  • 13
  • 28
4
votes
1 answer

SQL Server Profiler: How can I display query parameter values in deadlock graph?

I'm trying to debug a deadlock with SQL Server Profiler 2008. I know how to get a graph of the deadlock in the profiler, but when I hover over one of the two statements in shown in the graph, the "Statement" tooltip that appears only contains the…
Adrian Grigore
  • 33,034
  • 36
  • 130
  • 210
4
votes
4 answers

Is there a Microsoft SQL Profiler equivalent for Oracle

99% of my time is in SQL Server land and so I'm not at all familiar with Oracle or its products...Is there a similar application to Microsoft SQL Profiler for use against Oracle databases? I'm helping debug/tune an ASP.Net application that connects…
davidsleeps
  • 9,393
  • 11
  • 59
  • 73
4
votes
1 answer

Deadlock graph in SQL server profiler shows mutual lock on the same clustered key

I am trying to identify the reason of deadlock using SQL Server Profiler. Here's the deadlock graph: Both statements are inserts followed by select scope_identity(); Actually a have 2 concurrent processes that repeatedly do insert-select_identity…
Artur Udod
  • 4,465
  • 1
  • 29
  • 58
3
votes
1 answer

How to see variable values in SQL Profiler when Trigger fires?

I am creating an "After Update" Trigger on a SQL Server 2008 table. The trigger fires just fine but one of the values it's updating in another table isn't correct. I am looking at a trace in SQL Profiler, but I can't see my variable's values in…
Peter
  • 423
  • 5
  • 15
3
votes
1 answer

how can i turn off lines from "Report Server" on my SQL Server Profiler?

It's my first time using SQL Server Profiler and I'm wondering how can i turn off event lines from the application "Report Server" on my SQL Server Profiler? I just want certain activities to be logged like ones from LINQPad and Entity…
Jan Carlo Viray
  • 11,856
  • 11
  • 42
  • 63
1 2 3
…
24 25