Home Forums SQL Server 2012 SQL 2012 - General SPID Status SUSPENDED with MaxDOP = 1? I need to look back... RE: SPID Status SUSPENDED with MaxDOP = 1? I need to look back...

  • Thank you all for the quick replies.

    @sqlguru - Okay. I'd like to view that aggregate data if I can. Mostly I'm curious what the wait type was more than anything else. I don't need to drill into why as much as the wait type. It will give me a starting place. I don't know if I can get that from the "top SQL" scripting I have or not, but I have not tried yet either.

    @eric M Russel - Don't get me started on the application pieces of this to prevent the user from submitting multiple requests in succession! The Dev team is aware and they have promised to take care of it...eventually. As for the why it matters of the wait type is simply because I am trying to figure where to start on figuring this out. Honestly I'm kicking myself for not looking at it before killing the processes.

    @bmg002 - Yes, I want it in the application! Sadly I'm just the guy who gets strung up when performance tanks. Sometimes you're the hero and sometimes you're the goat.

    Regards, Irish