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 get SSAS tabular model attributes and dimensions usage details

I need to create a cube which purpose would be to gather detailed information about tabular model dimensions and attributes usage by users (e.g. how many times users access certain dimension). So far, I tried to use Data Management View Query…
nefima
  • 1
  • 2
0
votes
1 answer

BinaryData column in SQL Server Profiler

I saved SQL Server profiler on a table for monitoring. There is a Binarydata column in it, how to access the data from BinaryData column in SQL Server Profiler using queries or etc.?
Ehsan HP
  • 456
  • 2
  • 5
  • 16
0
votes
1 answer

SQL Server : capture views using Profiler

I have a SQL Server with dozen of databases and thousands of objects. I need to run a scenario from my client side and check what views were used in the process. They might be called from a stored procedure or used directly. I tried the next events…
chainlightning
  • 43
  • 1
  • 5
0
votes
1 answer

SQL Server Profiler does not show data in SQL statement

I am using the SQL Server Profiler to trace the SQL generated from nHibernate in a Windows SmartClient appplication. The trace of the SQL statement does not show actual data, but rather, looks like this: exec sp_executesql N'SELECT…
Al Lelopath
  • 6,448
  • 13
  • 82
  • 139
0
votes
0 answers

SQL Server Profile Reusable Trace File

I can create a Trace and get it up and running with SQL Server Profiler. However, instead of going through the process of picking everything I want to trace including a particular database everytime, I just want to save the configuration, and…
Andez
  • 5,588
  • 20
  • 75
  • 116
0
votes
1 answer

Use MS SQL Server Profiler to see which stored procedures are running slowly

I have a basic knowledge about Microsoft SQL Server Profiler but I want to know that can I monitor a production environment to see which stored procedures are affecting performance by executing too slowly?
Jason Clark
  • 1,307
  • 6
  • 26
  • 51
0
votes
2 answers

Configuring SQL profiler

Is there a quickstart guide on how to configure SQL profiler for SQL 2005? I am using a shared database, so I want to only view queries that are executed by my application.
DNR
  • 3,706
  • 14
  • 56
  • 91
0
votes
1 answer

SQL Server Profiler issue

I am using SQL Server 2008 Enterprise and I want to use SQL Server profiler to capture deadlock event only. And when deadlock occurs and event captured, I will stop SQL Server profiler. My question is, since I launched SQL Server profiler, and…
George2
  • 44,761
  • 110
  • 317
  • 455
0
votes
1 answer

Help with SQL Trace

I have setup SQL Profiler as follows - Template: Tuning Save to dbo.myTable Event selection: Duration greater than or equal to 2000 (ms) This will record TextData, Duration, SPID, DatabaseID, DatabaseName, ObjectType, LoginName for the events…
user23048345
  • 3,033
  • 7
  • 31
  • 31
0
votes
1 answer

SSRS Report Does Not Show Up in Profiler Trace

I have written an SSRS Report and everything works fine within the Visual Studio Solution. When I try to view the report within the browser, all of the parameter fields and columns display, but no data is pulled. There are no errors when running the…
user2020058
  • 591
  • 2
  • 7
  • 9
0
votes
0 answers

SQL Profiler not showing the parameters passed to a SSRS report

I am a first time Sql Profiler user.I only want to check the parameters being passed from the SSRS report to SP it is calling. So,I start the trace in SQL Profiler and then View the report during which the SP is called and the fields are…
A NewBie
  • 181
  • 1
  • 5
  • 18
0
votes
1 answer

Correlating SQL Profiler trace with code that caused query

I'm using SQL Profiler to trace the behaviour of an application that seems to be creating more transactions than it needs. The problem is, it's quite hard to correlate a particular line in the the trace with the C# code that caused it - is there an…
GoatInTheMachine
  • 3,583
  • 3
  • 25
  • 35
0
votes
1 answer

How can I capture SQL query performance statistics when executing queries via ADO.NET

When I use Sql Server Profiler, I can see a bunch of useful performance statistics for my queries (CPU, page reads, etc). I'd like to be able to capture these when my .NET code runs queries for logging and benchmarking purposes. To best correlate…
ChaseMedallion
  • 20,860
  • 17
  • 88
  • 152
0
votes
1 answer

Blank DatabaseName column in SQL trace in SQL Server 2000

I have run the SQL trace in SQL Server 2000. The database name column is blank even when it shows values in the database ID column. I checked the properties of the trace, which has database name added such as: Trace File Properties -> Data…
Anandita Sharma
  • 405
  • 1
  • 3
  • 9
0
votes
2 answers

If I KILL(SPID), what happen the running transaction?

I have a procedure, currently running at one SPID. Now, I found the query running too slow. In this Proc update/insert going on. If I kill the session, will what happen?
VAGALLA SURESH REDDY
  • 39
  • 10
1 2 3
…
24 25