Slowwwww running queries

• SQLAddict01

  SSC Eights!

  Points: 885

  More actions

  February 19, 2021 at 4:47 pm

  #3847391

  We upgrade to SQL 2019 a year back and from the past 2-3 months we are seeing performance issues

  We have enough of memory and CPU and the perfmon counters look good.

  Here's some activity on the server/database I captured when I tried to run a query which is taking 2 mins to run usually it takes less than 10 sec

  

  

  

  

  Here is the execution plan of the query that was running.

  

  If you could provide any insights that would be great.

   

  Thanks

   

   

  • This topic was modified 3 years, 2 months ago by  SQLAddict01.

• Jeff Moden

  SSC Guru

  Points: 1003861

  More actions

  February 20, 2021 at 2:13 am

  #3847576

  In the absence of any code, the one thing that might have helped me to help you was the Predicate listing.  So much for that, eh? 😉

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)