Skip to content

SQL-Articles

On Premise and Cloud Database Knowledge Base

Tag: create database

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.

Published July 25, 2011
Categorized as General Tagged blocking, create database, ghost cleanup

Recent Posts

  • CSSUG February 2020 Meet
  • CSSUG January 2020 Meet
  • CSSUG November 2019 Meet
  • CSSUG October 2019 Meet
  • Dropping a Subscriber from AG Publisher
SQL-Articles
Proudly powered by WordPress.