July 23, 2015 at 9:16 am
Does anyone know what QDS_SHUTDOWN_QUEUE Wait type is in SQL Server 2014? All I can find it is related to query store package and that it can be ignored by it is the top wait on this server.
The only thing running on this server is a job that restores 196 full/diff backups, performs DBCC CHECKDB then drops the database.
The job is now taking twice as long as it was taking last week. I've disabled the DBCC CHECK step which appears to be what's causing it to take longer and noted some improvement but I'm curious about this particular wait and DBCC CHECKDB. Does anybody know?
WaitTypeQDS_SHUTDOWN_QUEUE
Wait_Sec44402.37
Resource_Sec44401.28
Signal_Sec1.1
Wait Count741
Wait Percentage64.85
AvgWait_Sec59.9222
AvgRes_Sec59.9208
AvgSig_Sec0.0015
July 28, 2015 at 5:55 pm
Have you found anything online about this waittype? I have a new server that's showing this as the highest waittype
PatternSample EndedSeconds Samplewait_typeWait Time (Seconds)Signal Wait Time (Seconds)Percent Signal WaitsNumber of WaitsAvg ms Per Wait
WAIT STATS2015-07-28 19:50:01.54730QDS_SHUTDOWN_QUEUE60.00.00.0160000.0
Not a whole lot I can find online...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply