SQL Hung

  • haichells

    SSCrazy

    Points: 2689

    Dear All,

    My production sql server was hung on a specific day for about 2-3 hours. Can some one help how can i do the post mortem report and what has caused that issue. Thanks in Advance!

     

  • haichells

    SSCrazy

    Points: 2689

    What is this PDW & Poly Database movement about? I see some errors on those services in my SQL log.

  • Jeff Moden

    SSC Guru

    Points: 993661

    haichells wrote:

    What is this PDW & Poly Database movement about? I see some errors on those services in my SQL log.

     

    We can't see your logs.  You should post the errors so that people actually stand a better chance of helping.

    --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.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems

  • Grant Fritchey

    SSC Guru

    Points: 395230

    PDW is parallel data warehouse. It's a huge appliance that your company paid a ton of money for. Read about it here. Polybase is a way to query other database engines, Oracle and a bunch of others, directly from within SQL Server. Read about that here.

    As to understanding what happened on your system, since you're posting in the 2017 forum, we can take advantage of the system_health Extended Events session. Read about it here. It's going to show you a bunch of the stuff you need. What was hung, why, etc. However, it's not easy to dig through, so get ready to learn how to use the tools & data.

    Other than that, I'm with Jeff. I can't see your servers, logs, etc., so it's really hard to make any concrete suggestions.

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
    Theodore Roosevelt

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

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

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