Questions tagged [profiler]
A tool that reads and analyses event trace information from a database management system.
176
questions
-1
votes
0answers
16 views
SQL 2000 Trace Querys [duplicate]
I'm trying to capture all querys and stored procedure in real time (or log file) for SQL 2000, i try with SQL Pofiler but it is not possible with such an old version.
-2
votes
1answer
49 views
SQL Profiler for SQL 2000 [closed]
I need to use SQL Profiler for a Database running on SQL 2000. I currently use SQL Profiler 18 but when I attempt to connect I receive this error:
Client unable to establish connection
SQL Server ...
0
votes
1answer
19 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 ...
3
votes
1answer
55 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 ...
0
votes
1answer
111 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 ...
1
vote
1answer
68 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:...
1
vote
2answers
1k 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 ...
3
votes
1answer
182 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 ...
6
votes
1answer
487 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".
...
1
vote
1answer
25 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.
...
2
votes
1answer
37 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 ...
2
votes
0answers
149 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 ...
1
vote
1answer
106 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 ...
-1
votes
1answer
196 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 ...
1
vote
0answers
18 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 ...
0
votes
0answers
146 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.
...
1
vote
1answer
197 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 ...
1
vote
1answer
67 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!
0
votes
1answer
443 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.
2
votes
1answer
294 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 ...
0
votes
1answer
573 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 ...
2
votes
2answers
46 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 ...
0
votes
2answers
278 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 ...
0
votes
1answer
86 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 ...
0
votes
1answer
558 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 ...
0
votes
2answers
51 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,
)
...
2
votes
1answer
380 views
SQL Profiler plus Include Actual Execution Plan
Is there any option to show "Include Actual Execution Plan" plus query cost and recommended indexes in SQL Profiler?
I see Showplan XML, but it shows only the execution plan without recommended ...
0
votes
1answer
69 views
Benchmarking procedures or Upgrade tests to be done after upgrading to SQL Server 2016 from SQL Server 2012
I need suggestions on how to benchmark performance or create baselines to test the upgrade from SQL Server 2012 to SQL Server 2016 (both standard edition), also if any post upgrade tasks that needs to ...
2
votes
1answer
195 views
SQL PROFILER Replay statistics event interpretation
I tried capturing a replayable trace on a SQL Server 2012 production environment and then replay it against a SQL 2016 test environment.
After doing so , I got the following results :
Can anyone ...
0
votes
0answers
41 views
SQL Server Profiler showing an update with duration 0ms, but then 5 second delay
I'm not even sure how to phrase this question - apologies if it falls outside the realm of this site... I guess my main question is: What to look for when an update seems quick, but the overall ...
0
votes
1answer
290 views
MariaDB query time in profile not match
From a MariaDB 10.1 database with the profile enabled.
After making some test with an example query, why the time reports from the query doesn't match the duration time that the profiles report?
I ...
6
votes
0answers
363 views
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 ...
1
vote
2answers
2k views
Capture live stored procedure calls (as per Query Profiler) in SQL Azure
TL;DR - Is it possible to capture live procedure calls (with parameter names/values) in SQL Azure, to replicate the output of SQL Profiler illustrated below - or - is there a better way to achieve ...
2
votes
1answer
2k views
Sqlserver exec sp_execute to simple query? [closed]
I use sqlserver 2012 profile to watch all query that run on my db.
I saw only exec sp_execute 2,55,88 or exec sp_execute 1,43,675and command like that.
Why I cant watch update/select queries?
0
votes
1answer
516 views
Discrepancy in CPU time and reads in SQL Server profiler
I had performance degradation in our production database server which is SQL server 2016 and I saved the long running query using profiler as you can see
in the following picture:
CPU time = 65141, ...
3
votes
3answers
11k views
Delete query not deleting data
I am running a web service which connects to a SQL Server 2012 database. When executing multiple delete queries within a short space of time (around 5 in a second), it appears random which ones are ...
6
votes
1answer
5k views
How to profile Postgresql instance?
My Postgresql server is using 100% cpu. I am looking to figure out whether individual queries are slow or I am simply hammering the server with too many requests to begin with.
Is there some sort of ...
0
votes
1answer
949 views
Using SQL Server Profiler to track performance for nested stored procedure
I have a slow unit test (defined as a SQL script) executing stored procedures nested in other stored procdedures.
I'd like to know if SQL Server Profiler provides tracks for execution along the 'call ...
3
votes
2answers
2k views
SQL Profiler for Mac OS
Is there a SQL profiler MSSSQL that can be installed and run on Mac? It doesn't matter if it is a paid version as long as it can run on my Mac OS. Thanks.
0
votes
1answer
164 views
When using XE Profiler in SSMS 17.3, the 'Database Name' column shows as either NULL or an empty string
I'm just starting to use SSMS 17.3 - and one of the main things I was looking forward to trialing was XE Profiler.
However, when you start a session (either Standard or TSQ) and add the Database Name ...
1
vote
0answers
82 views
Determine tables / query from Missing Join Predicate event
On SQL Server 2008, in the profiler, I have a Missing Join Predicate event class that happened at 3:30am StartTime. How do I get more information? What query was being executed, or tables were being ...
0
votes
0answers
513 views
exec sp_execute followed by an int and other parameters?
I'm trying to figure out what is running on a SQL Server 2008 machine. When I profile the server the RPC:Starting shows various text data like this:
exec sp_execute 26,147964,122,N'43398.jtk'
exec ...
1
vote
0answers
98 views
Troubleshooting non-working Plan Guide in SQL Server 2008 R2
I have problems with a Plan Guide I have created in Microsoft SQL Server 2008 R2. The Plan guide is purposed for a performance issue in Microsoft Dynamics AX 2009 and forces a specific question to use ...
1
vote
0answers
93 views
Database performance stats
I have this request to collect some statistics on a database over a period of time.
Unique entries of the queries being run on a database from a application server ( Can be done with running a Trace ...
3
votes
2answers
133 views
Is this considered a “light load” trace to run on SQL Server Profiler
This is my first experience of using SQL Server (2012 Enterprise Edition) Profiler. I've set up a trace to log when views are being accessed on a particular database.
I'm running Profiler on my ...
8
votes
2answers
7k views
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?
5
votes
1answer
964 views
How do I use an OR in SQL Profiler for Column Filters
I am setting up a SQL Profiler and I wanted to have it filter on any items that have a duration > 30000 OR CPU > 10000 OR Writes > 1000
It seems like if I put those into the "column filter" area that ...
0
votes
1answer
973 views
MSSQL: High number of logical reads when inserting into fragmented heap
I'm inserting a batch of rows - using INSERT INTO tblUploadBanking SELECT FROM ... - into a table, which is a heap and have 3 narrow NC indexes.
When I execute the query from SSMS with SET ...
1
vote
1answer
310 views
Modern SQL Profiler against SQL 2000
In my current work position I've been given a desktop with SQL2014 tools installed including SQL Profiler. For some time we are still however supporting production SQL2000 machines and when using ...
1
vote
1answer
1k views
How to run SQL Profiler to monitor 1 specific stored procedure? [duplicate]
I have an issue where a stored procedure will run properly when executed from SQL Management Studio, but when the stored procedure is called from an application, it doesn't return the results to the ...
