Post reply

Slowwwww running queries

  • 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, 10 months ago by  SQLAddict01.

  • 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)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply