Questions tagged [profiler]

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

Filter by
Sorted by
Tagged with
0 votes
0 answers
43 views

SQL Default trace not deleting files above the max no of trace files

We have a Sql server 2016 Sp2. Noticed the trace file path D:\Data\MSSQL13.MSSQLSERVER\MSSQL\Log\log_298.trc is getting filled with trace files and the files are more than 2 months old. To my ...
SQL_NoExpert's user avatar
  • 1,021
3 votes
1 answer
153 views

Trace database query

I need an advice. I would need to trace one particular procedure in SQL Server. It happens to me that one procedure ends up with a timeout and I need to find out which select, insert or update this ...
Jan Kůst's user avatar
1 vote
0 answers
160 views

What is the object involved in an Object Lock in SQL Server Profiler's Deadlock graph? [closed]

In searching documentation online, I have found that there can be row, page, or table locks. However, I ran a SQL Server Profiler trace and noticed both a Page Lock and an Object lock. I can easily ...
Paradox's user avatar
  • 121
0 votes
0 answers
81 views

How to grant impersonate in SQL Server on AWS RDS - For Profiler Replay

I'm trying to use SQL Server Profiler to Replay a Trace. But when it tried to impersonate the users/logins, it gives this error: Failed to set proper user name ('application_login') for the ...
Iridescent's user avatar
0 votes
0 answers
32 views

Monitoring MS Dynamics 365 with Extended Events

I know that SQL Server and Azure SQL support "Extended Events" as a means of profiling execution. I also know that MS Dynamics 365 is built with Azure SQL. What I'd like to accomplish is ...
Brent Arias's user avatar
1 vote
0 answers
209 views

Sql profiler - result in profiler : "Audit Login" and immediately after "Audit Logout" without running the query

I have a service running on an Azure kubernetes (AKS) that is connecting to a DB running on a Virtual Machine (VM) on Azure. There is a failure to run the service. The result of SQL Profiler is: ...
dexon's user avatar
  • 11
8 votes
1 answer
398 views

What can I add to an Extended Event to return correct row_counts?

I'm running an Extended Event session in SQL Server 2017 that's only recording module_end events for a specific database. The reason for this trace is two-fold: I'm wanting to see the frequency (or ...
Siyual's user avatar
  • 181
0 votes
0 answers
297 views

Alter Trace (SQL Server Profiler) security risks?

SQL Server database -- a read only node specifically (not exactly sure how that works). Our database keeps crashing due to memory issues - various error messages indicate this. It's hard to tell if it'...
user45867's user avatar
  • 1,631
0 votes
1 answer
137 views

What is the use of trace captured via Profiler?

I am learning about capturing trace via profiler. I understand that the purpose of capturing trace via profiler is to log events happening on the sql server without impacting performance, because ...
variable's user avatar
  • 3,360
4 votes
1 answer
818 views

Extended events capture all calls by login/user and sql text containing a value

I'm using below extended events session to capture the data that contains a value 9999 by login xEventsTest. But I don't see any data captured with the filters added, but I could see this call when no ...
Siva Dasari's user avatar
2 votes
1 answer
1k views

SQL Server Profiler - Client unable to establish connection

Spanking brand-new installations of: Visual Studio 2022 Community (VS) SQL Server 2019 Dev (SQL) SQL Server Management Studio v18.10 (SSMS) There are no other Visual Studio or SQL Server instances ...
David Rogers's user avatar
-1 votes
1 answer
307 views

Best method for isolating long running locks?

On a SaaS production database with 7 users (5 human, 2 backend) many are experiencing SQL cliënt timeouts at 30 seconds, our standard .Net CommandTimeout. This SQL Server instance (out of our ten) ...
Nick's user avatar
  • 59
0 votes
1 answer
193 views

SQL Profiler filter trace that is currently recording

As title, If I forgot to set the filter before run. Is there a way to filter column like application name in the middle of the recording? I know if I save the result to trace file and reopen that file ...
Circle Hsiao's user avatar
0 votes
1 answer
186 views

SQL Profiler shows multiple calls for one TVF

There is one table valued function in SQL Profiler I have noticed which seems to "call itself multiple times". The definition doesnt do any odd thing either, it is a query with few JOINs and ...
Jozef Podlecki's user avatar
1 vote
1 answer
2k views

SQL profiler not showing incoming parameters of store procedure

My Task When user updates some values on the front end UI of an application, I want to know which SQL table/fields are updated, which SQL statements were executed, etc. My method Using SQL profiler, I ...
ppau2004's user avatar
1 vote
2 answers
385 views

Server side tracing for SQL Server Analysis Services

We are looking to continuously run server side trace on Analysis Services and record its output in a table in database in the Database Services. There are tons of articles showing server side trace ...
soccer7's user avatar
  • 159
0 votes
1 answer
422 views

What would cause this SQL Server deadlock?

I have a node.js script that is attempting to geocode records in a table. The script selects 100 records at a time that do not have lat/log data, geocodes them using a third party api and writes the ...
Abe Miessler's user avatar
0 votes
1 answer
92 views

Map-Reduce on `system.profile` collection

I have a simple collection posts with a few documents in it. I have set the profiling level to 2 allowing for profiling information to be collected into another collection system.profile. My goal is ...
harry_k's user avatar
0 votes
1 answer
373 views

SQL profiler how to filter with EventClass column

I need to filter Profiler events by EventClass like RPC:completed, but I cannot find any filter for EventClass. Any idea how to do that?
ErikAbb's user avatar
0 votes
2 answers
129 views

How to profile MySQL during a period of time

I want to know during the execution of sysbench --time=100 ..., the bottleneck (function) of MySQL. So I want to profile MySQL when executing sysbench --time=100 .... I know by set profiling = 1;, I ...
Tim He's user avatar
  • 233
0 votes
1 answer
386 views

Heavy performance drop on Progress query, looks like based on string character inside table

I'm launching following query on a Rel 11.6 Progress database: FIND FIRST Table1 WHERE Table1.Field1 = 1 AND Table1.Field2 >= 2 AND TRUE ...
Dominique's user avatar
  • 523
0 votes
2 answers
377 views

Why does SQL Server Profiler show some completed statements in pairs (twice)?

In SQL Server profiler I am seeing pairs of completed statements. A pair is shown below. The TextData (query) is exactly the same. The SPIDs are different (86 & 88). The # of reads and writes are ...
Tony_Henrich's user avatar
1 vote
2 answers
60 views

MS SQL login periodically doesn't work

Instance info: Microsoft SQL Server 2017 (RTM-CU13) Standard Edition (64-bit) on Windows Server 2019 Datacenter Location: AWS A Java app on another AWS server logs into the SQL instance using a local ...
Alonzo Hess's user avatar
0 votes
1 answer
629 views

How to capture execution plan from sql profiler for filtered queries only

Using sql profiler, we trace all slow queries (filter on duration/reads) to see where we can optimise. Events used: RPC:Completed SQL:BatchCompleted Filter on Duration. If I add the event ShowPlan ...
MichaelD's user avatar
  • 553
1 vote
0 answers
447 views

Why do select Queries create additional queries to sys tables

I have an external application querying our database with an SELECT statement via Linked Server. When I check Queries with SQL Server Profiler - I see that these queries are accompanied by an enormous ...
räph's user avatar
  • 111
0 votes
1 answer
866 views

How to read the actual value of @P0 in SQL server profiler

When I use SQL server profiler to trace the SQL statement flow using SP:StmtCompleted, I can only read the variables as @P0, @P1, etc. like: insert into CaseFollowup (createDate, duration) values (@P0,...
Stephen Chu's user avatar
2 votes
1 answer
5k views

Postgres equivalent of SQL Server profiler

In SQL Server when we have applications for which we do not have source code we could use the SQL Server profiler to analyze which queries or procedures are called when we do something in the ...
stefam mierz's user avatar
3 votes
1 answer
345 views

MSSQL Server XE column client_connection_id accessible through system view/table for auditing?

In our .NET application we create a SqlConnection to talk to the database. After the connection is opened, we get the ClientConnectionId, a GUID. Within the extended events I can manage to trace the ...
rogaa's user avatar
  • 131
0 votes
1 answer
726 views

Unable to trace "Arithmetic overflow error converting numeric to data type numeric" error in profiler

I have a .net application. Its trying to create tables, views and insert/update data into many tables. while application running i got an error. I tried to trace the query in SQL Profiler, but i ...
B.Muthamizhselvi's user avatar
2 votes
1 answer
390 views

Some timeout in query store but get all SP:Starting and SP:Completed in profiler

I have a report SP running. The user complaint report timeout sometimes. And I do get some canceled execution plan in my query store. But in my profiler tracing file, every SP:Starting has its SP:...
DBALUKE HUANG's user avatar
4 votes
2 answers
10k views

How can I use SQL Profiler to capture a single stored procedure

Using SQL Server SQL Profiler, which configuration can be used to monitor a single stored procedure? I'd like to capture all EXEC sprocName to include the parameter list. I'd like to capture this ...
Adam's user avatar
  • 193
3 votes
1 answer
684 views

Is Network I/O included in the timings for "RPC complete" seen in SQL Profiler?

When watching results in SQL Profiler, does the RPC Complete include time to send results to the client? Or is it just the time the server spent gathering the records? The reason I'm asking is I'm ...
Tim Coker's user avatar
  • 133
6 votes
1 answer
517 views

Mysterious procedure calls without parameters - but no exceptions generated

I've been tracing a handful of stored procedures with EventClass RPC:Completed that are intermittently called from .Net SqlClient Data Provider without required parameters - just "exec SprocName". ...
Chris's user avatar
  • 63
1 vote
1 answer
375 views

Would SQL Server Profile show triggers or other code which run as a side-effect of the query I'm profiling?

I've been using profiler to test a massive script I'm running in order to check for unintended side effects, e.g. triggers that I don't know about running because I've updated data in a certain table. ...
Emily Graham's user avatar
2 votes
1 answer
113 views

How do I keep a SQL Server Profiler trace from jumping to the bottom entry?

When monitoring a trace in SQL Server Profiler, is there a way to prevent it from jumping to the most recent event without pausing the trace? I'm often trying to scroll up and read descriptions of ...
Scotch's user avatar
  • 148
2 votes
0 answers
462 views

What the "Reads" Column in Profiler exactly mean?

Can any one explain, whats the "Reads" column in SQL Server Profiler exactly mean ? Why sum of logical reads get by SET STATISTICS IO ON are different from number of reads in SQL Profiler? Which ...
Ashraf's user avatar
  • 63
1 vote
1 answer
260 views

Issue with a "weird" deadlock in SQL server

I'm working with a database that has the characteristics that follow: GO /****** Object: Table [dbo].[ADS_EVENT_TYPE_STR] Script Date: 1/17/2019 8:20:36 PM ******/ SET ANSI_NULLS ON GO SET ...
federico's user avatar
-1 votes
1 answer
633 views

Is SQL Server Profiler different from SQL Trace?

In this source it is written something like this I want to know what is SQL Trace? Does it refer here to Traces inside SQL Profiler or this is a different tool. I try to search it but can't find any ...
igelr's user avatar
  • 2,120
1 vote
0 answers
119 views

Querying a synonym (for a table using linked server) gives no data in return

I have a function which run in an application at a server. This server have a ODBC connection (user DSN) to the SQL server which is set to use windows authentication. The function is supposed to ...
user2952646's user avatar
0 votes
0 answers
265 views

SQL Server Profiler shows a StartTime greater than EndTime

I'm using SQL Server Profiler to check some long run query. Somehow I see some entries in SQL Server profiler show StartTime is greater than the EndTime, and the Duration value is obviously overflow. ...
C Y's user avatar
  • 9
1 vote
1 answer
465 views

How to handle process blocking in SQL Server Profiler?

I have run a SQL Profiler Trace which detected a process blocking. Now what should i do, if it always brings the same blocking event, each time duration is getting bigger. I have only one transaction ...
igelr's user avatar
  • 2,120
1 vote
1 answer
133 views

What is aggregation in SQL Profiler?

I want to know what is an aggregated result of an event and what to do in order to get aggregated results? Thanks for your time!
igelr's user avatar
  • 2,120
1 vote
1 answer
1k views

What does 'exclude rows that do not contain values' checkbox do in SQL Profiler?

I want to filter a trace and wonder what does 'exclude rows that do not contain values' checkbox exactly do? Is it to filter all the data columns that are not selected in any event class? Thanks.
igelr's user avatar
  • 2,120
2 votes
1 answer
441 views

Can SQL Profiler filter data columns only for one event?

I am using SQL Profiler in MS SQL Server. I can filter data columns by clicking 'Column Filters'. But this filter applies to all events. I want to filter login only for 2 events. Like, audit login and ...
igelr's user avatar
  • 2,120
0 votes
1 answer
2k views

Why does SQL Server Profiler crash when its run against a DB machine from a client machine?

I have: SQL Server 2014 (default instance )is on a Win Server 2012 machine. SQL Server Management Studio (v17.7) is on a Win 7 machine. Both machines are on the same domain. I'm logged into the Win 7 ...
VA systems engineer's user avatar
2 votes
2 answers
268 views

Do I need to keep SQL Server Profiler interface open?

I'm running SQL Server Profiler on SQL Server 2008R2. I opened Profiler, gave it the required settings (including a stop time 24 hours from now), and then left. Profiler was running from my desktop ...
LearnByReading's user avatar
0 votes
2 answers
653 views

SQL Server Profiler - Disable auto scroll by default

Is there a way for new traces to start with auto scrolling disabled? This is the very first thing I do every time I start a trace and I'd like to optimize my workflow, especially since I run multiple ...
Elaskanator's user avatar
0 votes
1 answer
176 views

how to edit a sql server profile template using a text editor like notepad or ssms?

I am running a trace where I need to filter the behaviour or about 50 users, and some 50 database objects. I would like, for this purpose to create a sql server profile template and later edit it to ...
Marcello Miorelli's user avatar
0 votes
1 answer
1k views

SQL Server Profiler Exception tracing - Error procedure and line number omitted

Is there a trace configuration or setting that will enable the profiler to output ERROR_PROCEDURE() and ERROR_LINE() information that is always available when writing manual error handling in CATCH ...
Elaskanator's user avatar
0 votes
2 answers
66 views

Change of index key columns order affects performance

I have the following table in my database: create table [dbo].[tb_StatusLog]( [RequestID] [int] not null, [statusID] [int] not null, [startTime] [datetime] not null, [endTime] [datetime] null, ) ...
Yevgeni Grinberg's user avatar