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

learn more… | top users | synonyms

2
votes
1answer
27 views

One SQL different Results by using SQLOLEDB or MSDASQL

I'm using VB6 with SQLOLEDB and MSDASQL. By switching the Provider i've notice, that i'm getting different Results with one query. My Query Checks some Server Settings and Execute Backup SQL 1 or ...
4
votes
4answers
2k views

Cannot open SQL Server profiler file

Scenario Debugging a failed transaction, I asked the DBA to run a trace on SQL Server. Eventually he send me a .trc file. Issue I use the fn_tracegettable() function to access the trace: select * ...
6
votes
1answer
114 views

How to find the stored procedure which executed an event?

I have a problem where a certain stored procedure disappears occasionally and I need to find out which script deletes it. I found this piece of code which gives the events related to the deletion of ...
2
votes
1answer
63 views

Stuck in “query end” status every 5 minutes

I'm sick of seeing data in the slow query log, so I decided to check out what the fuss was all about. An UPDATE query that is running up to tens of times per second is sometimes really slow. Here is ...
0
votes
0answers
39 views

SQL Server Profiler performance

I was wondering if I set a filter for just a particular user does it limit the amount of resource consumption used by sql server and does using a filter(depending on the filter) limit the performance ...
3
votes
2answers
610 views

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 ...
2
votes
2answers
34 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. ...
4
votes
2answers
439 views

Is an SQL Server trace 'considered harmful' in production?

Context: Careful DBAs We've been bought out a few times and our latest overlords have DBAs who keep carefully guard their production database servers. Overall this is good. However, we have run ...
9
votes
6answers
4k views

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?
0
votes
1answer
1k 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? ...
0
votes
0answers
16 views

Replay Trace Results Slower On Better Server

I have captured a trace and replayed it using SQL Profiler on my new server capturing another trace at the same time. I am using DBSophic Qure Profiler to compare the traces as it compares each query ...
7
votes
7answers
50k views

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 ...
1
vote
0answers
24 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 ...
2
votes
2answers
152 views

Blocked Process Report SQL Server 31 hour duration

I have an application (.NET EF 6 ) which is getting timeouts when submitting/reading data from the database. Whilst trying to diagnose the problem I used Blocked Process Reports from SQL server ...
2
votes
2answers
21 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
128 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 ...
5
votes
3answers
2k views

Logging query text without Profiler

I'm in the process of porting an old, semi-broken ASP.NET/SQL Server application to PHP/PostgreSQL. Among the torments^H^H^H^H^H^H^H^Hchallenges I'm faced with is that the reporting is done by a ...
6
votes
1answer
103 views

Capture and Replay workload

We have a new server which we are migrating too and want to see the potential benefits of the hardware. So the idea is that we capture a workload and replay this against our new box. My question is ...
0
votes
1answer
56 views

Stored Procedure Resultset Row Count and Resultset Size in Bytes/KBs

Is there any way to get total row count and size of result-set generated by a stored procedure execution? @@ROWCOUNT is a good option if its already added in each stored procedure but I just want ...
1
vote
2answers
30 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: ...
2
votes
0answers
51 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 ...
1
vote
1answer
239 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 ...
2
votes
0answers
54 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. ...
3
votes
3answers
1k views

SQL Profiler - Insert values?

I setup an SQL profiler to run, but I am not seeing any values for updates/inserts. Is there a way to see them? All I see is stuff like this: insert into some_tbl(id, col1, col2, col3) values ( @P0 ...
2
votes
2answers
6k views

What does 'system lock' mean in mysql profiling a LOAD DATA INFILE statement?

2M rows inserted using LOAD DATA INFILE to innodb takes 7.5min, and profiling shows 99% of that time is in "System lock". Does this tell me anything useful? mysql> set profiling=1; ...
0
votes
0answers
71 views

DBM_INIT distributed transaction rollback in profiler

SQL Server 2008 R2. WebSphere 7.x Windows 2008 server. Our application is JEE in WebSphere 7.x, and so uses Microsoft JDBC I believe 4.0 to connect to the db server. During one of our batch jobs, ...
2
votes
0answers
138 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) ...
3
votes
1answer
61 views

meaning of ## in SQL Server Profiler trace data

I'm running a trace using the SQL Server Profiler. The trace data contains the following lines: WHERE CAST(LEFT(pc.Time_stamp,11) AS DATETIME >= ## AND CAST(LEFT(pc.Time_stamp, 11) AS DATETIME) ...
3
votes
2answers
121 views

SQL profiler running on prod

we have got performance experts analyzing our SQL server by running profiler traces in production. The profiler trace creates 20 GB of trace files everyday since 2 weeks. Is this a correct approach? ...
6
votes
2answers
2k views

SQL Profiler - Scripting a trace with HostName filter

I have a stock of scripted trace definitions that I use for different levels of diagnostics, none of which filter by HostName. I needed to filter traffic by host today so: Fired up Profiler Created ...
0
votes
2answers
3k 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
0answers
102 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
1answer
101 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 ...
0
votes
1answer
126 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: ...
0
votes
1answer
5k 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 ...
1
vote
1answer
166 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 ...
0
votes
1answer
140 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, ...
2
votes
1answer
209 views

Perfmon and SQL Server Clustering

I'll be going onsite to run some performance tests for a client. They have a Windows Failover Cluster, which has a clustered instance of SQL Server. Let's assume for this post that my client's ...
4
votes
1answer
162 views

Find reason long running stored proc SQL Server

I have a stored proc which is called every 2.5 seconds by a program, 24-7. This proc normally runs under the 10 milliseconds. A few times a day (3 -5 times) it takes around 42953 milliseconds to run ...
4
votes
2answers
1k views

Slow SSRS Report in production

I have an SSRS report which gets its data by firing a series of stored procedures. Now the report is timing out big time when run in production, yet when I pull down the prod database and restore to ...
3
votes
5answers
4k views

User Windows login name has been changed in AD yet session in SQL 2008 Profiler shows the old Windows login name

Background: a user had her name changed in Active Directory from Domain\oldname to Domain\newname and successfully logged into the network with Domain\newname and yet Domain\oldname appears in ...
2
votes
1answer
618 views

Profiling and debugging “Incorrect syntax was encountered while parsing :setvar.”

I have the following script using SQLCMD setvar, but I receive an error when I parse the script: :setvar dbname "PROD" :setvar backuppath = "e:\sql\restore\PROD.bak" USE [master]; GO -- backup the ...
0
votes
1answer
46 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 ...
2
votes
2answers
616 views

SQL Profiler Shows Update (EventClass) with No Errors, But Data in Table is Not Changed

I am trying to debug a web app that uses a database and I need a little help. The problem is that part of the code throws a timeout error. I started using SQL Server Profiler to check the ...
12
votes
1answer
3k views

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 ...
3
votes
1answer
123 views

Maxdop in Profiler

Say I run a server side trace against a SQL Server 2008 R2 instance, which has Maxdop = 1 in place, then I run the trace through readtrace.exe to get RML files for replay. Does the replay preserve ...
1
vote
1answer
35 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 ...
6
votes
1answer
721 views

SQL Server: How can I read server-side traces with limited permission?

I am trying to set up a trace on a remote server. I am able to generate the trace, set filters, and even stop and delete the trace through sql server without an issue. However, the file created with ...
15
votes
4answers
5k views

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 ...
1
vote
0answers
111 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; ...