Create database causing a blocking event - by AgentJeff

Status : 

 


1
0
Sign in
to vote
ID 836900 Comments
Status Active Workarounds
Type Bug Repros 0
Opened 3/19/2014 1:03:58 PM
Access Restriction Public

Description

On sql2012 instance that is about one year, just recently when we create a new database it causes a blocking event to fire (configured at 5 second).  The blocking process is the create database statement, the blocked statement is a background spid 
here is what is the blocked process info:
<process id="processb59348928" taskpriority="0" logused="0" waitresource="KEY: 1:281474978086912 (b051f76746c5)" waittime="9315" ownerId="2049057964" transactionname="EnqueueGhostDbid" lasttranstarted="2014-03-19T14:07:55.467" XDES="0x8346cad00" lockMode="S" schedulerid="22" kpid="9604" status="background" spid="24" sbid="0" ecid="0" priority="0" trancount="0">

There are about 140 user databases.  We have other instances with more user databases and are not seeing this issue.
Sign in to post a comment.