Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [profiler]

A tool that reads and analyses event trace information from a database management system.

A profiling tool (profiler) reads event trace information that can be recorded by the database management system. These events can include queries being executed, particular query processing actions such as stored procedure executions or table scans or connection and session events. The profiling tool allows these to be examined and analysed.

Depending on the individual DBMS platform, various methods of recording trace information may be available - the DBMS can write out trace files, record the profiling information in a table or communicate with a client over interprocess communication or network links.

  • This link describes the process in the SQL Server profiler.

  • Tracing in Oracle is provided by the Oracle SQL Trace facility; the tkprof utility is used to examine trace files.

197 questions
49
votes
4 answers

Is there a tool like Microsoft's "SQL Server Profiler" for MySQL?

While developing on MySQL I really miss being able to fire up a profiler. I find SQLyog is a good enough replacement for Query Analyzer but have not found a tool that works like SQL profiler. For the MySQL folk who have not seen Microsoft's SQL…
Sam Saffron
  • 1,114
  • 1
  • 10
  • 12
29
votes
4 answers

Using SQL Profiler on a database that's in production

As a developer, I use SQL Profiler quite often. It's a good debugging tool, both to track what my code is doing and to analyse performance problems. But I've always used it on my development environment, and in a very controlled way. Start my…
Andrew Shepherd
  • 533
  • 1
  • 5
  • 11
29
votes
2 answers

Empty blocking process in blocked process report

I'm collecting blocked process reports using Extended Events, and for some reason in some reports the blocking-process node is empty. This is the full xml:
Tom V
  • 15,752
  • 7
  • 66
  • 87
26
votes
5 answers

Identifying Unused Stored Procedures

This next year, I am helping an effort to clean several SQL Server environments. We have about 10,000 stored procedures and estimate that only about 1000 of them are used on a regular basis, and another 200 or so are used on a rare occasion,…
Question3CPO
  • 561
  • 1
  • 8
  • 13
22
votes
1 answer

When should extended events be used instead of SQL Profiler/perfmon?

The extended events seem like a better technology and less stress on the server, but the SQL Profiler/perfmon has better tooling. Also the extended events seem to have a steeper learning curve. In which context should each be used? Is it worth…
Michael Hedgpeth
  • 1,361
  • 4
  • 15
  • 21
20
votes
5 answers

Download SQL Server Profiler for SQL Server Management Studio

How can I profile a SQL Server 2008 database to see code that's being executed on a particular database? I remember using the SQL Server profiler, but I don't see it in SQL Server Management Studio after downloading SQL Server 2008 R2 Express. …
JustBeingHelpful
  • 2,116
  • 18
  • 45
  • 61
17
votes
3 answers

MySQL profile on query "Creating Sort Index" using 75% of the total time

We are trying to figure how to optimize a query (taking around 100ms), and running profile we see Creating Sort Index using 75% of the total time. First, what exactly effects creating the sort index? Is it disk/io? Second, is there any optimization…
Justin
  • 449
  • 3
  • 7
  • 11
14
votes
7 answers

How can I profile SQL Azure?

I am writing a web site that uses SQL Azure heavily. However, it is painfully slow. Is there an easy way to profile the live SQL Azure instance?
user380719
  • 243
  • 2
  • 5
13
votes
1 answer

Is it possible to record incoming parameter values in a procedure call while tracing in SQL Server Profiler?

Using SQL Server Profiler (I'm on SQL Server 2012), I'm trying to generate a useful trace that shows the parameter values, not just the SQL with variable names. The stored procedure walks through a gross amount of Inventory data to generate some…
Warren P
  • 1,087
  • 2
  • 14
  • 24
13
votes
5 answers

Does SQL profiler affect server performance?

I am facing a problem where the sql server 2008 fails for some high load. I need to find that load case and need to optimize the code so that it can handle the load. I have found on the internet that SQL profiler can be used to track the database…
V K
11
votes
3 answers

SQL Profiler tutorials for newbie

The MSDN documentation tough to understand. Are there any online tutorials available to learn SQL Profiler? If possible, videos or simple blog posts would be preferred.
Webber
  • 695
  • 1
  • 6
  • 8
9
votes
1 answer

What does "*password------------" mean in a profile deadlock report?

In SQL Server 2008 R2, I got several deadlock reports that have "*password------------" in the input buffer. It looks like an attack but in that case I don't know the reason or the kind of attack. (the log was generated by an expert DBA how has lot…
Diego Jancic
  • 451
  • 5
  • 15
9
votes
3 answers

How can I change the target server type for a trace template?

I've got a .tdf SQL Server Profiler trace template someone wants me to run but the template is targeting SS 2008 R2. While my SSMS is 2008 R2 the server I need to trace is SS 2005. When attempting to trace the server the server type is locked…
Zelda
  • 2,103
  • 6
  • 28
  • 38
9
votes
1 answer

SQL Server Profiler: why the RPC Starting event does use an different decimal separator from SP Starting?

Trying to diagnose an problem, I've ran into that inconsistency. In SQL Server Profiler, the RPC Starting event uses the regional settings to write real numbers (example: in Portuguese(Brazil) 14.5 will be expressed as 14,5). Normally that's not a…
Fabricio Araujo
  • 957
  • 7
  • 14
9
votes
2 answers

SQL Server Profiler - How to filter trace to only display inserts, updates and deletes to one database?

How do I limit a SQL Server Profiler to trace only inserts, updates and deletes to a specific database?
Aki T
  • 213
  • 1
  • 2
  • 4
1
2 3
…
13 14