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

Troubleshooting slow running query using Extended Events Wait info event

Extended Events introduced in SQL Server 2008 is a detailed event infrastructure for SQL Server. If your environment is running with more SQL Server’s of version > 2008, it is the right time to learn about Extended events since they help you a lot in troubleshooting SQL Server performance issues. In general there are two things possible in…

1

Different Status of a SPID in SQL Server and What do they mean

You can check the status of a SPID using any of these queries: SELECT status,* FROM sys.sysprocesses  SELECT status,* FROM sys.dm_exec_requests SELECT status,* FROM sys.dm_exec_sessions EXEC sp_who2  It should be noted that all these queries may not return the same amount of results. For ex: dm_exec_requests DMV returns information about requests that are currently executing (RUNNABLE and RUNNING) within SQL…

10