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

SQL Server Profiler

I have some stored procedure which doesn't work so fast as I expected. declare @account_id integer = null declare @house_id integer = 8 exec bills_supp_main '01.10.2013', '01.11.2013', @account_id, @house_id In fact this procedure is "wrapper" for…
Alex Zhulin
  • 1,239
  • 2
  • 22
  • 42
0
votes
1 answer

ADO.NET and SSMS interpret SP params differently or SQL profiler has a bug?

Try to be brief. Here is my table and SP in SQL Server 2008 R2 database: CREATE TABLE dbo.TEST_TABLE ( ID INT NOT NULL IDENTITY (1,1) PRIMARY KEY, VALUE varchar(23) ) GO CREATE PROCEDURE USP_TEST_PROCEDURE ( @Param1…
Alex
  • 423
  • 4
  • 7
0
votes
4 answers

SQL Profile and DTA

Here is the scenario: I have run a trace for few hours during maximum server load using the three events (never mind this) that DTA looks for. I then stop and feed this profiler load to DTA. It does its tuning work and gives me feedback on what…
Tesnep
  • 105
  • 1
  • 2
  • 11
0
votes
0 answers

how trace database sdf file by sql server profiler

How can consider a sdf database file in App_Data Folder in visual studio in sql sever profiler? I try to open file by File-> Open-> Trace File (below pic) but it doesn't accept .sdf file as trace…
Mohammadreza
  • 3,139
  • 8
  • 35
  • 56
0
votes
1 answer

sql profiler causes 'scan with NOLOCK due to data movement'

I have a procedure that fills up a bunch of regular and temp tables with millions of records and takes hours to complete. Its no problem when I run it alone. However, I've been trying to improve performance and am trying a SQL Profiler tuning…
Tom McDonald
  • 1,532
  • 2
  • 18
  • 37
0
votes
1 answer

Find user by PID in Citrix environment

We're running a Citrix farm and I'm trying to track heavy users of our DB, I can get the PID of the process from Sql Profiler but I then need to laboriously search for that PID in each server in the farm - anyone know a better way?
MrTelly
  • 14,657
  • 1
  • 48
  • 81
0
votes
0 answers

SQL Server Profiler's Reads in SSMS

Actually I'm working over a slow running SQL query and I can only access the production database through SSMS. I don't have the direct access to production server or profiler because it's a shared server. Production machine and developement machine…
Prakash
  • 741
  • 1
  • 7
  • 11
0
votes
0 answers

Simple SQL Server Profiler Event Advice

I have to debug a long running SQL Server stored procedure which dynamically builds and executes queries at runtime. I want to run a trace so I can see all of the individual pieces of SQL that are executed. Which events will provide that level of…
Jimbo
  • 1,685
  • 3
  • 12
  • 15
0
votes
1 answer

SQL Server 2008 Profiler

How can I Filter only my calls to Shared SQL Server using a shared login account when debugging? I am using SQL Profiler and was curious if anybody knows the Column Filters I can use to focus only to my calls. I have the LoginName set to the Account…
Moojjoo
  • 729
  • 1
  • 12
  • 33
0
votes
1 answer

Using one connection for Context object in EF

How can I use same connection for two Query in EF, for example I wrote this code in MVC controller: DataLayer.Context context = new DataLayer.Context(); [ChildActionOnly] public int TodayVisits() { return…
Saeed Hamed
  • 732
  • 2
  • 10
  • 28
0
votes
0 answers

Why cant I see the changes Entity Framework is trying to make in the SQL 2008R2 Profiler?

My code raises an update exception when I call my context SaveChanges. I am using Entity Framework 5 code first. I want to see the SQL EF is trying to run in the profiler, so I can figure out what field I have missed populating. The profiler…
Kirsten
  • 15,730
  • 41
  • 179
  • 318
0
votes
0 answers

Running SQL Server Profiler 24/7

I have low-level traces that I used to SQL Profiler to create and I would like to run these traces 24/7. So for I have the trace result imported to a table in the database and It stop running when I close the SQL Profiler instance. Is there a way to…
Zeze
  • 11
  • 1
  • 5
0
votes
1 answer

SQL Server Profiler causing CPU spike

Is it possible for SQL Profile to cause issues for SQL Server? We noticed an issue with one of the CPU at full capacity and we decided to turn SQL profiler off and the spike was gone! Has anyone experienced this and how does it happen? How can you…
Abs
  • 56,052
  • 101
  • 275
  • 409
0
votes
1 answer

Se SQL statetement beeing run within a procedure with SQL Server Profiler

This is not directly a programming question but I ask it anyway because it's related to debugging. I wonder if it's possible to see exactly what SQL statements that are being executed within a procedure in Microsoft SQL Server Profiler? For now I…
Robert
  • 4,602
  • 4
  • 22
  • 33
0
votes
1 answer

Numeric(x,x) to Decimal(x,x) Sql Server weirdness

I have a really weird problem. I have a stored proc which has the following params: @Id int OUTPUT, @DataSourceId int, @OwnerId int, @Size numeric(16,6), @SizeUnitId int, @LayCanFrom datetime, @LayCanTo datetime, @DischargeDate datetime, @IMO…
tranceporter
  • 2,241
  • 1
  • 21
  • 23
1 2 3
…
24 25