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

How to monitor SQL statements that are doing hard delete

I have an application that interacts with SQL Server 2008. I want to write a tool that help me identifying the SQL statements that causes hard delete in the table. Is it possible to find out using the SQL Profiler? or should i write triggers in all…
Jeeva
  • 4,585
  • 2
  • 32
  • 56
0
votes
2 answers

Linq to Entities query hitting db twice

I have the following pretty simple linq query querying a linq to entities edmx. (from i in ent.Inspectors select i).OrderBy(s => s.Surname).Skip((page - 1) * count).Take(count).ToList(); In Sql Server Profiler I can see that the exact same select…
DavidGouge
  • 4,583
  • 6
  • 34
  • 46
0
votes
1 answer

SQL Profiler not connecting to my server

My SQL Profiler was working previously against my Server. I have not (AFAIK) made any modifications to the configuration of my server. When I go into SQL Profiler I attempt to "Connect to SQL Server", I enter my SQL Server (which is on my local dev…
Nathan Koop
  • 24,803
  • 25
  • 90
  • 125
0
votes
3 answers

How to investigate why sql script that runs every day taking 2 min is taking 2 hours?

My colleague asked me a question today "I have a SQL script containing 4 select queries. I have been using it daily for more than a month but yesterday same query took 2 hours and I had to aborting execution." His questions were Q1. What…
Shantanu Gupta
  • 20,688
  • 54
  • 182
  • 286
0
votes
1 answer

Mysterious time out on .NET MVC application with SQL Server

I have a very peculiar problem and I'm looking for suggestions that might help me get to the bottom of it. I have an application in .NET 3.5 (MVC3) on a SQL Server 2008 R2 database. Locally and on two other servers, it runs fine. But on the live…
Nick
  • 2,877
  • 2
  • 33
  • 62
0
votes
1 answer

SQL Profiler throws an error : Could not load file or assembly 'System.Data, Version = 2.0.0.0?

I installed a third-party SQL Server 2008 R2 toolset a few days ago and then uninstalled it yesterday. But now when I run SQL Profiler from SSMS, I get an error that says: Could not load file or assembly 'System.Data, Version = 2.0.0.0. I…
Sunil
  • 20,653
  • 28
  • 112
  • 197
0
votes
1 answer

Getting actual executin time/duration of MDX query

How can I get the actual execution time or actual duration taken by an MDX query to run? I am not interested for compiling, parsing, rendering results etc. I am only interested for the execution time. In sql profiler, I get two columns one is…
Ahmed Tanvir
  • 187
  • 7
0
votes
0 answers

SQL Server Profiler, ObjectName column, 'Split'

What is the meaning of ObjectName column in SQL Server Profiler? This http://msdn.microsoft.com/en-us/library/aa173882(v=sql.80).aspx gives rather concise definition. For the records that are interesting to me it's either blank -- when executing…
Adam
  • 45
  • 1
  • 6
0
votes
0 answers

How do I see the final query text for a stored procedure sql query?

I am investigating a single stored procedure that is returning odd results. It dynamically builds sql and uses views and functions. It is difficult to follow what the final sql query applied to the database actually is from the code. Can I use SQL…
Gary Barrett
  • 1,764
  • 5
  • 21
  • 33
0
votes
1 answer

How to get other related events that where not traced?

Is there a way to get information about other events related the the process, that where not caught by SQL-server profiler (not included in filter list). For instance, if I only trace the deadlock-graphs and when I catch that kind of event, can I…
Artur Udod
  • 4,465
  • 1
  • 29
  • 58
0
votes
2 answers

SQL Profiler - no hostname on Crystal Report

I am currently using SQL Server 2008 and Crystal Report 8.0. There are times when I need to know what computer runs the crystal report and unfortunately I can't seem to see it in SQL Profiler.
user1051439
0
votes
0 answers

Reasonable length of trace?

What's the overhead like for running a long SQL Server Profiler trace? Any considerations to running a 24 hour trace on production server? I'd like to get a good sample of what's going on when actual users are using the system instead of running…
hhuttunen
  • 57
  • 5
0
votes
1 answer

How to see what SQL statements are executed when using SQL Express?

I am using SQL Express so I don't have access to SQL Profiler tools. Is there something I can use to see what statements are being executed while running an ASP.NET MVC application (live or in debug, either is fine). Thanks in advance.
BBauer42
  • 3,549
  • 10
  • 44
  • 81
0
votes
2 answers

Failed to save trace data to table - Profiler stops with this message

I am trying to run profiler and get it to log to a database. The profiler starts to run and then after few hours (yes few hours, I know its bad!!) the profiler stops with the message. Failed to save trace data to table When I look at the logs, I…
Sabrish Ayyappan Balachander
  • 241
  • 1
  • 10
0
votes
3 answers

SQL Server Profiler discrepancy

I am struggling with a strange problem using Sql Profiler. While running some performance testing scripts, I run profiler to find bottlenecks. One particular statement seems to be taking a lot of time - with CPU 1407, Reads 75668 and Duration of…
Susan
1 2 3
…
24
25