Home Forums SQL Server 2017 SQL Server 2017 - Administration blocking for same query on user DB RE: blocking for same query on user DB

  • December 5, 2018 at 7:42 pm

    #2015621

    sqlguy80 - Friday, November 30, 2018 11:29 AM

    Grant Fritchey - Friday, November 30, 2018 10:37 AM

    If it's blocking itself is the query going to parallel execution? Check the execution plan to see what's going on with the query.

    Hi Grant,
    Strangely nothing out of ordinary in the exec plan , index seek , clustered index seek keylookup, small db, small row count on the table!
    Thanks

    Hi Grant ,
    Changing Cost threshold of parallelism from default 5 to 50, fixed this blocking and slowness. I ran the clear cache and drop clean buffers , not sure if it was needed but did it and its def faster now and I dont see any blocking of the SPID blocking itself which is insane!