Home Dashboard Directory Help
Search

Create database causing a blocking event by AgentJeff


Status: 

Active


1
0
Sign in
to vote
Type: Bug
ID: 836900
Opened: 3/19/2014 1:03:58 PM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

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.
Details
Sign in to post a comment.
Sign in to post a workaround.