SPID is suspended but the wait type is NULL

• webrunner

  SSC-Dedicated

  Points: 31862

  More actions

  September 12, 2024 at 9:42 pm

  #4457096

  Hello experts,

  I have always assumed that if there is no wait going on for a SPID, that its status would be runnable. I have seen just now with a large insert query that my assumption is wrong.

  Could someone explain how a SPID remains suspended if the wait type is NULL?

  Thanks for any help!

  -- webrunner

  -------------------
  A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
  Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

• September 13, 2024 at 10:03 am

  This was removed by the editor as SPAM

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  September 13, 2024 at 10:10 pm

  #4457404

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• September 14, 2024 at 6:48 am

  This was removed by the editor as SPAM