Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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

0
votes
0answers
21 views

Deferred Compile Event Subclass Meaning in SQL Profiler?

While tracing excessive recompilation (SQL:StmtRecompile) I found the main cause of it is 'Deferred Compile" as a event subclass. It is explained this way. Deferred compile occurs if an object ...
1
vote
1answer
34 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
24 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
62 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.
1
vote
1answer
29 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
40 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
34 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
48 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
0answers
26 views

Troubleshooting with extended events

In SQL Server Profiler, you can select all of the rows, and get the actual SQL that was executed and not just individual events. Do you see the text in red on the bottom of the image I posted? That ...
0
votes
1answer
36 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
124 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
45 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
57 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
42 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
53 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
27 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
53 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 ...
5
votes
0answers
119 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
460 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 ...
0
votes
1answer
91 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
132 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, ...
5
votes
3answers
2k 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 ...
1
vote
1answer
762 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
283 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 ...
1
vote
1answer
442 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
140 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
43 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
209 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
60 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 ...
0
votes
0answers
27 views

Phantom results from a DM or Missing results from Profiler Trace?

I was using a table that logs the results of querying dm_exec_procedure_stats every minute to identify activity of stored procedures on one of my servers. Basically it compares the database, object ...
1
vote
0answers
65 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
81 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 ...
5
votes
2answers
2k 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
281 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
401 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
170 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 ...
0
votes
0answers
94 views

SQL Server 13 repeating SET TRANSACTIONLEVEL

I am trying to run profile on an application and all I see every 3-5 seconds are the same 3-4 lines with 0 idea what these are. Extremely annoying as I have never seen these before and no open ...
1
vote
1answer
423 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 ...
2
votes
1answer
70 views

SQL server Profiler can be used any time?

I want to run SQL Profiler for Long running queries in SQL server 2016. what is the best practice, without effecting the SQL performance in less time and more productive?
27
votes
2answers
1k views

Empty blocking process in blocked process report

I'm collecting blocked process reports using Extended Events, and for some reason in some reports the blocking-process node is empty. This is the full xml: <blocked-process-report monitorLoop="...
3
votes
1answer
426 views

What interval does SQL Server Profiler's “duration” refer to?

I've been having strange things on a production server. Clients (all on the local LAN) are getting timeout errors on queries that should have no problem at all. it happens during times of low CPU ...
3
votes
0answers
68 views

Error with SQL Server profiler

I am having a strange problem with SQL Server Profiler. We have a .NET program running and collecting traces every hour and dumping into a central database. In a few instances, I see that the trace ...
3
votes
2answers
121 views

EventSequence in Trace using profiler

We have a stored procedure sp_foo that contains dynamic sql and at the end of sp_foo the dynamic sql is executed using EXECUTE (@query) While analyzing a trace profile i noticed that the Eventsquence ...
0
votes
1answer
57 views

Where can I get a SQL Server Trace Dataset? [closed]

I need a huge SQL Server query trace file (like the profiler trace) with the SQL query text and the time-stamp. I need a trace of SQL traffic produced by a real application because I want to do some ...
0
votes
1answer
795 views

How to trace steps in SQL profiler for only particular application

We are using a third party company's software that talks to a SQL Server database and retrieves and inserts all the information. When a user uses this software sometimes it freezes at a particular ...
1
vote
2answers
1k views

Does the 'reads' column in SQL Profiler mean the same as IOPS?

I just executed a query that went pretty fast and the SQL Profiler said it used 30.000 reads. Now I'm looking at this page: https://cloud.google.com/compute/docs/disks/performance and see that a ...
6
votes
2answers
667 views

Tracking down a transaction rollback

I have a very busy database and I've been asked to look for transactions that rollback. I used SQL Server Profiler to monitor the TM: Rollback Tran completed event, which shows me that dozens of ...
0
votes
1answer
205 views

Lots of small SQL statements in SQL Server and measuring network time between DB and Client

I am load testing an application and it appears from New Relic that each transaction executes a significant number SQL statements (approx 250). As we scale up, the service that makes these calls ...
0
votes
1answer
80 views

SQL trace events list

This german msdn article contains a list of trace events. This question sql-server-concise-list-of-trace-flags has a similar scope but differ from as the german msdn article. Below you can find a ...
3
votes
1answer
74 views

What exactly is SQL Server doing?

We have a control table called Generators which has a NextID and varchar label. I found some bad code in a stored procedure which assigns a value w/o a where clause - something like below. declare @...