What is WRITELOG waittype and how to troubleshoot and fix this wait in SQL Server

<<This blog has been updated on 12/23/2014>> What does WRITELOG waittype mean? SQL Server Transaction Log entries are first written serially to in-memory structure called Log block and due to various conditions listed below in this blog, then the entire log block is flushed to disk. The size of this log block can be between 512…

4

Service Broker "Fire and Forget Scenario" and Memory Allocation failure

“Fire and Forget” is a scenario in Service Broker where Initiator starts a conversation -> Sends a message -> End Conversation without considering whether Target received and processed the message. In these scenarios, the Service Broker conversations get piled up which you can see by querying sys.conversation_endpoints. When you run the query below on the…

1