sql-server-profiler Questions
2
Solved
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...
Vimineous asked 21/9, 2012 at 21:36
1
Solved
I know one can't run SQL Profiler against azure databases. I recently learned that SQL profiler is really just a front end for functionality that is implicit to SQL Server i.e. SQL profiler doesn't...
Absorbent asked 28/1, 2014 at 18:30
2
Solved
I've got a stored procedure with an int output parameter. If I run SQL Server Profiler, execute the stored procedure via some .Net code, and capture the RPC:Completed event, the TextData looks like...
Earth asked 4/2, 2010 at 9:57
5
Solved
I downloaded SQL Server 2008 and can't seem to find SQL Profiler anywhere.
I believe I installed the SQL Server Enterprise Express/trial version?
I guess it was Express and not Enterprise after a...
Clayborn asked 11/3, 2009 at 3:20
5
Solved
I'm trying to troubleshoot this problem using SQL Profiler (SQL 2008).
After days of running the trace in production, the error happened again and I'm diagnosing it.
The problem is that the trace h...
Ramiroramjet asked 21/9, 2009 at 2:58
1
Solved
Is there a SQL Server equivalent to PostgreSQL's EXPLAIN command that I can run on SQL Server 2008 R2 Express (ie. without SQL Profiler)?
Lavenialaver asked 3/5, 2013 at 3:52
1
Solved
I am developing ASP.NET and SQL Server applications, sometimes i am having trouble with a SQL Query, and i would like to see the SQL Servers "response" and not just the ASP.NET error message (Which...
Carleencarlen asked 19/4, 2013 at 15:51
2
Solved
I have a set of rollover .trc files recorded with Sql Profiler.
mytrace.trc
mytrace_1.trc
mytrace_2.trc
mytrace_3.trc
I can import the first one using this command:
use [my-database]
SELECT ...
Rebuttal asked 6/5, 2010 at 21:39
1
Solved
(Sorry for the longish question, I'll try to be concise.)
I'm running SQL Server Profiler and I'm chasing down some performance issues. I'm relatively new to what the profiler does and I've export...
Roice asked 2/11, 2012 at 16:1
1
Solved
When I execute:
var t = db.Table1.OrderBy(x => x.Name).ToList();
In SQL profiler, this is the translated SQL:
SELECT
[Extent1].[ID] AS [ID],
[Extent1].[Name] AS [Name]
FROM [dbo].[Table1] ...
Feckless asked 31/8, 2012 at 7:32
1
Solved
I'm looking at analysing the performance of the SQL generated from Entity Framework 1, using MS SQL 2008.
When I run a trace in SQL Server Profiler 2008, I noticed something that I didn't expect. ...
Olio asked 6/3, 2012 at 12:40
2
Solved
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...
Pretypify asked 23/3, 2012 at 15:36
1
Solved
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 va...
Erlandson asked 2/2, 2012 at 5:1
1
Solved
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 ...
Herringbone asked 22/12, 2011 at 18:58
1
Solved
I have a Wpf application using Nhibernate.
I want to see details of sent query to database by NHibernate Profiler.
For initial startup, what should I do?
Feldman asked 5/11, 2011 at 13:13
1
Solved
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 thes...
Complaisance asked 26/10, 2011 at 13:23
1
Solved
Can someone please help me to read/understand this deadlock graph?
I don't understand why process 75 is requesting a lock on an object that he has a lock on already?
Chuipek asked 1/9, 2011 at 8:43
3
Solved
Trying to understand what Sql Profiler means by emitting "sp_reset_connection".
I have the following, "exec sp_reset_connection" line followed by BatchStarting and Completed,
RPC:Completed ...
Palmate asked 13/3, 2009 at 1:7
1
Solved
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 pl...
Hathorn asked 4/3, 2011 at 22:4
3
Solved
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...
Capps asked 14/5, 2009 at 11:36
4
Solved
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 pe...
Liberty asked 13/11, 2008 at 15:47
1
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 b...
Kaminsky asked 21/9, 2010 at 23:58
2
Solved
I have a trace setup for SQL Server Profiler to monitor SQL that is executed on a database. I recently discovered that trigger execution is not included in the trace. After looking through availabl...
Dorie asked 1/10, 2008 at 20:23
1
Solved
What is the unit of the Duration column in SQL Profiler? I thought it was milliseconds but in the following Profiler row I found it contradicting with start and end time:
spid=163
duration=113106...
Moreno asked 7/4, 2010 at 5:58
2
Solved
In SQL Profiler 2005, is it possible to capture a result set in a SQL trace, so that I could see corresponding queries with result sets? ...Or is it only a one way trace?
Thanks!
George
Eductive asked 18/1, 2010 at 14:41
© 2022 - 2024 — McMap. All rights reserved.