Stack Overflow
Stack Overflow

Questions tagged [sql-server-profiler]

SQL Server Profiler is a rich interface to create and manage traces and analyze and replay trace results. The events are saved in a trace file that can later be analyzed or used to replay a specific series of steps when trying to diagnose a problem.

SQL Server Profiler is a tracing tool provided by Microsoft since SQL Server 2000 version. It is used to trace activities and operations executed on a specific SQL Server database engine or Analysis Service to be analyzed later.

References and helpful links

366 questions
-1
votes
1 answer

EF Core query is extremely slow. How do I improve it?

This query uses a lot of CPU and takes about 30 seconds to execute. What can I do in order to improve it? The reason it uses joins is because there weren't proper relationships. I just added ones and started to replace all repositories since this is…
nop
  • 4,711
  • 6
  • 32
  • 93
-1
votes
1 answer

Finding bottlenecks of ETL and Cube processing

I have an ETL and Cube solutions, which I process one after another in a SQL agent job. In ETL I run 1 package, that in turn one by one runs all other packages. Whole processing takes 10 hours. For ETL: How can I find out which package takes what…
rakamakafo
  • 1,144
  • 5
  • 21
  • 44
-1
votes
1 answer

How do I profile a single SP with SQL Server Profiler?

I'm trying to evaluate the relative performance of using a WHERE... IN clause in my SP vs UNIONs. I've tried looking at the execution time and using SET STATISTICS TIME ON but everything just comes back as taking 0ms all the time. So I'm trying to…
Legion
  • 3,922
  • 8
  • 51
  • 95
-1
votes
1 answer

sp duration does not equal the sum of statement duration in sql profiler

I have a sp which takes over 6000 ms in sql profiler, but when I looked at the statement execution duration in this sp, most of them are 0, the sum of statement execution time is far less than 6000, i have no idea where the 6000ms come from...…
zhangha2010
  • 11
  • 2
-2
votes
2 answers

EF Core 6 : inspection through profiler is shocking

I have inspected EF Core 6 through SQL Server Profiler which is shocking from a performance point of view. Here nothing profiled which is very good: var user = App.Ctx.LoginUsers; This code nothing profiled which is also very good: user =…
Sanjeeb
  • 1
  • 1
-2
votes
1 answer

Random slow query performance in SQL Server 2016

I will see you what is the problem... SELECT SUM(A.POSTEDQTY), SUM(A.POSTEDVALUE), SUM(A.PHYSICALVALUE), SUM(A.DEDUCTED), SUM(A.RECEIVED), SUM(A.RESERVPHYSICAL), SUM(A.RESERVORDERED), SUM(A.REGISTERED), …
TBP
  • 7
  • 3
1 2 3
…
24
25