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

learn more… | top users | synonyms (1)

0
votes
1answer
64 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 ...
0
votes
1answer
1k views

SQL Server 2008 R2 SQL Server Profiler and “exec sp_reset_connection”

Yesterday i ran the "SQL Server Profiler" tool and outputted the data to a table, now when i look in it i find many "exec sp_reset_connection" rows and thats expected with our data access layer! But ...
0
votes
1answer
177 views

sql 2000 trace : sp_releaseschemalock

For a SQL 2000 server, is it bad to see too many exec sp_releaseschemalock 1 events in a SQL trace file?
0
votes
1answer
51 views

SQL queries text log analyzing

I have a text log file (log4net) with many SQL queries in parametrized format and with stacktraces. It also contains output from other loggers which should be ignored. An example of one log entry: ...
0
votes
0answers
9 views

Auditing Application calls

We have an old central DB which we need to upgrade to a new solution. Given it's age and position many applications call it.. and due to staff turnover not all are known or documented. It's also ...
0
votes
0answers
42 views

Which column to trust about the event order in a profiler result?

Hi I recorded some events using the SQL profiler and I want to work out the exact order of what happened first. But I am having trouble in this basic task, because what ORDER BY EventSequence showed ...
0
votes
0answers
10 views

Workload Capture

Hopefully this is a straight forward question. But if I want to capture a workload then all I need to capture are: RPC:Completed SQL:BatchCompleted I don't need to capture SP:StmtCompleted do I, ...
0
votes
0answers
20 views

How to find out user activity for calls made from an application server?

I have to log user activity on the SQL server for the calls made from SAP application server, the problem is the Application server does not send any User information along with each call and uses a ...
0
votes
0answers
49 views

Is there any way to know which SP executed from “exec sp_execute” in SQL profiler?

I have traced a SQL profiler and got some process tracings. I got one command in which the stored procedure is executing by the command exec sp_execute Can I trace that which stored procedure had ...
0
votes
1answer
26 views

Where are sql profiler trace files stored?

Can't seem to find an answer to this.. During a recent sql profile I noticed C:\ was rapidly filling up. Does anyone know exactly where these files are stored? is it part of SSMS?
0
votes
1answer
65 views

How to change MongoDB slowOpThresholdMs in mongo shell

I need to decrease the slowms trash hold to 50, can't find the way of doing that without restarting the mongod process.
0
votes
0answers
50 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 ...
0
votes
0answers
98 views

How to analyze incoming DML in SQL Server 2005?

I have database and specifically one table that is used for batch data transfer from another organization. With each run the table is truncated and rows are re-inserted. I want to handle that process ...
0
votes
0answers
132 views

SQL Server 2012 Profiler - ShowPlan XML Batch ID

I have an application that makes RPC calls for a single procedure, most calls run in a few miliseconds. Occasionally the call takes 5-7 seconds. I'm trying to catch an execution plan for one of the ...
0
votes
0answers
62 views

Email alerts and Server Side Tracing

This question is in regards to SQL 2005 and email alerts on long running queries. Does this sound like the best approach (with the least impact to the server) to receiving alerts to long running ...
0
votes
1answer
184 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 ...
0
votes
1answer
207 views

Does Express Profiler have a major effect on performance of SQL Server Express

I'm wondering does running Express Profiler against an SQL Express Server have a major impact on performance. The versions of SQL Express I'm looking to run against are on 2008 and 2013. This is the ...