Tag: blocking

  • Create database command blocks GHOST Clean-up process

    Problem: I was asked by a colleague that when he runs a create database statement with large initial sizes for database files , he was able to find the ghost clean-up process with SPID less than 50 ( system process) blocked by the create database statement by simply running the query sp_who2.