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

learn more… | top users | synonyms (1)

2
votes
2answers
203 views

How to find queries that timed out in MongoDB?

Is it possible to find queries in the system.profile-Collection of a MongoDB-database that did not finish due to a timeout? I found some queries that ran longer than the time specified in $maxTimeMS. ...
2
votes
1answer
151 views

SQL:StmtStarting event originated from application

What does an SQL:StmtStarting event originated from application mean? Does it mean a raw SQL statement executed directly from the application? For example, in the case of an SP:StmtStarting, it means ...
2
votes
2answers
220 views

Overhead of DBMS_Profiler

If I use DBMS_Profiler to profile a long running (5 hour) PL/SQL script, how much longer should I expect the script to run with profiling? I realize this will be dependent on what the script is doing,...
2
votes
1answer
338 views

Sql profiler replay table

I have captured a trace in profiler and stored the trace to both a table and an xml for replay. I open the xml and replay the trace on the same server/database with modified stored procedures (I want ...
2
votes
1answer
328 views

SQL Server 2008 R2 DETA Error: Can not get minimal database information in allotted time

I have a 18,6 GB SQL Server 2008 R2 profiler trace file. Trace file recorded at tuning profile. When I submit this trace file to database engine tuning advisor I get this error: Error: Can not get ...
2
votes
1answer
308 views

Capturing sp_executesql statement in sql profiler

After catching some data in a SQL Profiler session, I can almost always see a second entry of type RPC:Completed for each query using a sp_executesql statement. I know that this is done to create re-...
2
votes
2answers
41 views

Meaning of “The database X needs to be upgraded” in ClearTrace

I'm trying out ClearTrace from http://www.scalesql.com/cleartrace/download.html , but it isn't very user friendly from my first impression. I have a database in SQL Server 2008 that I'm adding in the ...
2
votes
1answer
5k views

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? ...
2
votes
1answer
273 views

Is there a parser for Postgres' auto_explain to make it easier to read and understand?

We have a number of Postgres Functions that each call a number of other Postgres Functions. If you simply EXPLAIN ANALYSE a call like SELECT parent_function(), the output is minimal, since it doesn't ...
2
votes
1answer
176 views

Profiler: Only want to see Provider Errors

I'm replaying a trace in Profiler, and I'd like to only see the Provider Errors. Granted, there are ~30,000 of them but I'm not concerned at the moment about row update conflicts, foreign key or ...
2
votes
0answers
83 views

Output in SQL Profiler has results with Database ID as NULL

I ran profiler to filter out certain applications connecting an environment but the results has application for Database_id "NULL".. Am I missing anything ? Also another question , does all the ...
2
votes
0answers
82 views

Is it possible to trace queries that never complete with SQL Server 2008 R2?

Running SQL Server 2008 R2. We have some queries that typically take less than one second to complete, but, occasionally, they are taking longer than 30 seconds which causes a client timeout. ...
2
votes
0answers
192 views

This Extended Events session works on Dev but not on Pro. Why? [closed]

I do have the following Extended Event session on my Dev and Pro boxes: CREATE EVENT SESSION [sp_showplan] ON SERVER ADD EVENT sqlserver.query_post_execution_showplan(SET collect_database_name=(1) ...
2
votes
0answers
218 views

Collect information about currently running queries only when client timeout occurs

We would like to be able to collect information about all currently running queries when (and only when) a client timeout occurs in SQL Server 2008. I know I can collect information about the client ...
2
votes
0answers
143 views

Lock timeout on user tables traced back to system processes [closed]

I have a problem where users are reporting intermittent errors in an application that is using a SQL Server 2005 database. Nothing jumped out at me at first glance so I took a look at ...
2
votes
0answers
716 views

Is it normal for the SQL Server Profiler SP:StmtCompleted event to give 0 duration?

I'm trying to diagnose a slow running stored procedure in SQL Server. The procedure is quite long and complicated. I have been trying to figure out which statement is causing the issue. I have run a ...
1
vote
1answer
3k views

SQL Server 2008: High CPU historical queries

We have a SQL Server with 15 databases on it. This is used by many users in each database simultaneously. Recently we started getting high CPU alerts from this server. When the alert comes, I can ...
1
vote
2answers
423 views

How do I record SQL transactions with SQL Server Express

With a test migration from 2000 to 2008R2 Express, one function from the client application fails silently. I'd like to find out what SQL is running and why it fails. I think I would have attacked ...
1
vote
1answer
3k views

Diagnosing Blocking issues using Blocked Process report

I have an application that is going down as a result of timeouts. During these times we see a massive spike in response times from the database that holds ASP session state. In an effort to to ...
1
vote
2answers
656 views

SQL Server Profiler 2005 on remote SQL Server 2008 Express?

Is it able to trace remote SQL Server 2008 using SQL Profiler 2005? If yes, anyone knows what else should I do, if during loging in appeares this message "Unable to locate trace definition file for ...
1
vote
2answers
3k views

Using SQL Profiler on SSIS package

Is it possible to use SQL Server Profiler to trace a running SSIS package? I tried to do that, but all I can see in the trace is executing dp_sqlagent_... and the other internal commands! None of the ...
1
vote
1answer
102 views

sql 2005 - trace capturing all events

I am trying to capture all statements/SPs and RPCs (either they finish or fail) on a SQL 2005 server using SQL trace. Are the following events enough? Exceptions Stored Procedure RPC:Completed RPC:...
1
vote
1answer
44 views

get number of events per day from profiler trace

I am trying to do something that I thought would be simple but turns out it is not (for me). I have 5 days of profiler trace files that I have imported to a single table. I want to query the table and ...
1
vote
1answer
345 views

Running a sql server Trace of 1 GB using sqlcmd

I am load testing two sql server instances. I have a trace file from sql server 2000 database with a file size of little less than 1 GB. I am running this using the sqlcmd utility and it is been ...
1
vote
1answer
297 views

Measuring DB time of application using SQL Server Profiler

I have an application residing on the same host as a SQL Server database. There is a scenario in which this application is slow and due to co-existence of IIS and SQL Server, I cannot get which one ...
1
vote
1answer
119 views

Query Plan showing missing index warning on trivial statements

I have a Stored Procedure (ReportAdvancedUP) which runs fast (~1sec) in MSSMS but takes a long time (~1.8mins) via our Web Application. I am aware that this usually comes down to bad choice of ...
1
vote
1answer
57 views

What is the generally accepted method and tools for profiling MySQL queries?

Profiling database queries is difficult, and dependent on database technology. In MySQL, what is the usual (or, in deference to that, a great) process for profiling a query? For example: Run the ...
1
vote
1answer
305 views

Profiling parameters

I was trying to fine the parameters of a query I suspect to be causing unnecessary logical read and eventually captured it in profiler, however parameters @p3 and @p4 are not listed. Is anyone able ...
1
vote
1answer
2k views

To run SQL Server Profiler or to use the SQL Server Agent's Jobs function in SSMS or …?

I have a problem here - I wish to keep track of all transaction executed on the SQL Server but was wondering how should I proceed. If I were to use the SQL Server Profiler and configure it to store ...
1
vote
0answers
24 views

Profiling postgres with gprof: no data/gprof folder and 'no time accumulated'

I'm attempting to profile Postgres with gprof. A gmon.out file successfully gets created in both the data directory and in the working directory where I launched the client (pgbench) process from. ...
1
vote
0answers
57 views

Why is SQL Profiler showing empty for database name and database id?

I have some code that uses Entity Framework to call a stored procedure in SQL Server. If I run SQL Profiler and filter by the database it is calling, I can see that the profiler correctly shows the ...
1
vote
0answers
51 views

SQL Server Profiler

I had run a SQL trace on SQL server 2008 r2 and had originally saved it to the table format. This table now resides in the database and I was wondering could I export the contents of the table to a ...
1
vote
0answers
49 views

Compare Traces with RML Utilities

I am new to RML and am trying to use it to capture a trace, replay it on another server and then compare the two. I have managed to capture a trace using the server side script that comes with it and ...
1
vote
2answers
61 views

mysql copying to tmp table duration

I have a web site which started to have performance issues because of a mysql query which is executed for each request. I have the following table structure. Post table (125000+ records) id: ...
1
vote
0answers
164 views

Significant difference between duration for querys in SHOW PROFILE and SHOW PROFILES?

I have use mysql profiler to optimize an opencart query which takes more than 10 seconds to executes. mysql> SHOW PROFILES; +----------+-------------+-----------------------------------------------...
1
vote
0answers
411 views

Disable the SQL profiler to be executed on particular query running from ASP.NET application

I have set of queries executing from an ASP.NET application and I don't want those SQL queries to be traced by SQL Server Profiler. How can I do it?
1
vote
0answers
117 views

can this mysql query be optimized further?

I have this query select counterparty_id, max(id) max_id from client_administrations where counterparty_type = 1 and effective_on <= '2013-10-22' group by counterparty_id When I ...
1
vote
0answers
295 views

What filter to use in SQL Profiler for socket write error

Can someone please help with intitial SQL Profiler filter setup to narrow down the settings and reduce the noise when I'm trying to find out the reason behind socket write error ? Basically the ...
1
vote
0answers
358 views

Linked server query in profiler

I was profiling a DB for queries against it but have noticed that when a table in the DB is accessed through a linked server this does not show in profiler. Can anyone advise on why this is or what ...
0
votes
3answers
4k views

Duration Field in Profiler

I would like to monitor the script which takes more than 25 Sec. When i use filter i am not able to see the duration taken by the script. How can we get the time taken to execute the query. My ...
0
votes
2answers
4k views

Performance Benchmark - MySQL vs PostgreSQL [closed]

this is my first question here in DBA. I wish to do a performance comparison between MySQL and PostgreSQL using same database on the basis of total time taken to parse + execute + send result back ...
0
votes
1answer
13k views

Identify faulty sub-query (subquery returned more than 1 value)

I am trying to resolve an issue with a query that fails with this error: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when ...
0
votes
1answer
478 views

How to restrict SQL server profiler to show my symmetric key password while executing query from C# code?

I used symmetric encryption to encrypt sensitive data in my application. I don't want anyone see my password for decrypting the data. But system admin can able to see symmetric password in SQL Server ...
0
votes
1answer
1k views

How to get SQL Profiler record the user which login to your web application but the SQL username and password is specify in the web.config file?

I have a web application that will retrieve data from a database. I have specify in the web application web.config file to have the username sa and password password. Data Source=myServerAddress;...
0
votes
1answer
243 views

Procedure showing different duration / reads in Profiler vs. SSMS

I have a database which is getting a lot of calls to the following procedure: exec dbo.SM_SP_MAILEVENTNAMES 167260 In Profiler using the TSQL_Duration trace these calls show up as: EventClass: RPC:...
0
votes
1answer
45 views

Apply profiler template to saved log

I need to check for deadlocks in my customer's system. He provided me with unfiltered logs. Can I filter them after running the trace somehow? (I don't have direct access to his server) It seems ...
0
votes
1answer
462 views

How to profile a particularly slow or inefficient query

I'm currently writing queries for my database but this is the first time I've dealt with large data sets of any sort, and I'm now finding that I need to improve the performance of my queries. ...
0
votes
2answers
237 views

Server side trace to database

How can I set up a server side trace that dumps to a database instead of a trace file? I set-up and tested a trace configuration I want with Sql Server Profiler that dumps only needed info straight ...
0
votes
1answer
203 views

Query Processing at backend (I/O on disk)

I have a table with 100k rows created on PostgreSQL 9.3 create table demo_bbb ( id numeric NOT NULL, code_bbb character varying, column_02 character varying, column_03 character varying, ...
0
votes
1answer
59 views

MySQL: What is SQL profiler, does it different for MySQL?

Whenever SQL profiling comes in mind, focus goes to two below sections: GUI tools like - MONyog, Neor Profile SQL set profiling =1; Execute Query; show profiles; show profile; I am really confuse ...