I'm very new to SQL Server, and just wondered if anyone could tell me if this process list is normal.
Wait Time | Last Wait Type | dbid 55372252 | ONDEMAND_TASK_QUEUE | 1 55371504 | BROKER_TRANSMITTER | 1 55371504 | BROKER_TRANSMITTER | 1 55352380 | BROKER_EVENTHANDLER | 1 55351938 | KSOURCE_WAKEUP | 1 36413691 | XE_DISPATCHER_WAIT | 0 393368 | LOGMGR_QUEUE | 0 393367 | CHECKPOINT_QUEUE | 2 23258 | XE_TIMER_EVENT | 0
The server has been rebooted several times a day ago, which is what I think has caused the checkpoint restore messages to come up, db id 1 is Master and db 2 is tempdb.
As I understand it the checkpoint is when I have dirty pages which get written to the disk, but should this operation be taking as long as it is?